public cListJobDescription GetListMaterial(int nID) { var result = new cListJobDescription(); try { PTTGSP_DWSContext db = new PTTGSP_DWSContext(); var lstMaterials = db.TB_Materials.Where(w => !w.IsDel).ToList(); var lstMaterial_Unit = db.TB_Material_Unit.Where(w => !w.IsDel).ToList(); var lstWork_Mate = db.TB_Work_Material.Where(w => w.nWorkID == nID).ToList(); var Meterials = (from s in lstMaterials from g in lstMaterial_Unit.Where(w => w.nUnitID == s.nUnitID) from m in lstWork_Mate.Where(w => w.nMaterialID == s.nMaterialID) select new lst_Materials { nMaterialID = s.nMaterialID, sMaterialCode = s.sMaterialCode, sName = s.sName, nAmount = m.nAmount, sUnitName = g.sName, bStatus = s.IsActive, sStatus_Name = s.IsActive ? "ใช้งาน" : "ไม่ใช้งาน", }).ToList(); result.lst_Materials = Meterials.ToList(); } catch (Exception e) { result.sStatus = SysFunc.process_Error; result.sMsg = e.Message; } return(result); }
public IActionResult EditData(int nID) { var result = new cListJobDescription(); cTB_Work EditDataWork = new cTB_Work(); try { PTTGSP_DWSContext db = new PTTGSP_DWSContext(); var lstWork = db.TB_Work.Where(w => !w.IsDel && w.nWorkID == nID).ToList(); var lstReason = db.TB_Reason.Where(w => !w.IsDel).ToList(); EditDataWork = (from s in lstWork from g in lstReason.Where(w => w.nReasonID == s.nReasonID) select new cTB_Work { nWorkID = s.nWorkID, sName = s.sName, nReasonID = g.nReasonID, sReason = g.sName, sDetail = s.sDetail, bStatus = s.IsActive, sStatus_Name = s.IsActive ? "ใช้งาน" : "ไม่ใช้งาน", }).FirstOrDefault(); } catch (Exception e) { result.sStatus = SysFunc.process_Error; result.sMsg = e.Message; } return(Ok(EditDataWork)); }
public cListJobDescription GetListWork(string txtSearch, string sIsActive) { var result = new cListJobDescription(); try { PTTGSP_DWSContext db = new PTTGSP_DWSContext(); var lst_Work = db.TB_Work.Where(w => !w.IsDel).ToList(); var lstReason = db.TB_Reason.Where(w => !w.IsDel).ToList(); var Jobdescription = (from s in lst_Work from g in lstReason.Where(w => w.nReasonID == s.nReasonID) select new lst_Work { nWorkID = s.nWorkID, sName = s.sName, nReasonID = s.nReasonID, sReason = g.sName, sDetail = s.sDetail, bStatus = s.IsActive, sStatus_Name = s.IsActive ? "ใช้งาน" : "ไม่ใช้งาน", dUpdate = s.dUpdate, sUpdate = s.dUpdate.ToString("dd/MM/yyyy", culture), }).ToList(); if (!string.IsNullOrEmpty(txtSearch) && txtSearch != "none") { Jobdescription = Jobdescription.Where(item => item.sName.Trim().ToLower().Contains(txtSearch.Trim().ToLower())).ToList(); } if (!string.IsNullOrEmpty(sIsActive)) { var isActive = sIsActive == "1"; Jobdescription = Jobdescription.Where(a => a.bStatus == isActive).ToList(); } result.lst_Work = Jobdescription.ToList(); } catch (Exception e) { result.sStatus = SysFunc.process_Error; result.sMsg = e.Message; } return(result); }