public IActionResult Create() { int Y = Convert.ToInt32(User.Claims.ToList().FirstOrDefault(x => x.Type == "reportDtYear").Value); int M = Convert.ToInt32(User.Claims.ToList().FirstOrDefault(x => x.Type == "reportDtMonth").Value); CtVetPlan tmp = new CtVetPlan() { KIDro = User.Claims.ToList().FirstOrDefault(x => x.Type == "KIDro").Value, PlanYr = DateTime.Today.Year, tfemage1_I = 0, tfemage2_I = 0, tfemage1_II = 0, tfemage2_II = 0, tfemage1_III = 0, tfemage2_III = 0, tfemage1_IV = 0, tfemage2_IV = 0, nPlan_I = 0, nPlan_II = 0, nPlan_III = 0, nPlan_IV = 0, nPlan = 0 }; ViewBag.PlanYearList = spDAL.PlanYearList(); ViewBag.KIDdivList = spDAL.KIDdivList(User.Claims.ToList().FirstOrDefault(x => x.Type == "KIDro").Value); ViewBag.KIDspcList = spDAL.KIDspcList(); ViewBag.KIDdisList = spDAL.KIDdisList(); ViewBag.KIDtrtList = spDAL.KIDtrtList(); ViewBag.KIDtestList = spDAL.testList(); ViewBag.Page = "CtVetPlan"; return(View(tmp)); }
public static void Update_CtVetPlan(CtVetPlan tmp) { using (SqlConnection _conn = new SqlConnection(spDAL.connStr)) { tmp.nPlan_I = tmp.tfemage1_I + tmp.tfemage2_I; tmp.nPlan_II = tmp.tfemage1_II + tmp.tfemage2_II; tmp.nPlan_III = tmp.tfemage1_III + tmp.tfemage2_III; tmp.nPlan_IV = tmp.tfemage1_IV + tmp.tfemage2_IV; tmp.nPlan = tmp.nPlan_I + tmp.nPlan_II + tmp.nPlan_III + tmp.nPlan_IV; _conn.Update <CtVetPlan>(tmp); } }
public IActionResult Edit(Guid id, [Bind] CtVetPlan tmp) { if (id == null) { return(NotFound()); } if (ModelState.IsValid) { //if(BioPrepDAL.IsUniqueRecord(objBioPrep)) //tmp.nPlan = tmp.nPlan_I+tmp.nPlan_II+tmp.nPlan_III+tmp.nPlan_IV; ctVetPlanDAL.Update_CtVetPlan(tmp); return(RedirectToAction("Index")); } ViewBag.Page = "CtVetPlan"; return(View(tmp)); }
public IActionResult Delete(Guid id) { if (id == null) { return(NotFound()); } CtVetPlan tmp = ctVetPlanDAL.GetById_CtVetPlan(id); if (tmp == null) { return(NotFound()); } ViewBag.KIDdisDisplay = spDAL.KIDdisName(tmp.KIDdis); ViewBag.KIDdisDisplay = spDAL.KIDdisName(tmp.KIDdis); ViewBag.KIDspcDisplay = spDAL.KIDspcName(tmp.KIDspc); ViewBag.KIDtrtDisplay = spDAL.KIDtrtName(tmp.KIDtrt); ViewBag.Page = "BioPrep"; return(View(tmp)); }
public IActionResult Create([Bind] CtVetPlan tmp) { if (ModelState.IsValid) { //проверка на существования аналогичной записи //if (CtVetPlan.IsUniqueRecord(tmp)) // CtVet1cDAL.Add_CtVet1c(tmp); //else //{ // TempData["EM"] = "Такая запись уже существует"; //return LocalRedirect("~/Home/Error"); //return RedirectToAction("Error"); //}; //------------------ ctVetPlanDAL.Add_CtVetPlan(tmp); ViewBag.Page = "CtVetPlan"; return(RedirectToAction("Index")); } ViewBag.Page = "CtVetPlan"; return(View(tmp)); }
public IActionResult Edit(Guid id) { if (id == null) { return(NotFound()); } CtVetPlan tmp = ctVetPlanDAL.GetById_CtVetPlan(id); if (tmp == null) { return(NotFound()); } ViewBag.PlanYearList = spDAL.PlanYearList(); ViewBag.KIDdivList = spDAL.KIDdivList(User.Claims.ToList().FirstOrDefault(x => x.Type == "KIDro").Value); ViewBag.KIDspcList = spDAL.KIDspcList(); ViewBag.KIDdisList = spDAL.KIDdisList(); ViewBag.KIDtrtList = spDAL.KIDtrtList(); ViewBag.KIDtestList = spDAL.testList(); ViewBag.Page = "CtVetPlan"; return(View(tmp)); }