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);
        }
    }
}