public JsonResult getListExpedient(int?id)
        {
            var expedient = db.Expedient.Where(e => e.IdProject == id);
            List <ExpedientsMD> ListExpedient = new List <ExpedientsMD>();

            foreach (Expedient item in expedient)
            {
                ExpedientsMD itemExpe = ConvertExpedientSM(item);
                ListExpedient.Add(itemExpe);
            }

            return(Json(ListExpedient, JsonRequestBehavior.AllowGet));
        }
        //GET
        public ActionResult List(int id)
        {
            var expedient = db.Expedient.Where(e => e.IdProject == id);
            ExpedientProjectMD objProject = new ExpedientProjectMD();
            Project            project    = db.Project.Find(id);

            objProject.IdProject   = project.IdProject;
            objProject.CodProject  = project.CodProject;
            objProject.NameProject = project.NameProject;
            List <ExpedientsMD> ListExpedient = new List <ExpedientsMD>();


            objProject.ListExpendient = ListExpedient;

            foreach (Expedient item in expedient)
            {
                ExpedientsMD itemExpe = ConvertExpedientSM(item);
                ListExpedient.Add(itemExpe);
            }
            return(View(objProject));
        }
        private ExpedientsMD ConvertExpedientSM(Expedient expedient)
        {
            ExpedientsMD objExpedient = new ExpedientsMD();

            objExpedient.IdExpendient   = expedient.IdExpendient;
            objExpedient.IdProject      = expedient.IdProject;
            objExpedient.FileExpendient = expedient.FileExpendient;
            objExpedient.Predial        = expedient.Predial;
            objExpedient.NameDemandant  = expedient.NameDemandant;
            objExpedient.IdTypeProcess  = expedient.IdTypeProcess;
            objExpedient.Settled        = expedient.Settled;
            objExpedient.Court          = expedient.Court;
            objExpedient.Magistrate     = expedient.Magistrate;
            objExpedient.Resposible     = expedient.Resposible;
            objExpedient.Amount         = expedient.Amount;
            objExpedient.appraise       = expedient.appraise;
            objExpedient.DateCreate     = expedient.DateCreate;
            objExpedient.Advance        = expedient.Advance;
            objExpedient.Active         = expedient.Active;

            return(objExpedient);
        }