public IHttpActionResult GetByID(int dailyid) { DAILYBL dailyBL = new DAILYBL(); DAILYDC objResult = new DAILYDC(); if (dailyid > 0) { objResult = dailyBL.LoadByPrimaryKey(dailyid); } return(Ok(new { objResult })); }
public IHttpActionResult Update([FromBody] DailyDTO dailyDTO) { DAILYBL dailyBL = new DAILYBL(); int IsUpdated = 0; dailyDTO = dailyBL.Update(dailyDTO); bool TRANSACTION_SUCCESS = dailyDTO.DAILYDC.TRANSACTION_SUCCESS; if (TRANSACTION_SUCCESS) { dailyDTO.DAILYDC = dailyBL.LoadByPrimaryKey(dailyDTO.DAILYDC.DAILY_ID); dailyDTO.DAILYDC.TRANSACTION_SUCCESS = TRANSACTION_SUCCESS; //Task.Run(() => dailyBL.SendDailyEmail(Request, dailyDTO.DAILYDC)); } return(Ok(new { IsUpdated, dailyDTO })); }
public IHttpActionResult SendDailyEmail(int dailyID, bool isNewDaily) { try { if (dailyID < 0) { throw new Exception("Wrong Daily ID i.e." + dailyID); } DAILYDC daily = null; DAILYBL dailyBL = new DAILYBL(); daily = dailyBL.LoadByPrimaryKey(dailyID); dailyBL.SendDailyEmail(Request, daily, isNewDaily); return(Ok(1)); } catch (Exception ex) { throw ex; } }
public IHttpActionResult GetWholeDailyByID(int dailyid) { DailyDTO dailyDTO = new DailyDTO(); //try //{ DAILYBL dailyBL = new DAILYBL(); dailyDTO.DAILYDC = dailyBL.LoadByPrimaryKey(dailyid); int dailyId = dailyDTO.DAILYDC.DAILY_ID; int dailyType = dailyDTO.DAILYDC.DAILY_TYPE; List <LOOK_UPDC> lookupList = new LOOK_UPBL().LoadAll(); var materialSubCateObjs = lookupList.Where(obj => obj.LU_TYPE == "MATERIAL_SUB_CATEGORY"); dailyDTO.LU_ID_LABOR = materialSubCateObjs.Where(obj => obj.LU_NAME == "Labor").First().LOOK_UP_ID; dailyDTO.LU_ID_AERIAL = materialSubCateObjs.Where(obj => obj.LU_NAME == "Aerial").First().LOOK_UP_ID; dailyDTO.LU_ID_MDU = materialSubCateObjs.Where(obj => obj.LU_NAME == "MDU").First().LOOK_UP_ID; dailyDTO.listMAN_POWERDC = (new MAN_POWERBL()).LoadByDailyID(dailyId); if (dailyDTO.listMAN_POWERDC.Count > 0) { dailyDTO.listMAN_POWERDC = (from obj in dailyDTO.listMAN_POWERDC where obj.MODIFIED_BY > 0 select obj).ToList <MAN_POWERDC>(); } dailyDTO.listLABORDC = (new LABORBL()).GetLaborFromManPower(dailyid, dailyType); //if (dailyDTO.listLABORDC.Count > 0) //{ // dailyDTO.listLABORDC = (from obj in dailyDTO.listLABORDC where obj.MODIFIED_BY > 0 select obj).ToList<LABORDC>(); //} dailyDTO.listVEHICLEDC = (new VEHICLEBL()).LoadByDailyIDAndType(dailyId, dailyType); if (dailyDTO.listVEHICLEDC.Count > 0) { dailyDTO.listVEHICLEDC = (from obj in dailyDTO.listVEHICLEDC where obj.MODIFIED_BY > 0 select obj).ToList <VEHICLEDC>(); } dailyDTO.listMATERIALDC = (new MATERIALBL()).LoadByDailyIDAndType(dailyId, dailyType, -1); if (dailyDTO.listMATERIALDC.Count > 0) { dailyDTO.listMATERIALDC = (from obj in dailyDTO.listMATERIALDC where obj.MODIFIED_BY > 0 select obj).ToList <MATERIALDC>(); } if (dailyDTO.LU_ID_LABOR != 0) { dailyDTO.listLaborItemDC = (new MATERIALBL()).LoadByDailyIDAndType(dailyId, dailyType, dailyDTO.LU_ID_LABOR); if (dailyDTO.listLaborItemDC.Count > 0) { dailyDTO.listLaborItemDC = (from obj in dailyDTO.listLaborItemDC where obj.MODIFIED_BY > 0 select obj).ToList <MATERIALDC>(); } } if (dailyDTO.LU_ID_AERIAL != 0) { dailyDTO.listAerialDC = (new MATERIALBL()).LoadByDailyIDAndType(dailyId, dailyType, dailyDTO.LU_ID_AERIAL); if (dailyDTO.listAerialDC.Count > 0) { dailyDTO.listAerialDC = (from obj in dailyDTO.listAerialDC where obj.MODIFIED_BY > 0 select obj).ToList <MATERIALDC>(); } } if (dailyDTO.LU_ID_MDU != 0) { dailyDTO.listMDUDC = (new MATERIALBL()).LoadByDailyIDAndType(dailyId, dailyType, dailyDTO.LU_ID_MDU); if (dailyDTO.listMDUDC.Count > 0) { dailyDTO.listMDUDC = (from obj in dailyDTO.listMDUDC where obj.MODIFIED_BY > 0 select obj).ToList <MATERIALDC>(); } } dailyDTO.listWORK_DETAILDC = (new WORK_DETAILBL()).LoadByDailyIDAndType(dailyId, dailyType); if (dailyDTO.listWORK_DETAILDC.Count > 0) { dailyDTO.listWORK_DETAILDC = (from obj in dailyDTO.listWORK_DETAILDC where obj.MODIFIED_BY > 0 select obj).ToList <WORK_DETAILDC>(); } var objResult = dailyDTO; return(Ok(new { objResult })); //} //catch (Exception ex) //{ // if (ex.Message.Contains("UNIQUE KEY constraint")) // { // throw new System.InvalidOperationException("JobNumber"); // } // else // throw ex; //} }
public IHttpActionResult Insert([FromBody] DailyDTO dailyDTO) { try { DAILYBL dailyBL = new DAILYBL(); #region REPEAT DAILY if (dailyDTO.Repeat == true) { int createdBy = dailyDTO.DAILYDC.CREATED_BY; dailyDTO.DAILYDC = dailyBL.LoadByPrimaryKey(dailyDTO.DAILYDC.DAILY_ID); dailyDTO.DAILYDC.CREATED_BY = dailyDTO.DAILYDC.MODIFIED_BY = createdBy; int dailyId = dailyDTO.DAILYDC.DAILY_ID; int dailyType = dailyDTO.DAILYDC.DAILY_TYPE; dailyDTO.listMAN_POWERDC = (new MAN_POWERBL()).LoadByDailyID(dailyId); if (dailyDTO.listMAN_POWERDC.Count > 0) { dailyDTO.listMAN_POWERDC = (from obj in dailyDTO.listMAN_POWERDC where obj.MODIFIED_BY > 0 select obj).ToList <MAN_POWERDC>(); } dailyDTO.listVEHICLEDC = (new VEHICLEBL()).LoadByDailyIDAndType(dailyId, dailyType); if (dailyDTO.listVEHICLEDC.Count > 0) { dailyDTO.listVEHICLEDC = (from obj in dailyDTO.listVEHICLEDC where obj.MODIFIED_BY > 0 select obj).ToList <VEHICLEDC>(); } dailyDTO.listMATERIALDC = (new MATERIALBL()).LoadByDailyIDAndType(dailyId, dailyType, -1); if (dailyDTO.listMATERIALDC.Count > 0) { dailyDTO.listMATERIALDC = (from obj in dailyDTO.listMATERIALDC where obj.MODIFIED_BY > 0 select obj).ToList <MATERIALDC>(); } if (dailyDTO.LU_ID_LABOR != 0) { dailyDTO.listLaborItemDC = (new MATERIALBL()).LoadByDailyIDAndType(dailyId, dailyType, dailyDTO.LU_ID_LABOR); if (dailyDTO.listLaborItemDC.Count > 0) { dailyDTO.listLaborItemDC = (from obj in dailyDTO.listLaborItemDC where obj.MODIFIED_BY > 0 select obj).ToList <MATERIALDC>(); } } if (dailyDTO.LU_ID_AERIAL != 0) { dailyDTO.listAerialDC = (new MATERIALBL()).LoadByDailyIDAndType(dailyId, dailyType, dailyDTO.LU_ID_AERIAL); if (dailyDTO.listAerialDC.Count > 0) { dailyDTO.listAerialDC = (from obj in dailyDTO.listAerialDC where obj.MODIFIED_BY > 0 select obj).ToList <MATERIALDC>(); } } if (dailyDTO.LU_ID_MDU != 0) { dailyDTO.listMDUDC = (new MATERIALBL()).LoadByDailyIDAndType(dailyId, dailyType, dailyDTO.LU_ID_MDU); if (dailyDTO.listMDUDC.Count > 0) { dailyDTO.listMDUDC = (from obj in dailyDTO.listMDUDC where obj.MODIFIED_BY > 0 select obj).ToList <MATERIALDC>(); } } dailyDTO.listWORK_DETAILDC = (new WORK_DETAILBL()).LoadByDailyIDAndType(dailyId, dailyType); if (dailyDTO.listWORK_DETAILDC.Count > 0) { dailyDTO.listWORK_DETAILDC = (from obj in dailyDTO.listWORK_DETAILDC where obj.MODIFIED_BY > 0 select obj).ToList <WORK_DETAILDC>(); } } #endregion dailyDTO = dailyBL.Insert(dailyDTO); if (dailyDTO.DAILYDC.DAILY_ID != 0) { dailyDTO.DAILYDC = dailyBL.LoadByPrimaryKey(dailyDTO.DAILYDC.DAILY_ID); dailyDTO.DAILYDC.TRANSACTION_SUCCESS = true; //Task.Run(() => dailyBL.SendDailyEmail(Request, dailyDTO.DAILYDC)); } return(Ok(new { dailyDTO.DAILYDC.DAILY_ID, dailyDTO })); } catch (Exception ex) { if (ex.Message.Contains("UNIQUE KEY constraint")) { throw new System.InvalidOperationException("JobNumber"); } else { throw ex; } } }