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