public ActionResult Create(ViewModelAddKT_THIETHAIKHAITHAC model)
{
if (ModelState.IsValid)
{
var selectedSucovetau = model.SUCOVETAU.Where(x => x.IsChecked).Select(x => x.ID).ToList();
var selectedSucovenguoi = model.SUCOVENGUOI.Where(x => x.IsChecked).Select(x => x.ID).ToList();
KT_THIETHAIKHAITHACManager.Add(model.SO_DK_TAU,
model.SO_THUYENVIEN,
model.KHUVUC_GAPNAN,
model.TG_GAPNAN,
selectedSucovetau,
selectedSucovenguoi,
model.COQUAN_XULY,
model.THIETHAI_UOCTINH,
model.VIDO,
model.KINHDO,
model.TAU_KHAC,
model.NGUOI_KHAC,
model.SO_NGUOI_CHET,
model.SO_NGUOI_MAT_TICH
);
this.Information(String.Format(Constants.NOTIFY_ADD_SUCCESS, "bản ghi"));
return(RedirectToAction("Index"));
}
return(View(model));
}
public ActionResult Create()
{
ViewModelAddKT_THIETHAIKHAITHAC model = new ViewModelAddKT_THIETHAIKHAITHAC();
var allSUCOVETAU = db.DSUCOVETAU.ToList().OrderByDescending(x => x.ID); //returns List<SUCOVETAU>
var allSUCOVENGUOI = db.DSUCOVENGUOI.ToList().OrderByDescending(x => x.ID); //returns List<SUCOVENGUOI>
var checkBoxListItemSUCOVETAU = new List <CheckBoxListItem>();
var checkBoxListItemSUCOVENGUOI = new List <CheckBoxListItem>();
foreach (var sucovetau in allSUCOVETAU)
{
checkBoxListItemSUCOVETAU.Add(new CheckBoxListItem()
{
ID = sucovetau.ID,
Display = sucovetau.Name,
IsChecked = false
});
model.SUCOVETAU = checkBoxListItemSUCOVETAU;
}
foreach (var sucovenguoi in allSUCOVENGUOI)
{
checkBoxListItemSUCOVENGUOI.Add(new CheckBoxListItem()
{
ID = sucovenguoi.ID,
Display = sucovenguoi.Name,
IsChecked = false
});
model.SUCOVENGUOI = checkBoxListItemSUCOVENGUOI;
}
return(View(model));
}
public ActionResult Search(ViewModelSearchKT_THIETHAIKHAITHAC SearchModel)
{
// khoi tao default checkboxlist
var allSUCOVETAU = db.DSUCOVETAU.ToList().OrderByDescending(x => x.ID); //returns List<SUCOVETAU>
var allSUCOVENGUOI = db.DSUCOVENGUOI.ToList().OrderByDescending(x => x.ID); //returns List<SUCOVENGUOI>
// -------------------------------------------------
var KT_THIETHAIKHAITHACs = db.KT_THIETHAIKHAITHAC.Where(o => ((SearchModel.TU_NGAY == null || o.TG_GAPNAN >= SearchModel.TU_NGAY) &&
(SearchModel.DEN_NGAY == null || o.TG_GAPNAN <= SearchModel.DEN_NGAY))
//).Select(x => new { x.ID, x.SO_DK_TAU, x.SO_THUYENVIEN, x.KHUVUC_GAPNAN, x.TG_GAPNAN, x.THIETHAI_UOCTINH,x.SUCOVETAU,x.SUCOVENGUOI })
).OrderByDescending(x => x.ID);
List <KT_THIETHAIKHAITHAC> DSKT_THIETHAI = KT_THIETHAIKHAITHACs.ToList();
List <ViewModelAddKT_THIETHAIKHAITHAC> DSKT_THIETHAI_NEW = new List <ViewModelAddKT_THIETHAIKHAITHAC>();
ViewModelAddKT_THIETHAIKHAITHAC fu;
foreach (var kt_thiethai in DSKT_THIETHAI)
{
fu = new ViewModelAddKT_THIETHAIKHAITHAC();
var checkBoxListItemSUCOVETAU = new List <CheckBoxListItem>();
var checkBoxListItemSUCOVENGUOI = new List <CheckBoxListItem>();
foreach (var sucovetau in allSUCOVETAU)
{
checkBoxListItemSUCOVETAU.Add(new CheckBoxListItem()
{
ID = sucovetau.ID,
Display = sucovetau.Name,
IsChecked = kt_thiethai.SUCOVETAU.Where(x => x.ID == sucovetau.ID).Any()
});
}
foreach (var sucovenguoi in allSUCOVENGUOI)
{
checkBoxListItemSUCOVENGUOI.Add(new CheckBoxListItem()
{
ID = sucovenguoi.ID,
Display = sucovenguoi.Name,
IsChecked = kt_thiethai.SUCOVENGUOI.Where(x => x.ID == sucovenguoi.ID).Any()
});
}
fu.SO_DK_TAU = kt_thiethai.SO_DK_TAU;
fu.SO_THUYENVIEN = kt_thiethai.SO_THUYENVIEN;
fu.KHUVUC_GAPNAN = kt_thiethai.KHUVUC_GAPNAN;
fu.TG_GAPNAN = kt_thiethai.TG_GAPNAN;
fu.THIETHAI_UOCTINH = kt_thiethai.THIETHAI_UOCTINH;
fu.COQUAN_XULY = kt_thiethai.COQUAN_XULY;
fu.SUCOVENGUOI = checkBoxListItemSUCOVENGUOI;
fu.SUCOVETAU = checkBoxListItemSUCOVETAU;
fu.SO_NGUOI_CHET = kt_thiethai.SO_NGUOI_CHET;
fu.SO_NGUOI_MAT_TICH = kt_thiethai.SO_NGUOI_MAT_TICH;
DSKT_THIETHAI_NEW.Add(fu);
}
//tong so
Sum(SearchModel);
var tong_chet = KT_THIETHAIKHAITHACs.Sum(s => s.SO_NGUOI_CHET);
var tong_mat_tich = KT_THIETHAIKHAITHACs.Sum(s => s.SO_NGUOI_MAT_TICH);
ViewBag.tong_chet = tong_chet;
ViewBag.tong_mat_tich = tong_mat_tich;
// cmd.CommandText = "SELECT COUNT(DSUCOVENGUOI_ID) AS [Ốm/tai nạn lao động] FROM KT_THIETHAIKHAITHACDSUCOVENGUOI where DSUCOVENGUOI_ID = 4 group by DSUCOVENGUOI_ID";
// var count_9 = cmd.ExecuteScalar();
// if (count_9 != null)
// {
// ViewBag.Count9 = count_9.ToString();
// }
//}
ViewBag.TotalRow = KT_THIETHAIKHAITHACs.Count();
//Phân trang ở đây:
var pageIndex = SearchModel.Page ?? 1;
SearchModel.StatisticsResults = DSKT_THIETHAI_NEW.ToPagedList(pageIndex, Constants.PageSize);
return(View(SearchModel));
}
