public ActionResult Delete(int id, CS_tbWorkCountViewModels collection)
{
try
{
using (OnlineShopDbContext db = new OnlineShopDbContext())
{
CS_tbWorkCountViewModels model = new CS_tbWorkCountViewModels();
CS_tbWorkCount Exsiting_CS_tbWorkCount = db.CS_tbWorkCount.Find(id);
db.CS_tbWorkCount.Remove(Exsiting_CS_tbWorkCount);
db.SaveChanges();
model.CS_tbWorkCount_Select = db.CS_tbWorkCount.Find(id);
model.CS_tbWorkCount = db.CS_tbWorkCount.OrderBy(m => m.ID).ToList();
//--------Add Dropdown for ProjectName-------------------//
model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList();
model.Project_Name_All = new List <SelectListItem>();
var items = new List <SelectListItem>();
foreach (var CS_Project_Name in model.Thiet_Bi)
{
items.Add(new SelectListItem()
{
Value = CS_Project_Name.ID.ToString(),
Text = CS_Project_Name.Ten_Thiet_Bi,
});
}
model.Project_Name_All = items;
//--------Add Dropdown for ProjectName-------------------//
return(View("Finish", model));
}
}
catch
{
using (OnlineShopDbContext db = new OnlineShopDbContext())
{
CS_tbWorkCountViewModels model = new CS_tbWorkCountViewModels();
model.CS_tbWorkCount_Select = db.CS_tbWorkCount.Find(id);
model.CS_tbWorkCount = db.CS_tbWorkCount.OrderBy(m => m.ID).ToList();
//--------Add Dropdown for ProjectName-------------------//
model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList();
model.Project_Name_All = new List <SelectListItem>();
var items = new List <SelectListItem>();
foreach (var CS_Project_Name in model.Thiet_Bi)
{
items.Add(new SelectListItem()
{
Value = CS_Project_Name.ID.ToString(),
Text = CS_Project_Name.Ten_Thiet_Bi,
});
}
model.Project_Name_All = items;
//--------Add Dropdown for ProjectName-------------------//
return(View("Finish", 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));
}
}
public ActionResult Edit(int id, CS_tbWorkCountViewModels collection)
{
try
{
using (OnlineShopDbContext db = new OnlineShopDbContext())
{
CS_tbWorkCountViewModels model = new CS_tbWorkCountViewModels();
CS_tbWorkCount Exsiting_CS_tbWorkCount = db.CS_tbWorkCount.Find(id);
Exsiting_CS_tbWorkCount.tb_WorkCountProject_ID = collection.CS_tbWorkCount_Select.tb_WorkCountProject_ID;
Exsiting_CS_tbWorkCount.tb_WorkCountForDate = collection.CS_tbWorkCount_Select.tb_WorkCountForDate;
Exsiting_CS_tbWorkCount.tb_WorkCountName_Report = collection.CS_tbWorkCount_Select.tb_WorkCountName_Edit;
Exsiting_CS_tbWorkCount.tb_WorkCountDateTime_Report = collection.CS_tbWorkCount_Select.tb_WorkCountDateTime_Report;
Exsiting_CS_tbWorkCount.tb_WorkCountName_Edit = collection.CS_tbWorkCount_Select.tb_WorkCountName_Edit;
Exsiting_CS_tbWorkCount.tb_WorkCountDateTime_Edit = DateTime.Today;
db.SaveChanges();
model.CS_tbWorkCount_Select = db.CS_tbWorkCount.Find(id);
model.CS_tbWorkCount = db.CS_tbWorkCount.OrderBy(m => m.ID).ToList();
//--------Add Dropdown for ProjectName-------------------//
model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList();
model.Project_Name_All = new List <SelectListItem>();
var items = new List <SelectListItem>();
foreach (var CS_Project_Name in model.Thiet_Bi)
{
items.Add(new SelectListItem()
{
Value = CS_Project_Name.ID.ToString(),
Text = CS_Project_Name.Ten_Thiet_Bi,
});
}
model.Project_Name_All = items;
//--------Add Dropdown for ProjectName-------------------//
return(View("Edit", model));
}
}
catch
{
using (OnlineShopDbContext db = new OnlineShopDbContext())
{
CS_tbWorkCountViewModels model = new CS_tbWorkCountViewModels();
model.CS_tbWorkCount_Select = db.CS_tbWorkCount.Find(id);
model.CS_tbWorkCount = db.CS_tbWorkCount.OrderBy(m => m.ID).ToList();
//--------Add Dropdown for ProjectName-------------------//
model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList();
model.Project_Name_All = new List <SelectListItem>();
var items = new List <SelectListItem>();
foreach (var CS_Project_Name in model.Thiet_Bi)
{
items.Add(new SelectListItem()
{
Value = CS_Project_Name.ID.ToString(),
Text = CS_Project_Name.Ten_Thiet_Bi,
});
}
model.Project_Name_All = items;
//--------Add Dropdown for ProjectName-------------------//
return(View("Edit", model));
}
}
}
public ActionResult Create(CS_tbWorkCountViewModels collection)
{
try
{
using (OnlineShopDbContext db = new OnlineShopDbContext())
{
CS_tbWorkCountViewModels model = new CS_tbWorkCountViewModels();
var existingStatus = db.CS_tbWorkCount.FirstOrDefault(s => s.tb_WorkCountProject_ID == collection.CS_tbWorkCount_Select.tb_WorkCountProject_ID && s.tb_WorkCountForDate == collection.CS_tbWorkCount_Select.tb_WorkCountForDate);
if (existingStatus == null)
{
CS_tbWorkCount obj = new CS_tbWorkCount();
obj.tb_WorkCountProject_ID = collection.CS_tbWorkCount_Select.tb_WorkCountProject_ID;
obj.tb_WorkCountForDate = collection.CS_tbWorkCount_Select.tb_WorkCountForDate;
obj.tb_WorkCountName_Report = collection.CS_tbWorkCount_Select.tb_WorkCountName_Report;
obj.tb_WorkCountDateTime_Report = DateTime.Today;
obj.tb_mTotalCount = 0;
db.CS_tbWorkCount.Add(obj);
db.SaveChanges();
int id = obj.ID;
//--------Tạo Bảng Công Chi Tiết-------------------//
model.CS_tbLLTCTypeSub = db.CS_tbLLTCTypeSub.Where(m => m.CS_tbLLTCNameSiteID == collection.CS_tbWorkCount_Select.tb_WorkCountProject_ID).ToList();
foreach (var CS_LLTCTyleSub in model.CS_tbLLTCTypeSub)
{
CS_tbWorkCount_Sub obj_temp = new CS_tbWorkCount_Sub();
obj_temp.CS_tbWorkCount_ID = id;
obj_temp.CS_tbLLTCTypeSub_ID = CS_LLTCTyleSub.ID;
obj_temp.CS_LLTC_ID = CS_LLTCTyleSub.CS_tbLLTC_ID;
obj_temp.CS_tbNumberDailyCount = 0;
db.CS_tbWorkCount_Sub.Add(obj_temp);
db.SaveChanges();
}
model.ValidStatus = "Valid";
//--------Tạo Bảng Công Chi Tiết-------------------//
}
else
{
// set the status back to existing
model.ValidStatus = "Invalid";
}
//--------Add Dropdown for ProjectName-------------------//
model.CS_tbWorkCount = db.CS_tbWorkCount.OrderBy(m => m.ID).ToList();
model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList();
model.Project_Name_All = new List <SelectListItem>();
var items = new List <SelectListItem>();
foreach (var CS_Project_Name in model.Thiet_Bi)
{
items.Add(new SelectListItem()
{
Value = CS_Project_Name.ID.ToString(),
Text = CS_Project_Name.Ten_Thiet_Bi,
});
}
model.Project_Name_All = items;
//--------Add Dropdown for ProjectName-------------------//
return(View("Create", model));
}
}
catch
{
using (OnlineShopDbContext db = new OnlineShopDbContext())
{
CS_tbWorkCountViewModels model = new CS_tbWorkCountViewModels();
model.CS_tbWorkCount = db.CS_tbWorkCount.OrderBy(m => m.ID).ToList();
//--------Add Dropdown for ProjectName-------------------//
model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList();
model.Project_Name_All = new List <SelectListItem>();
var items = new List <SelectListItem>();
foreach (var CS_Project_Name in model.Thiet_Bi)
{
items.Add(new SelectListItem()
{
Value = CS_Project_Name.ID.ToString(),
Text = CS_Project_Name.Ten_Thiet_Bi,
});
}
model.Project_Name_All = items;
//--------Add Dropdown for ProjectName-------------------//
return(View("Create", model));
}
}
}