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));
}
}
