public List <HYLAN_TASKDC> Insert(List <HYLAN_TASKDC> hylanTaskDCList)
{
int insertedCount = 0;
DBConnection objConnection = new DBConnection();
HYLAN_TASKDA HYLAN_TASKDA = null;
try
{
objConnection.Open(true);
foreach (HYLAN_TASKDC hylanTaskDC in hylanTaskDCList)
{
HYLAN_TASKDA = HylanTaskDAFactory.Create(hylanTaskDC.TASK_TITLE_ID);
if (String.IsNullOrEmpty(hylanTaskDC.REQUIRED))
{
hylanTaskDC.REQUIRED = "N";
}
List <HYLAN_TASKDC> tempList = new List <HYLAN_TASKDC>();
tempList.Add(hylanTaskDC);
try
{
if (HYLAN_TASKDA.Insert(objConnection, tempList) > 0)
{
insertedCount++;
}
else
{
hylanTaskDC.POST_MESSAGEDC.Type = "ERROR";
hylanTaskDC.POST_MESSAGEDC.Message = "NOT_ADDED";
}
}
catch (Exception exception)
{
hylanTaskDC.POST_MESSAGEDC.Type = "EXCEPTION";
hylanTaskDC.POST_MESSAGEDC.Message = exception.Message;
hylanTaskDC.POST_MESSAGEDC.StackTrace = exception.StackTrace;
}
}
if (insertedCount == hylanTaskDCList.Count)
{
objConnection.Commit();
}
else
{
objConnection.Rollback();
}
}
catch (Exception ex)
{
objConnection.Rollback();
throw ex;
}
finally
{
objConnection.Close();
}
return(hylanTaskDCList);
}
public HYLAN_TASKDC LoadByPrimaryKey(int TASK_TITLE_ID, int JOB_ID)
{
DBConnection objConnection = new DBConnection();
HYLAN_TASKDA HYLAN_TASKDA = HylanTaskDAFactory.Create(TASK_TITLE_ID);
HYLAN_TASKDC HYLAN_TASKDC = null;
try
{
objConnection.Open(false);
HYLAN_TASKDC = HYLAN_TASKDA.LoadByPrimaryKey(objConnection, TASK_TITLE_ID, JOB_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(HYLAN_TASKDC);
}
public List <HYLAN_TASKDC> LoadAll(int TASK_TITLE_ID)
{
DBConnection objConnection = new DBConnection();
HYLAN_TASKDA HYLAN_TASKDA = HylanTaskDAFactory.Create(TASK_TITLE_ID);
List <HYLAN_TASKDC> HYLAN_TASKDC = null;
try
{
objConnection.Open(false);
HYLAN_TASKDC = HYLAN_TASKDA.LoadAll(objConnection, TASK_TITLE_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(HYLAN_TASKDC);
}
public int Delete(int TASK_TITLE_ID, List <HYLAN_TASKDC> hylanTaskDCList)
{
int deletedCount = 0;
DBConnection objConnection = new DBConnection();
HYLAN_TASKDA HYLAN_TASKDA = HylanTaskDAFactory.Create(TASK_TITLE_ID);
try
{
objConnection.Open(true);
deletedCount = HYLAN_TASKDA.Delete(objConnection, hylanTaskDCList);
objConnection.Commit();
}
catch (Exception ex)
{
objConnection.Rollback();
throw ex;
}
finally
{
objConnection.Close();
}
return(deletedCount);
}
public List <List <HYLAN_TASKDC> > InsertUpdateTasks(List <List <HYLAN_TASKDC> > postData)
{
int insertedCount = 0;
int updatedCount = 0;
List <HYLAN_TASKDC> insertList = new List <HYLAN_TASKDC>();
List <HYLAN_TASKDC> updateList = new List <HYLAN_TASKDC>();
if (postData != null && postData.Count == 2)
{
insertList = postData[0];
updateList = postData[1];
}
DBConnection objConnection = new DBConnection();
HYLAN_TASKDA HYLAN_TASKDA = null;
try
{
objConnection.Open(true);
#region Insert
foreach (HYLAN_TASKDC hylanTaskDC in insertList)
{
HYLAN_TASKDA = HylanTaskDAFactory.Create(hylanTaskDC.TASK_TITLE_ID);
if (String.IsNullOrEmpty(hylanTaskDC.REQUIRED))
{
hylanTaskDC.REQUIRED = "N";
}
List <HYLAN_TASKDC> tempList = new List <HYLAN_TASKDC>();
tempList.Add(hylanTaskDC);
try
{
if (HYLAN_TASKDA.Insert(objConnection, tempList) > 0)
{
insertedCount++;
}
else
{
hylanTaskDC.POST_MESSAGEDC.Type = "ERROR";
hylanTaskDC.POST_MESSAGEDC.Message = "NOT_ADDED";
}
}
catch (Exception exception)
{
if (exception.Message.Contains("UNIQUE KEY"))
{
hylanTaskDC.POST_MESSAGEDC.Type = "CONCURRENCY_ERROR";
hylanTaskDC.POST_MESSAGEDC.Message = "CONCURRENCY_ERROR";
}
else
{
hylanTaskDC.POST_MESSAGEDC.Type = "EXCEPTION";
hylanTaskDC.POST_MESSAGEDC.Message = exception.Message;
hylanTaskDC.POST_MESSAGEDC.StackTrace = exception.StackTrace;
}
}
}
#endregion
#region Update
foreach (HYLAN_TASKDC hylanTaskDC in updateList)
{
HYLAN_TASKDA = HylanTaskDAFactory.Create(hylanTaskDC.TASK_TITLE_ID);
if (String.IsNullOrEmpty(hylanTaskDC.REQUIRED))
{
hylanTaskDC.REQUIRED = "N";
}
List <HYLAN_TASKDC> tempList = new List <HYLAN_TASKDC>();
tempList.Add(hylanTaskDC);
try
{
if (HYLAN_TASKDA.Update(objConnection, tempList) > 0)
{
updatedCount++;
}
else
{
hylanTaskDC.POST_MESSAGEDC.Type = "ERROR";
hylanTaskDC.POST_MESSAGEDC.Message = "NOT_UPDATED";
}
}
catch (Exception exception)
{
hylanTaskDC.POST_MESSAGEDC.Type = "CONCURRENCY_ERROR";
if (exception.Message.Contains("CONCURRENCY_ERROR"))
{
hylanTaskDC.POST_MESSAGEDC.Message = "CONCURRENCY_ERROR";
}
else
{
hylanTaskDC.POST_MESSAGEDC.Type = "EXCEPTION";
hylanTaskDC.POST_MESSAGEDC.Message = exception.Message;
hylanTaskDC.POST_MESSAGEDC.StackTrace = exception.StackTrace;
}
}
}
#endregion
if (insertedCount == insertList.Count && updatedCount == updateList.Count)
{
objConnection.Commit();
}
else
{
objConnection.Rollback();
}
}
catch (Exception ex)
{
objConnection.Rollback();
throw ex;
}
finally
{
objConnection.Close();
}
return(postData);
}