public DAILY_UNKNOWNDC LoadByDailyID(DBConnection Connection, int DAILY_ID)
{
DAILY_UNKNOWNDC objDAILY_UNKNOW = new DAILY_UNKNOWNDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_DAILY_UNKNOWNLoadByDailyID");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_DAILY_ID", DbType.Int32, DAILY_ID);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
objDAILY_UNKNOW = (Utility.ConvertToObject <DAILY_UNKNOWNDC>(ds.Tables[0]));
return(objDAILY_UNKNOW);
}
private DAILY_UNKNOWNDC FillObject(DataRow row)
{
DAILY_UNKNOWNDC objDAILY_UNKNOW = null;
objDAILY_UNKNOW = new DAILY_UNKNOWNDC();
objDAILY_UNKNOW.DU_DAILY_ID = (int)row["DU_DAILY_ID"];
objDAILY_UNKNOW.DAILY_ID = (int)row["DAILY_ID"];
objDAILY_UNKNOW.NODE_ID1 = (String)row["NODE_ID1"];
objDAILY_UNKNOW.NODE_ID2 = (String)row["NODE_ID2"];
objDAILY_UNKNOW.NODE_ID3 = (String)row["NODE_ID3"];
objDAILY_UNKNOW.HUB = (String)row["HUB"];
objDAILY_UNKNOW.HYLAN_PM = row["HYLAN_PM"] == DBNull.Value ? null : (int?)row["HYLAN_PM"];
objDAILY_UNKNOW.STREET_ADDRESS = (String)row["STREET_ADDRESS"];
objDAILY_UNKNOW.CITY = (String)row["CITY"];
objDAILY_UNKNOW.STATE = (String)row["STATE"];
objDAILY_UNKNOW.ZIP = row["ZIP"] == DBNull.Value ? null : (String)row["ZIP"];
objDAILY_UNKNOW.LAT = (String)row["LAT"];
objDAILY_UNKNOW.LONG = (String)row["LONG"];
objDAILY_UNKNOW.POLE_LOCATION = (String)row["POLE_LOCATION"];
objDAILY_UNKNOW.CLIENT_PM = (String)row["CLIENT_PM"];
objDAILY_UNKNOW.UNKNOWN_STATUS = (int)row["UNKNOWN_STATUS"];
objDAILY_UNKNOW.CREATED_ON = (DateTime)row["CREATED_ON"];
objDAILY_UNKNOW.CREATED_BY = (int)row["CREATED_BY"];
objDAILY_UNKNOW.MODIFIED_ON = (DateTime)row["MODIFIED_ON"];
objDAILY_UNKNOW.MODIFIED_BY = (int)row["MODIFIED_BY"];
objDAILY_UNKNOW.LOCK_COUNTER = (int)row["LOCK_COUNTER"];
return(objDAILY_UNKNOW);
}
public int Delete(DBConnection Connection, DAILY_UNKNOWNDC objDAILY_UNKNOW)
{
int deleteCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_DAILY_UNKNOWNDelete");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_DU_DAILY_ID", DbType.Int32, objDAILY_UNKNOW.DU_DAILY_ID);
if (Connection.Transaction != null)
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(deleteCount);
}
public DailyDTO Update(DailyDTO dailyDTO)
{
DAILYDC objDAILYDC = dailyDTO.DAILYDC;
int updatedCount = 0;
DBConnection objConnection = new DBConnection();
DAILYDA objDAILDA = new DAILYDA();
bool exceptionFound = true;
try
{
objConnection.Open(true);
DateTime currentDateTime = DateTime.Now;
objDAILYDC.MODIFIED_ON = currentDateTime;
updatedCount = objDAILDA.Update(objConnection, objDAILYDC);
if (updatedCount > 0)
{
exceptionFound = false;
#region Unknown Daily - Insert/Update
try
{
if (objDAILYDC.PROJECT_ID == -1 || objDAILYDC.JOB_ID == -1)
{
DAILY_UNKNOWNDA unknownDailyDA = new DAILY_UNKNOWNDA();
DAILY_UNKNOWNDC DAILY_UNKNOWNDC = unknownDailyDA.LoadByDailyID(objConnection, objDAILYDC.DAILY_ID);
if (DAILY_UNKNOWNDC != null && DAILY_UNKNOWNDC.DU_DAILY_ID != 0)
{
objDAILYDC.DU_DAILY_ID = DAILY_UNKNOWNDC.DU_DAILY_ID;
objDAILYDC.LOCK_COUNTER = DAILY_UNKNOWNDC.LOCK_COUNTER; // Retain previous lock counter
unknownDailyDA.Update(objConnection, objDAILYDC);
}
else
{
objDAILYDC.CREATED_BY = objDAILYDC.MODIFIED_BY;
objDAILYDC.CREATED_ON = currentDateTime;
objDAILYDC.MODIFIED_ON = objDAILYDC.CREATED_ON;
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/Update
MAN_POWERBL manPowerBL = new MAN_POWERBL();
foreach (MAN_POWERDC mpDC in dailyDTO.listMAN_POWERDC)
{
try
{
mpDC.DAILY_ID = objDAILYDC.DAILY_ID;
if (mpDC.MAN_POWER_ID == 0)
{
mpDC.CREATED_ON = objDAILYDC.MODIFIED_ON;
mpDC.MODIFIED_ON = mpDC.CREATED_ON;
mpDC.CREATED_BY = objDAILYDC.MODIFIED_BY;
mpDC.MODIFIED_BY = mpDC.CREATED_BY;
manPowerBL.Insert(objConnection, mpDC);
}
else
{
mpDC.MODIFIED_ON = objDAILYDC.MODIFIED_ON;
mpDC.MODIFIED_BY = objDAILYDC.MODIFIED_BY;
manPowerBL.Update(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 Vehicle - Insert/Update
VEHICLEBL vehicleBL = new VEHICLEBL();
foreach (VEHICLEDC vehicleDC in dailyDTO.listVEHICLEDC)
{
try
{
vehicleDC.DAILY_ID = objDAILYDC.DAILY_ID;
if (vehicleDC.VEHICLE_VALUE_ID == 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);
}
else
{
vehicleDC.MODIFIED_ON = objDAILYDC.MODIFIED_ON;
vehicleDC.MODIFIED_BY = objDAILYDC.MODIFIED_BY;
vehicleBL.Update(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/Update
LABORBL laborBL = new LABORBL();
foreach (LABORDC laborDC in dailyDTO.listLABORDC)
{
try
{
laborDC.DAILY_ID = objDAILYDC.DAILY_ID;
if (laborDC.LABOR_VALUE_ID == 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);
}
else
{
laborDC.MODIFIED_ON = objDAILYDC.MODIFIED_ON;
laborDC.MODIFIED_BY = objDAILYDC.MODIFIED_BY;
laborBL.Update(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/Update
InsertUpdateMaterials(objConnection, objDAILYDC, dailyDTO.listMATERIALDC, ref exceptionFound);
#endregion
#region Labor Item - Insert/Update
InsertUpdateMaterials(objConnection, objDAILYDC, dailyDTO.listLaborItemDC, ref exceptionFound);
#endregion
#region Aerial - Insert/Update
InsertUpdateMaterials(objConnection, objDAILYDC, dailyDTO.listAerialDC, ref exceptionFound);
#endregion
#region MDU - Insert/Update
InsertUpdateMaterials(objConnection, objDAILYDC, dailyDTO.listMDUDC, ref exceptionFound);
#endregion
#region Work Detail - Insert/Update
WORK_DETAILBL workDetailBL = new WORK_DETAILBL();
foreach (WORK_DETAILDC workDetailDC in dailyDTO.listWORK_DETAILDC)
{
try
{
workDetailDC.DAILY_ID = objDAILYDC.DAILY_ID;
if (workDetailDC.WORK_DETAIL_VALUE_ID == 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);
}
else
{
workDetailDC.MODIFIED_ON = objDAILYDC.MODIFIED_ON;
workDetailDC.MODIFIED_BY = objDAILYDC.MODIFIED_BY;
workDetailBL.Update(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;
objConnection.Commit();
}
objConnection.Close();
}
return(dailyDTO);
}
