public int Update(List <PROJECTDC> objProjects, ref List <EXCEPTIONDC> lstExceptions)
{
int updatedCount = 0;
DBConnection objConnection = new DBConnection();
PROJECTDA projectsDA = new PROJECTDA();
try
{
foreach (PROJECTDC obj in objProjects)
{
objConnection.Open(true);
try
{
updatedCount = projectsDA.Update(objConnection, obj);
if (obj.ISDIRTY)
{
break;
}
objConnection.Commit();
}
catch (Exception exp)
{
EXCEPTIONDC objExcption = new EXCEPTIONDC();
objExcption.FIELD_ID = obj.PROJECT_ID;
objExcption.EXCEPTION_MESSAGE = exp.Message;
objExcption.STACK_TRACK = exp.StackTrace;
lstExceptions.Add(objExcption);
objConnection.Rollback();
}
}
if (lstExceptions.Count > 0)
{
throw new Exception(lstExceptions[0].EXCEPTION_MESSAGE);
}
}
catch (Exception exp)
{
throw exp;
}
finally
{
objConnection.Close();
}
return(updatedCount);
}
public List <PROJECTDC> LoadAllByStatus(String projectStatus)
{
DBConnection objConnection = new DBConnection();
PROJECTDA objPROJECTDA = new PROJECTDA();
List <PROJECTDC> objPROJECTDC = null;
try
{
objConnection.Open(false);
objPROJECTDC = objPROJECTDA.LoadAllByStatus(objConnection, projectStatus);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objPROJECTDC);
}
public PROJECTDC LoadByPrimaryKey(int ID)
{
DBConnection objConnection = new DBConnection();
PROJECTDA objPROJECTDA = new PROJECTDA();
PROJECTDC objPROJECTDC = null;
try
{
objConnection.Open(false);
objPROJECTDC = objPROJECTDA.LoadByPrimaryKey(objConnection, ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objPROJECTDC);
}
public int Delete(List <PROJECTDC> objPROJECTs)
{
int deletedCount = 0;
DBConnection objConnection = new DBConnection();
PROJECTDA objPROJECTDA = new PROJECTDA();
try
{
objConnection.Open(true);
deletedCount = objPROJECTDA.Delete(objConnection, objPROJECTs);
objConnection.Commit();
}
catch (Exception ex)
{
objConnection.Rollback();
throw ex;
}
finally
{
objConnection.Close();
}
return(deletedCount);
}
