public ActionResult Invoices_save()
        {
            var parameters = AjaxModel.GetAjaxParameters(HttpContext);
            var mng        = new GurevskiyRepository();
            var res        = false;
            int savedID    = 0;

            try
            {
                var fields = (parameters["fields"] as ArrayList).ToArray().ToList().Select(x => x as Dictionary <string, object>).ToList();

                var id        = RDL.Convert.StrToInt(AjaxModel.GetValueFromSaveField("id", fields), 0);
                var created   = RDL.Convert.StrToDateTime(AjaxModel.GetValueFromSaveField("date", fields), DateTime.Now);
                var number    = AjaxModel.GetValueFromSaveField("number", fields);
                var statusID  = RDL.Convert.StrToInt(AjaxModel.GetValueFromSaveField("statusName", fields), 0);
                var partnerID = RDL.Convert.StrToInt(AjaxModel.GetValueFromSaveField("partnerName", fields), 0);
                var comment   = AjaxModel.GetValueFromSaveField("comment", fields);

                var item = new gurevskiy_invoices {
                    id = id, statusID = statusID, partnerID = partnerID, date = created, number = number, comment = comment
                };
                res     = mng.SaveInvoice(item);
                savedID = item.id;
            }
            catch
            {
                res = false;
            }
            return(Json(new
            {
                result = res,
                savedID = savedID,
                msg = ""
            }, JsonRequestBehavior.AllowGet));
        }
        // GET: Gurevskiy
        public ActionResult Index()
        {
            var mng = new GurevskiyRepository();

            ViewBag.Partners       = mng.GetPartners();
            ViewBag.ContractTypes  = mng.GetContractTypes();
            ViewBag.ContractStatus = mng.GetContractStatuses();
            ViewBag.InvoiceStatus  = mng.GetInvoiceStatuses();
            ViewBag.MailStatus     = mng.GetMailStatuses();

            return(View());
        }
        public ActionResult Mails_save()
        {
            var parameters = AjaxModel.GetAjaxParameters(HttpContext);
            var mng        = new GurevskiyRepository();
            var res        = false;
            int savedID    = 0;

            try
            {
                var fields = (parameters["fields"] as ArrayList).ToArray().ToList().Select(x => x as Dictionary <string, object>).ToList();

                var id              = RDL.Convert.StrToInt(AjaxModel.GetValueFromSaveField("id", fields), 0);
                var statusID        = RDL.Convert.StrToInt(AjaxModel.GetValueFromSaveField("statusName", fields), 0);
                var created         = RDL.Convert.StrToDateTime(AjaxModel.GetValueFromSaveField("date", fields), DateTime.Now);
                var from            = AjaxModel.GetValueFromSaveField("from", fields);
                var to              = AjaxModel.GetValueFromSaveField("to", fields);
                var desc            = AjaxModel.GetValueFromSaveField("desc", fields);
                var systemSending   = AjaxModel.GetValueFromSaveField("systemSending", fields);
                var numberTrack     = AjaxModel.GetValueFromSaveField("numberTrack", fields);
                var numberTrackBack = AjaxModel.GetValueFromSaveField("numberTrackBack", fields);
                var dateBack        = RDL.Convert.StrToDateTime(AjaxModel.GetValueFromSaveField("dateBack", fields), (DateTime)System.Data.SqlTypes.SqlDateTime.Null);

                var item = new gurevskiy_mails {
                    id = id, statusID = statusID, date = created, from = from, to = to, desc = desc, systemSending = systemSending, numberTrack = numberTrack, numberTrackBack = numberTrackBack, dateBack = dateBack
                };
                res     = mng.SaveMail(item);
                savedID = item.id;
            }
            catch
            {
                res = false;
            }
            return(Json(new
            {
                result = res,
                savedID = savedID,
                msg = ""
            }, JsonRequestBehavior.AllowGet));
        }
        public ActionResult Mails_remove(int id)
        {
            var res = false;
            var mng = new GurevskiyRepository();
            var msg = "Ошибка удаления почты!";

            var item = mng.GetMail(id);

            if (item != null)
            {
                res = mng.DeleteMail(id);
                if (res)
                {
                    msg = "Почта удалена!";
                }
            }

            return(Json(new
            {
                result = res,
                msg = msg
            }));
        }
        public ActionResult Invoices_remove(int id)
        {
            var res = false;
            var mng = new GurevskiyRepository();
            var msg = "Ошибка удаления счета!";

            var item = mng.GetInvoice(id);

            if (item != null)
            {
                res = mng.DeleteInvoice(id);
                if (res)
                {
                    msg = "Счет удален!";
                }
            }

            return(Json(new
            {
                result = res,
                msg = msg
            }));
        }
        public ActionResult Contracts_remove(int id)
        {
            var res = false;
            var mng = new GurevskiyRepository();
            var msg = "Ошибка удаления контракта!";

            var item = mng.GetContract(id);

            if (item != null)
            {
                res = mng.DeleteContract(id);
                if (res)
                {
                    msg = "Контракт удален!";
                }
            }

            return(Json(new
            {
                result = res,
                msg = msg
            }));
        }