public void Put(DailyDTO dailyDTO)
{
Daily miDaily = new Daily();
miDaily.Dailyid = dailyDTO.dailyId.ToString();
miDaily.Dailytype = dailyDTO.dailyType;
if (dailyDTO.dailyType == "Entrada")
{
miDaily.Dailytype = "E";
}
else
{
miDaily.Dailytype = "S";
}
miDaily.Dailyuser = dailyDTO.userId;
if (dailyDTO.dailyInout != "")
{
miDaily.Dailyinout = DateTime.Parse(dailyDTO.dailyInout);
}
else
{
dailyDTO.dailyInout = null;
};
_context.Daily.Update(miDaily);
_context.SaveChanges();
}
public IEnumerable <DailyDTO> GetAllUser(UsuarioDTO usuarioDTO)
{
var dailys = _context.Daily.Where(d => d.Dailyuser == usuarioDTO.id.ToString()).ToList();
List <DailyDTO> dailysDTO = new List <DailyDTO>();
foreach (var d in dailys)
{
string tipo = "";
var miUser = _context.User.Find(d.Dailyuser);
if (d.Dailytype == "E")
{
tipo = "Entrada";
}
else
{
tipo = "Salida";
}
var daily = new DailyDTO
{
dailyId = new Guid(d.Dailyid),
dailyInout = d.Dailyinout.ToString(),
dailyType = tipo,
dailyUser = miUser.Name + " " + miUser.Surname
};
dailysDTO.Add(daily);
}
return(dailysDTO);
}
public void Add(DailyDTO dailyDTO)
{
var query = _context.Session.Where(s => s.Sesstoken == dailyDTO.token);
Session miSes = query.First <Session>();
var miDaily = new Daily();
miDaily.Dailyid = Guid.NewGuid().ToString();
miDaily.Dailyinout = DateTime.Now;
miDaily.Dailytype = dailyDTO.dailyType.ElementAt(0).ToString();
miDaily.Dailyuser = miSes.Sessuser.ToString();
_context.Daily.Add(miDaily);
_context.SaveChanges();
}
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 void Delete(DailyDTO dailyDTO)
{
Daily miDaily = new Daily();
miDaily.Dailyid = dailyDTO.dailyId.ToString();
miDaily.Dailytype = dailyDTO.dailyType;
miDaily.Dailyuser = dailyDTO.dailyUser;
if (dailyDTO.dailyInout != "")
{
miDaily.Dailyinout = DateTime.Parse(dailyDTO.dailyInout);
}
else
{
dailyDTO.dailyInout = null;
};
_context.Daily.Remove(miDaily);
_context.SaveChanges();
}
public void Delete([FromBody] DailyDTO dailyDTO)
{
_dailyBL.Delete(dailyDTO);
}
public void Put([FromBody] DailyDTO dailyDTO)
{
_dailyBL.Put(dailyDTO);
}
public void Post([FromBody] DailyDTO dailyDTO)
{
_dailyBL.Add(dailyDTO);
}
public void Delete(DailyDTO dailyDTO)
{
_dailyRepository.Delete(dailyDTO);
}
public void Put(DailyDTO dailyDTO)
{
_dailyRepository.Put(dailyDTO);
}
public void Add(DailyDTO dailyDTO)
{
_dailyRepository.Add(dailyDTO);
}
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;
}
}
}
public DailyDTO Insert(DailyDTO dailyDTO)
{
DAILYDC objDAILYDC = dailyDTO.DAILYDC;
int p_DAILY_ID = 0;
DBConnection objConnection = new DBConnection();
DAILYDA objDAILDA = new DAILYDA();
bool exceptionFound = true;
try
{
objConnection.Open(true);
DateTime currentDateTime = DateTime.Now;
objDAILYDC.CREATED_ON = currentDateTime;
objDAILYDC.MODIFIED_ON = objDAILYDC.CREATED_ON;
objDAILYDC.LOCK_COUNTER = 0;
p_DAILY_ID = objDAILDA.Insert(objConnection, objDAILYDC);
if (p_DAILY_ID != 0)
{
objDAILYDC.DAILY_ID = p_DAILY_ID;
exceptionFound = false;
#region Unknown Daily - Insert
try
{
if (objDAILYDC.PROJECT_ID == null || objDAILYDC.JOB_ID == null || objDAILYDC.PROJECT_ID == -1 || objDAILYDC.PROJECT_ID == -1)
{
DAILY_UNKNOWNDA unknownDailyDA = new DAILY_UNKNOWNDA();
objDAILYDC.DAILY_ID = p_DAILY_ID;
objDAILYDC.LOCK_COUNTER = 0;
unknownDailyDA.Insert(objConnection, objDAILYDC);
}
}
catch (Exception unkDailyException)
{
exceptionFound = true;
dailyDTO.DAILYDC.POST_MESSAGEDC.Type = "EXCEPTION";
if (unkDailyException.Message.Contains("CONCURRENCY_ERROR"))
{
dailyDTO.DAILYDC.POST_MESSAGEDC.Type = "CONCURRENCY_ERROR";
dailyDTO.DAILYDC.POST_MESSAGEDC.Message = "CONCURRENCY_ERROR";
}
else
{
dailyDTO.DAILYDC.POST_MESSAGEDC.Message = unkDailyException.Message;
dailyDTO.DAILYDC.POST_MESSAGEDC.StackTrace = unkDailyException.StackTrace;
}
}
#endregion
#region ManPower - Insert
MAN_POWERBL manPowerBL = new MAN_POWERBL();
foreach (MAN_POWERDC mpDC in dailyDTO.listMAN_POWERDC)
{
try {
mpDC.DAILY_ID = objDAILYDC.DAILY_ID;
mpDC.LOCK_COUNTER = 0;
mpDC.CREATED_ON = objDAILYDC.MODIFIED_ON;
mpDC.MODIFIED_ON = mpDC.CREATED_ON;
mpDC.CREATED_BY = objDAILYDC.MODIFIED_BY;
mpDC.MODIFIED_BY = objDAILYDC.MODIFIED_BY;
manPowerBL.Insert(objConnection, mpDC);
}
catch (Exception mpException)
{
exceptionFound = true;
mpDC.POST_MESSAGEDC.Type = "EXCEPTION";
if (mpException.Message.Contains("CONCURRENCY_ERROR"))
{
mpDC.POST_MESSAGEDC.Type = "CONCURRENCY_ERROR";
mpDC.POST_MESSAGEDC.Message = "CONCURRENCY_ERROR";
}
else
{
mpDC.POST_MESSAGEDC.Message = mpException.Message;
mpDC.POST_MESSAGEDC.StackTrace = mpException.StackTrace;
}
}
}
#endregion
#region Vehicles - Insert
VEHICLEBL vehicleBL = new VEHICLEBL();
foreach (VEHICLEDC vehicleDC in dailyDTO.listVEHICLEDC)
{
try {
vehicleDC.DAILY_ID = objDAILYDC.DAILY_ID;
vehicleDC.LOCK_COUNTER = 0;
vehicleDC.CREATED_ON = objDAILYDC.MODIFIED_ON;
vehicleDC.MODIFIED_ON = vehicleDC.CREATED_ON;
vehicleDC.CREATED_BY = objDAILYDC.MODIFIED_BY;
vehicleDC.MODIFIED_BY = objDAILYDC.MODIFIED_BY;
vehicleBL.Insert(objConnection, vehicleDC);
}
catch (Exception vvException)
{
exceptionFound = true;
vehicleDC.POST_MESSAGEDC.Type = "EXCEPTION";
if (vvException.Message.Contains("CONCURRENCY_ERROR"))
{
vehicleDC.POST_MESSAGEDC.Type = "CONCURRENCY_ERROR";
vehicleDC.POST_MESSAGEDC.Message = "CONCURRENCY_ERROR";
}
else
{
vehicleDC.POST_MESSAGEDC.Message = vvException.Message;
vehicleDC.POST_MESSAGEDC.StackTrace = vvException.StackTrace;
}
}
}
#endregion
#region Labor - Insert
LABORBL laborBL = new LABORBL();
foreach (LABORDC laborDC in dailyDTO.listLABORDC)
{
try
{
laborDC.DAILY_ID = objDAILYDC.DAILY_ID;
laborDC.LOCK_COUNTER = 0;
laborDC.CREATED_ON = objDAILYDC.MODIFIED_ON;
laborDC.MODIFIED_ON = laborDC.CREATED_ON;
laborDC.CREATED_BY = objDAILYDC.MODIFIED_BY;
laborDC.MODIFIED_BY = objDAILYDC.MODIFIED_BY;
laborBL.Insert(objConnection, laborDC);
}
catch (Exception lbrException)
{
exceptionFound = true;
laborDC.POST_MESSAGEDC.Type = "EXCEPTION";
if (lbrException.Message.Contains("CONCURRENCY_ERROR"))
{
laborDC.POST_MESSAGEDC.Type = "CONCURRENCY_ERROR";
laborDC.POST_MESSAGEDC.Message = "CONCURRENCY_ERROR";
}
else
{
laborDC.POST_MESSAGEDC.Message = lbrException.Message;
laborDC.POST_MESSAGEDC.StackTrace = lbrException.StackTrace;
}
}
}
#endregion
#region Material - Insert
InsertMaterials(objConnection, objDAILYDC, dailyDTO.listMATERIALDC, ref exceptionFound);
#endregion
#region Labor Item - Insert
InsertMaterials(objConnection, objDAILYDC, dailyDTO.listLaborItemDC, ref exceptionFound);
#endregion
#region Aerial - Insert
InsertMaterials(objConnection, objDAILYDC, dailyDTO.listAerialDC, ref exceptionFound);
#endregion
#region MDU - Insert
InsertMaterials(objConnection, objDAILYDC, dailyDTO.listMDUDC, ref exceptionFound);
#endregion
#region Work Detail - Insert
WORK_DETAILBL workDetailBL = new WORK_DETAILBL();
foreach (WORK_DETAILDC workDetailDC in dailyDTO.listWORK_DETAILDC)
{
try
{
workDetailDC.DAILY_ID = objDAILYDC.DAILY_ID;
workDetailDC.LOCK_COUNTER = 0;
workDetailDC.CREATED_ON = objDAILYDC.MODIFIED_ON;
workDetailDC.MODIFIED_ON = workDetailDC.CREATED_ON;
workDetailDC.CREATED_BY = objDAILYDC.MODIFIED_BY;
workDetailDC.MODIFIED_BY = objDAILYDC.MODIFIED_BY;
workDetailBL.Insert(objConnection, workDetailDC);
}
catch (Exception wvException)
{
exceptionFound = true;
workDetailDC.POST_MESSAGEDC.Type = "EXCEPTION";
if (wvException.Message.Contains("CONCURRENCY_ERROR"))
{
workDetailDC.POST_MESSAGEDC.Type = "CONCURRENCY_ERROR";
workDetailDC.POST_MESSAGEDC.Message = "CONCURRENCY_ERROR";
}
else
{
workDetailDC.POST_MESSAGEDC.Message = wvException.Message;
workDetailDC.POST_MESSAGEDC.StackTrace = wvException.StackTrace;
}
}
}
#endregion
}
}
catch (Exception exception)
{
exceptionFound = true;
dailyDTO.DAILYDC.POST_MESSAGEDC.Type = "EXCEPTION";
if (exception.Message.Contains("CONCURRENCY_ERROR"))
{
dailyDTO.DAILYDC.POST_MESSAGEDC.Type = "CONCURRENCY_ERROR";
dailyDTO.DAILYDC.POST_MESSAGEDC.Message = "CONCURRENCY_ERROR";
}
else
{
dailyDTO.DAILYDC.POST_MESSAGEDC.Message = exception.Message;
dailyDTO.DAILYDC.POST_MESSAGEDC.StackTrace = exception.StackTrace;
}
}
finally
{
if (exceptionFound)
{
dailyDTO.DAILYDC.TRANSACTION_SUCCESS = false;
objConnection.Rollback();
}
else
{
dailyDTO.DAILYDC.TRANSACTION_SUCCESS = true;
dailyDTO.DAILYDC.DAILY_ID = p_DAILY_ID;
objConnection.Commit();
}
objConnection.Close();
}
return(dailyDTO);
}
