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); }