using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace MvcApplication6.Controllers
{
public class ContractsController : Controller
{
private MySqlEntities db = new MySqlEntities();
//
// GET: /Contracts
public ActionResult Index()
{
return RedirectToAction("Inbox");
}
//
// GET: /Contracts/Indox
public ActionResult Inbox()
{
if (Request.Cookies["session-id"] == null)
{
Response.Redirect("/");
return null;
}
List<Models.ContractPlain> currentContracts = new List<Models.ContractPlain>();
try
{
var currentUserId = db.GetUserIdByLogin(Request.Cookies["user-name"].Value);
int resultValue = Convert.ToInt32(currentUserId.FirstOrDefault());
foreach (var item in db.contracts)
{
if (item.recv_id == resultValue)
{
var record = new Models.ContractPlain
{
Id = item.id,
ContractGuid = Guid.Parse(item.guid),
SenderId = Convert.ToInt32(item.sender_id),
RecvId = Convert.ToInt32(item.recv_id),
ContractType = Convert.ToInt32(item.type),
ContractStatus = item.status,
CreatedTime = DateTime.Parse(item.date_created),
CreditEnd = DateTime.Parse(item.date_credit_end)
};
currentContracts.Add(record);
}
}
}
catch (Exception exc)
{
exc.ToString();
}
return View(currentContracts);
}
}
}
dXNpbmcgU3lzdGVtOwp1c2luZyBTeXN0ZW0uQ29sbGVjdGlvbnMuR2VuZXJpYzsKdXNpbmcgU3lzdGVtLkxpbnE7CnVzaW5nIFN5c3RlbS5XZWI7CnVzaW5nIFN5c3RlbS5XZWIuTXZjOwoKbmFtZXNwYWNlIE12Y0FwcGxpY2F0aW9uNi5Db250cm9sbGVycwp7CiAgICBwdWJsaWMgY2xhc3MgQ29udHJhY3RzQ29udHJvbGxlciA6IENvbnRyb2xsZXIKICAgIHsKICAgICAgICBwcml2YXRlIE15U3FsRW50aXRpZXMgZGIgPSBuZXcgTXlTcWxFbnRpdGllcygpOwoKICAgICAgICAvLwogICAgICAgIC8vIEdFVDogL0NvbnRyYWN0cwoKICAgICAgICBwdWJsaWMgQWN0aW9uUmVzdWx0IEluZGV4KCkKICAgICAgICB7CiAgICAgICAgICAgIHJldHVybiBSZWRpcmVjdFRvQWN0aW9uKCJJbmJveCIpOwogICAgICAgIH0KCiAgICAgICAgLy8KICAgICAgICAvLyBHRVQ6IC9Db250cmFjdHMvSW5kb3gKCiAgICAgICAgcHVibGljIEFjdGlvblJlc3VsdCBJbmJveCgpCiAgICAgICAgewogICAgICAgICAgICBpZiAoUmVxdWVzdC5Db29raWVzWyJzZXNzaW9uLWlkIl0gPT0gbnVsbCkKICAgICAgICAgICAgewogICAgICAgICAgICAgICAgUmVzcG9uc2UuUmVkaXJlY3QoIi8iKTsKICAgICAgICAgICAgICAgIHJldHVybiBudWxsOwogICAgICAgICAgICB9CgogICAgICAgICAgICBMaXN0PE1vZGVscy5Db250cmFjdFBsYWluPiBjdXJyZW50Q29udHJhY3RzID0gbmV3IExpc3Q8TW9kZWxzLkNvbnRyYWN0UGxhaW4+KCk7CgogICAgICAgICAgICB0cnkKICAgICAgICAgICAgewogICAgICAgICAgICAgICAgdmFyIGN1cnJlbnRVc2VySWQgPSBkYi5HZXRVc2VySWRCeUxvZ2luKFJlcXVlc3QuQ29va2llc1sidXNlci1uYW1lIl0uVmFsdWUpOwogICAgICAgICAgICAgICAgaW50IHJlc3VsdFZhbHVlID0gQ29udmVydC5Ub0ludDMyKGN1cnJlbnRVc2VySWQuRmlyc3RPckRlZmF1bHQoKSk7CgogICAgICAgICAgICAgICAgZm9yZWFjaCAodmFyIGl0ZW0gaW4gZGIuY29udHJhY3RzKQogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGlmIChpdGVtLnJlY3ZfaWQgPT0gcmVzdWx0VmFsdWUpCiAgICAgICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgICAgICB2YXIgcmVjb3JkID0gbmV3IE1vZGVscy5Db250cmFjdFBsYWluCiAgICAgICAgICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICAgICAgICAgIElkID0gaXRlbS5pZCwKICAgICAgICAgICAgICAgICAgICAgICAgICAgIENvbnRyYWN0R3VpZCA9IEd1aWQuUGFyc2UoaXRlbS5ndWlkKSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgIFNlbmRlcklkID0gQ29udmVydC5Ub0ludDMyKGl0ZW0uc2VuZGVyX2lkKSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgIFJlY3ZJZCA9IENvbnZlcnQuVG9JbnQzMihpdGVtLnJlY3ZfaWQpLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgQ29udHJhY3RUeXBlID0gQ29udmVydC5Ub0ludDMyKGl0ZW0udHlwZSksCiAgICAgICAgICAgICAgICAgICAgICAgICAgICBDb250cmFjdFN0YXR1cyA9IGl0ZW0uc3RhdHVzLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgQ3JlYXRlZFRpbWUgPSBEYXRlVGltZS5QYXJzZShpdGVtLmRhdGVfY3JlYXRlZCksCiAgICAgICAgICAgICAgICAgICAgICAgICAgICBDcmVkaXRFbmQgPSBEYXRlVGltZS5QYXJzZShpdGVtLmRhdGVfY3JlZGl0X2VuZCkKICAgICAgICAgICAgICAgICAgICAgICAgfTsKCiAgICAgICAgICAgICAgICAgICAgICAgIGN1cnJlbnRDb250cmFjdHMuQWRkKHJlY29yZCk7CiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICB9CiAgICAgICAgICAgIGNhdGNoIChFeGNlcHRpb24gZXhjKQogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBleGMuVG9TdHJpbmcoKTsKICAgICAgICAgICAgfQoKICAgICAgICAgICAgcmV0dXJuIFZpZXcoY3VycmVudENvbnRyYWN0cyk7CiAgICAgICAgfQogICAgfQp9