//public int Update(List<PERMITDC> objPERMITs) //{ // int updatedCount = 0; // DBConnection objConnection = new DBConnection(); // PERMITDA objPERMITDA = new PERMITDA(); // try // { // objConnection.Open(true); // updatedCount = objPERMITDA.Update(objConnection, objPERMITs); // IsDirty = objPERMITDA.IsDirty; // if (IsDirty) // objConnection.Rollback(); // else // objConnection.Commit(); // } // catch (Exception ex) // { // objConnection.Rollback(); // throw ex; // } // finally // { // objConnection.Close(); // } // return updatedCount; //} public int Update(List <PERMITDC> objs, ref List <EXCEPTIONDC> lstExceptions) { int updatedCount = 0; DBConnection objConnection = new DBConnection(); PERMITDA objDA = new PERMITDA(); try { foreach (PERMITDC obj in objs) { objConnection.Open(true); try { updatedCount = objDA.Update(objConnection, obj); if (obj.IsDirty) { break; } objConnection.Commit(); } catch (Exception exp) { EXCEPTIONDC objExcption = new EXCEPTIONDC(); objExcption.FIELD_ID = obj.PERMIT_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 int Delete(List <PERMITDC> objs, ref List <EXCEPTIONDC> lstExceptions) { int deleteCount = 0; DBConnection Connection = new DBConnection(); try { PERMITDA objDA = new PERMITDA(); foreach (PERMITDC obj in objs) { try { Connection.Open(true); deleteCount = objDA.Delete(Connection, obj); Connection.Commit(); } catch (Exception exp) { EXCEPTIONDC objExcption = new EXCEPTIONDC(); objExcption.FIELD_ID = obj.PERMIT_ID; objExcption.EXCEPTION_MESSAGE = exp.Message; objExcption.STACK_TRACK = exp.StackTrace; lstExceptions.Add(objExcption); Connection.Rollback(); } } if (lstExceptions.Count > 0) { throw new Exception("Excption Occure"); } } catch (Exception exp) { throw exp; } finally { Connection.Close(); } return(deleteCount); }
public PERMITDC LoadByPrimaryKey(int PERMIT_ID) { DBConnection objConnection = new DBConnection(); PERMITDA objPERMITDA = new PERMITDA(); PERMITDC objPERMITDC = null; try { objConnection.Open(false); objPERMITDC = objPERMITDA.LoadByPrimaryKey(objConnection, PERMIT_ID); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objPERMITDC); }
public List <PERMITDC> LoadDashboard(string projectIDs = "All", string permitStatus = "All", string clientIDs = "All", string jobFileNo = "All", string submitedStartDt = "All", string submitedEndDt = "All") { DBConnection objConnection = new DBConnection(); PERMITDA objPERMITDA = new PERMITDA(); List <PERMITDC> objPERMITDC = null; try { objConnection.Open(false); objPERMITDC = objPERMITDA.LoadDashboard(objConnection, projectIDs, permitStatus, clientIDs, jobFileNo, submitedStartDt, submitedEndDt); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objPERMITDC); }
public List <DD_DTO> GetJobFileNumbers(string projectIDs) { DBConnection objConnection = new DBConnection(); PERMITDA obJDA = new PERMITDA(); List <DD_DTO> objDD_DTO = new List <DD_DTO>(); try { objConnection.Open(false); objDD_DTO = obJDA.GetJobFileNumbers(objConnection, projectIDs); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objDD_DTO); }
public List <PERMITDC> LoadAll(string projectIDs = "All") { DBConnection objConnection = new DBConnection(); PERMITDA objPERMITDA = new PERMITDA(); List <PERMITDC> objPERMITDC = null; try { objConnection.Open(false); objPERMITDC = objPERMITDA.LoadAll(objConnection, projectIDs); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objPERMITDC); }