public DAILYDC LoadByPrimaryKey(int DAILY_ID)
{
DBConnection objConnection = new DBConnection();
DAILYDA objDAILDA = new DAILYDA();
DAILYDC objDAILDC = null;
try
{
objConnection.Open(false);
objDAILDC = objDAILDA.LoadByPrimaryKey(objConnection, DAILY_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objDAILDC);
}
public DataSet DailyHoursReport(string projectIDs = "All", string dailyTypeIDs = "All", string statusIDs = "All", string shiftIDs = "All", string dailyDate = "All", string dailyEndDate = "All")
{
DBConnection objConnection = new DBConnection();
DAILYDA objDAILDA = new DAILYDA();
DataSet ds = null;
try
{
objConnection.Open(false);
ds = objDAILDA.DailyHoursReport(objConnection, projectIDs, dailyTypeIDs, statusIDs, shiftIDs, dailyDate, dailyEndDate);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(ds);
}
public List <DAILYDC> LoadAll(string projectIDs = "All", string dailyTypeIDs = "All", string statusIDs = "All", string shiftIDs = "All", string dailyDate = "All", string dailyEndDate = "All")
{
DBConnection objConnection = new DBConnection();
DAILYDA objDAILDA = new DAILYDA();
List <DAILYDC> objDAILDC = null;
try
{
objConnection.Open(false);
objDAILDC = objDAILDA.LoadAll(objConnection, projectIDs, dailyTypeIDs, statusIDs, shiftIDs, dailyDate, dailyEndDate);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objDAILDC);
}
public int Delete(List <DAILYDC> objDAILs, ref List <EXCEPTIONDC> lstExceptions)
{
int deletedCount = 0;
DBConnection objConnection = new DBConnection();
DAILYDA objDAILDA = new DAILYDA();
try
{
//objConnection.Open(true);
deletedCount = objDAILDA.Delete(objConnection, ref lstExceptions, objDAILs);
//objConnection.Commit();
}
catch (Exception ex)
{
//objConnection.Rollback();
throw ex;
}
//finally
//{
// objConnection.Close();
//}
return(deletedCount);
}
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);
}
