// 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),
                            Sender = db.GetLoginByUserId(item.sender_id).FirstOrDefault(),
                            Receiver = db.GetLoginByUserId(item.recv_id).FirstOrDefault(),
                            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);
        }

ICAgICAgICAvLyBHRVQ6IC9Db250cmFjdHMvSW5kb3gKCiAgICAgICAgcHVibGljIEFjdGlvblJlc3VsdCBJbmJveCgpCiAgICAgICAgewogICAgICAgICAgICBpZiAoUmVxdWVzdC5Db29raWVzWyJzZXNzaW9uLWlkIl0gPT0gbnVsbCkKICAgICAgICAgICAgewogICAgICAgICAgICAgICAgUmVzcG9uc2UuUmVkaXJlY3QoIi8iKTsKICAgICAgICAgICAgICAgIHJldHVybiBudWxsOwogICAgICAgICAgICB9CgogICAgICAgICAgICBMaXN0PE1vZGVscy5Db250cmFjdFBsYWluPiBjdXJyZW50Q29udHJhY3RzID0gbmV3IExpc3Q8TW9kZWxzLkNvbnRyYWN0UGxhaW4+KCk7CgogICAgICAgICAgICB0cnkKICAgICAgICAgICAgewogICAgICAgICAgICAgICAgdmFyIGN1cnJlbnRVc2VySWQgPSBkYi5HZXRVc2VySWRCeUxvZ2luKFJlcXVlc3QuQ29va2llc1sidXNlci1uYW1lIl0uVmFsdWUpOwogICAgICAgICAgICAgICAgaW50IHJlc3VsdFZhbHVlID0gQ29udmVydC5Ub0ludDMyKGN1cnJlbnRVc2VySWQuRmlyc3RPckRlZmF1bHQoKSk7CgogICAgICAgICAgICAgICAgZm9yZWFjaCAodmFyIGl0ZW0gaW4gZGIuY29udHJhY3RzKQogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGlmIChpdGVtLnJlY3ZfaWQgPT0gcmVzdWx0VmFsdWUpCiAgICAgICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgICAgICB2YXIgcmVjb3JkID0gbmV3IE1vZGVscy5Db250cmFjdFBsYWluCiAgICAgICAgICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICAgICAgICAgIElkID0gaXRlbS5pZCwKICAgICAgICAgICAgICAgICAgICAgICAgICAgIENvbnRyYWN0R3VpZCA9IEd1aWQuUGFyc2UoaXRlbS5ndWlkKSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgIFNlbmRlciA9IGRiLkdldExvZ2luQnlVc2VySWQoaXRlbS5zZW5kZXJfaWQpLkZpcnN0T3JEZWZhdWx0KCksCiAgICAgICAgICAgICAgICAgICAgICAgICAgICBSZWNlaXZlciA9IGRiLkdldExvZ2luQnlVc2VySWQoaXRlbS5yZWN2X2lkKS5GaXJzdE9yRGVmYXVsdCgpLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgQ29udHJhY3RUeXBlID0gQ29udmVydC5Ub0ludDMyKGl0ZW0udHlwZSksCiAgICAgICAgICAgICAgICAgICAgICAgICAgICBDb250cmFjdFN0YXR1cyA9IGl0ZW0uc3RhdHVzLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgQ3JlYXRlZFRpbWUgPSBEYXRlVGltZS5QYXJzZShpdGVtLmRhdGVfY3JlYXRlZCksCiAgICAgICAgICAgICAgICAgICAgICAgICAgICBDcmVkaXRFbmQgPSBEYXRlVGltZS5QYXJzZShpdGVtLmRhdGVfY3JlZGl0X2VuZCkKICAgICAgICAgICAgICAgICAgICAgICAgfTsKCiAgICAgICAgICAgICAgICAgICAgICAgIGN1cnJlbnRDb250cmFjdHMuQWRkKHJlY29yZCk7CiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICB9CiAgICAgICAgICAgIGNhdGNoIChFeGNlcHRpb24gZXhjKQogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBleGMuVG9TdHJpbmcoKTsKICAgICAgICAgICAgfQoKICAgICAgICAgICAgcmV0dXJuIFZpZXcoY3VycmVudENvbnRyYWN0cyk7CiAgICAgICAgfQ==