public ActionResult Delete(int id, CS_tbWorkTypeViewModel collection) { try { using (OnlineShopDbContext db = new OnlineShopDbContext()) { CS_tbWorkTypeViewModel model = new CS_tbWorkTypeViewModel(); CS_tbWorkType Exsiting_WorkType = db.CS_tbWorkType.Find(id); db.CS_tbWorkType.Remove(Exsiting_WorkType); db.SaveChanges(); //--------Add Dropdown for MainProjectName-------------------// model.CS_tbViTri = db.CS_tbViTri.OrderBy(m => m.ID).ToList(); model.WorkTypeMain_All = new List <SelectListItem>(); var items = new List <SelectListItem>(); foreach (var CS_WorkType_Main in model.CS_tbViTri) { items.Add(new SelectListItem() { Value = CS_WorkType_Main.ID.ToString(), Text = CS_WorkType_Main.CS_ViTri, }); } model.WorkTypeMain_All = items; //--------Add Dropdown for MainProjectName-------------------// return(View("Finish", model)); } } catch { return(View()); } }
// // GET: /CS_tbWorkCount/Details/5 public ActionResult Details(int id) { using (OnlineShopDbContext db = new OnlineShopDbContext()) { CS_tbWorkCountViewModels model = new CS_tbWorkCountViewModels(); //--------Select ID trả kết quả về View-----------// model.CS_tbWorkCount_Select = db.CS_tbWorkCount.Find(id); model.CS_tbWorkCount_Sub = db.CS_tbWorkCount_Sub.Where(m => m.CS_tbWorkCount_ID == id).ToList(); model.CS_tbLLTCTypeSub = new List <CS_tbLLTCTypeSub>(); model.LLTC_temp = new List <LLTC>(); model.CS_tbWorkType_temp = new List <CS_tbWorkType>(); int j = 0; foreach (var CS_tbWorkCount_Sub in model.CS_tbWorkCount_Sub) { CS_tbLLTCTypeSub obj_temp = db.CS_tbLLTCTypeSub.Find(CS_tbWorkCount_Sub.CS_tbLLTCTypeSub_ID); model.CS_tbLLTCTypeSub.Add(obj_temp); LLTC obj_temp_2 = db.LLTCs.Find(CS_tbWorkCount_Sub.CS_LLTC_ID); model.LLTC_temp.Add(obj_temp_2); CS_tbWorkType obj_temp_3 = db.CS_tbWorkType.Find(model.CS_tbLLTCTypeSub[j].CS_tbLLTCNameJobDetailsSub); model.CS_tbWorkType_temp.Add(obj_temp_3); j++; } return(View("Details", model)); } }
public ActionResult Create(CS_tbWorkTypeViewModel collection) { try { using (OnlineShopDbContext db = new OnlineShopDbContext()) { CS_tbWorkType obj = new CS_tbWorkType(); CS_tbWorkTypeViewModel model = new CS_tbWorkTypeViewModel(); model.CS_tbWorkType = db.CS_tbWorkType.OrderBy(m => m.ID).ToList(); obj.CoreWorkType = collection.CS_tbWorkTypeSelect.CoreWorkType; obj.SubWorkType = collection.CS_tbWorkTypeSelect.SubWorkType; db.CS_tbWorkType.Add(obj); db.SaveChanges(); //--------Add Dropdown for MainProjectName-------------------// model.CS_tbViTri = db.CS_tbViTri.OrderBy(m => m.ID).ToList(); model.WorkTypeMain_All = new List <SelectListItem>(); var items = new List <SelectListItem>(); foreach (var CS_WorkType_Main in model.CS_tbViTri) { items.Add(new SelectListItem() { Value = CS_WorkType_Main.ID.ToString(), Text = CS_WorkType_Main.CS_ViTri, }); } model.WorkTypeMain_All = items; //--------Add Dropdown for MainProjectName-------------------// return(View("Create", model)); } } catch { using (OnlineShopDbContext db = new OnlineShopDbContext()) { CS_tbWorkTypeViewModel model = new CS_tbWorkTypeViewModel(); model.CS_tbWorkType = db.CS_tbWorkType.OrderBy(m => m.ID).ToList(); //--------Add Dropdown for MainProjectName-------------------// model.CS_tbViTri = db.CS_tbViTri.OrderBy(m => m.ID).ToList(); model.WorkTypeMain_All = new List <SelectListItem>(); var items = new List <SelectListItem>(); foreach (var CS_WorkType_Main in model.CS_tbViTri) { items.Add(new SelectListItem() { Value = CS_WorkType_Main.ID.ToString(), Text = CS_WorkType_Main.CS_ViTri, }); } model.WorkTypeMain_All = items; //--------Add Dropdown for MainProjectName-------------------// return(View("Create", model)); } } }
public ActionResult DetailsEditGet(int id, CS_tbWorkCountViewModels collection) { using (OnlineShopDbContext db = new OnlineShopDbContext()) { CS_tbWorkCountViewModels model = new CS_tbWorkCountViewModels(); foreach (var CS_tbWorkCount_Sub_Temp in collection.CS_tbWorkCount_Sub) { CS_tbWorkCount_Sub obj = db.CS_tbWorkCount_Sub.Find(CS_tbWorkCount_Sub_Temp.ID); obj.CS_tbNumberDailyCount = CS_tbWorkCount_Sub_Temp.CS_tbNumberDailyCount; db.SaveChanges(); } //--------Select ID trả kết quả về View-----------// model.CS_tbWorkCount_Select = db.CS_tbWorkCount.Find(id); model.CS_tbWorkCount_Sub = db.CS_tbWorkCount_Sub.Where(m => m.CS_tbWorkCount_ID == id).ToList(); int mTotalCount = 0; foreach (var CS_tbWorkCount_Sub in model.CS_tbWorkCount_Sub) { mTotalCount = mTotalCount + (int)CS_tbWorkCount_Sub.CS_tbNumberDailyCount; } CS_tbWorkCount objTotalCount = db.CS_tbWorkCount.Find(id); objTotalCount.tb_mTotalCount = mTotalCount; db.SaveChanges(); model.CS_tbLLTCTypeSub = new List <CS_tbLLTCTypeSub>(); model.LLTC_temp = new List <LLTC>(); model.CS_tbWorkType_temp = new List <CS_tbWorkType>(); int j = 0; model.CS_tbWorkCount_Sub = db.CS_tbWorkCount_Sub.Where(m => m.CS_tbWorkCount_ID == id).ToList(); foreach (var CS_tbWorkCount_Sub in model.CS_tbWorkCount_Sub) { CS_tbLLTCTypeSub obj_temp = db.CS_tbLLTCTypeSub.Find(CS_tbWorkCount_Sub.CS_tbLLTCTypeSub_ID); model.CS_tbLLTCTypeSub.Add(obj_temp); LLTC obj_temp_2 = db.LLTCs.Find(CS_tbWorkCount_Sub.CS_LLTC_ID); model.LLTC_temp.Add(obj_temp_2); CS_tbWorkType obj_temp_3 = db.CS_tbWorkType.Find(model.CS_tbLLTCTypeSub[j].CS_tbLLTCNameJobDetailsSub); model.CS_tbWorkType_temp.Add(obj_temp_3); j++; } return(View("Details", model)); } }