public ActionResult Mails()
        {
            var mng = new ContractsManager();

            ViewBag.ListStatuses = mng.GetStatusesMail();
            return(View());
        }
        public ActionResult CreateMails(string treckNumber, string from, string to, string systemMail, string desc)
        {
            var mng      = new ContractsManager();
            int statusID = 1;
            var item     = new Mikhailova_mails
            {
                id                = 0,
                treckNumber       = treckNumber,
                date              = DateTime.Now.Date,
                from              = from,
                to                = to,
                statusID          = statusID,
                systemMail        = systemMail,
                treckNumberReplay = "",
                dateReplay        = DateTime.Now.Date,
                desc              = desc
            };

            mng.SaveMail(item);
            return(Json(new
            {
                result = item.id > 0,
                savedID = item.id,
            }, JsonRequestBehavior.AllowGet));
        }
        public ActionResult Templates()
        {
            var mng = new ContractsManager();

            ViewBag.DocTypes = mng.GetDocTypes();
            return(View());
        }
        public ActionResult TemplateEdit(Mikhailova_docTypeTemplates item)
        {
            var mng = new ContractsManager();

            mng.SaveDocTypeTemplate(item);
            return(Json(new { result = true }));
        }
        public ActionResult EditInvoice(Mikhailova_invoices item)
        {
            var mng = new ContractsManager();

            mng.SaveInvoice(item);

            return(Json(new { result = true }));
        }
        public ActionResult EditMails(Mikhailova_mails item)
        {
            var mng = new ContractsManager();

            mng.SaveMail(item);

            return(Json(new { result = true }));
        }
        public ActionResult Invoices()
        {
            var mng = new ContractsManager();

            ViewBag.ListContagent = mng.GetContagents();
            ViewBag.ListStatuses  = mng.GetStatusesInvoice();
            return(View());
        }
        public ActionResult Contracts()
        {
            var mng = new ContractsManager();

            ViewBag.ListType      = mng.GetDocTypes();
            ViewBag.ListTemplate  = mng.GetDocTypeTemplates();
            ViewBag.ListContagent = mng.GetContagents();
            ViewBag.ListStatuses  = mng.GetStatusesContract();
            return(View());
        }
        public ActionResult TemplatesInline(int pk, string value, string name)
        {
            var mng = new ContractsManager();

            mng.EditTemplateField(pk, name, value);
            return(Json(new
            {
                result = true
            }));
        }
        public ActionResult GetTemplate(int id)
        {
            var mng  = new ContractsManager();
            var item = mng.GetDocTypeTemplate(id);

            return(Json(new
            {
                id = item.id,
                name = item.name,
                typeID = item.typeID,
                path = item.path,
                ord = item.ord,
            }));
        }
        public ActionResult GetInvoice(int id)
        {
            var mng  = new ContractsManager();
            var item = mng.GetInvoice(id);

            return(Json(new
            {
                id = item.id,
                number = item.number,
                statusID = item.statusID,
                contagentID = item.contagentID,
                date = item.date.ToString("dd.MM.yyyy"),
                desc = item.desc
            }));
        }
        public ActionResult CreateTemplate(string name, int typeID, string path, int ord)
        {
            var mng  = new ContractsManager();
            var item = new Mikhailova_docTypeTemplates {
                id = 0, name = name, typeID = typeID, path = path, ord = ord
            };

            mng.SaveDocTypeTemplate(item);

            return(Json(new
            {
                result = item.id > 0,
                savedID = item.id,
            }, JsonRequestBehavior.AllowGet));
        }
        public ActionResult GetListTemplatesByTypeId(int typeId)
        {
            var mng   = new ContractsManager();
            var items = mng.GetListTemplatesByType(typeId);

            return(Json(new
            {
                result = items.Select(x => new
                {
                    id = x.id,
                    path = x.path,
                    name = x.name,
                    typeId = x.typeID
                }
                                      )
            }));
        }
        public ActionResult Templates_remove(int id)
        {
            var res = false;
            var mng = new ContractsManager();

            var item = mng.GetDocTypeTemplate(id);

            if (item != null)
            {
                mng.DeleteDocTypeTemplate(id);
                res = true;
            }

            return(Json(new
            {
                result = res,
                msg = "Шаблон удален!"
            }));
        }
        public ActionResult GetMail(int id)
        {
            var mng  = new ContractsManager();
            var item = mng.GetMail(id);

            return(Json(new
            {
                id = item.id,
                treckNumber = item.treckNumber,
                from = item.from,
                to = item.to,
                statusID = item.statusID,
                systemMail = item.systemMail,
                date = item.date.ToString("dd.MM.yyyy"),
                treckNumberReplay = item.treckNumberReplay,
                dateReplay = item.dateReplay,  //.ToString("dd.MM.yyyy"),
                desc = item.desc
            }));
        }
        public ActionResult GetContract(int id)
        {
            var mng  = new ContractsManager();
            var item = mng.GetContract(id);

            item.path = CopyFileOnFolderID(item.id, item.path);

            return(Json(new
            {
                id = item.id,
                number = item.number,
                path = item.path,
                typeID = item.typeID,
                statusID = item.statusID,
                contagentID = item.contagentID,
                date = item.date.ToString("dd.MM.yyyy"),
                summa = item.summa,
                desc = item.desc
            }));
        }
        public ActionResult CreateInvoice(string number, int contagentID, string desc)
        {
            var mng      = new ContractsManager();
            int statusID = 1;
            var item     = new Mikhailova_invoices
            {
                id          = 0,
                number      = number,
                date        = DateTime.Now.Date,
                statusID    = statusID,
                contagentID = contagentID,
                desc        = desc
            };

            mng.SaveInvoice(item);
            return(Json(new
            {
                result = item.id > 0,
                savedID = item.id,
            }, JsonRequestBehavior.AllowGet));
        }
        public ActionResult CreateContract(string number, string path, int typeID, int contagentID, string desc, decimal summa)
        {
            var mng      = new ContractsManager();
            int statusID = 1;
            var item     = new Mikhailova_contracts
            {
                id          = 0,
                number      = number,
                date        = DateTime.Now.Date,
                path        = path,
                typeID      = typeID,
                statusID    = statusID,
                contagentID = contagentID,
                summa       = summa,
                desc        = desc
            };

            mng.SaveContract(item);
            return(Json(new
            {
                result = item.id > 0,
                savedID = item.id,
            }, JsonRequestBehavior.AllowGet));
        }