public int Insert(List <ROLEDC> objROLEs) { int insertedCount = 0; DBConnection objConnection = new DBConnection(); ROLEDA objROLEDA = new ROLEDA(); try { objConnection.Open(true); foreach (ROLEDC objROLE in objROLEs) { insertedCount = objROLEDA.Insert(objConnection, objROLE); if (objROLE.ROLE_ID == -111) { throw new Exception("Role Name '" + objROLE.ROLE_NAME + "' already exists.All other changes saved successfully."); } } objConnection.Commit(); } catch (Exception ex) { objConnection.Rollback(); throw ex; } finally { objConnection.Close(); } return(insertedCount); }
public int Update(List <ROLEDC> objROLEs, bool updatePermissions, ref List <EXCEPTIONDC> lstExceptions) { int updatedCount = 0; DBConnection objConnection = new DBConnection(); ROLEDA objROLEDA = new ROLEDA(); try { foreach (ROLEDC objROLE in objROLEs) { objConnection.Open(true); try { updatedCount = objROLEDA.Update(objConnection, objROLE, updatePermissions); IsDirty = objROLEDA.IsDirty; objConnection.Commit(); } catch (Exception exp) { EXCEPTIONDC objExcption = new EXCEPTIONDC(); objExcption.FIELD_ID = objROLE.ROLE_ID; objExcption.EXCEPTION_MESSAGE = exp.Message; objExcption.STACK_TRACK = exp.StackTrace; lstExceptions.Add(objExcption); objConnection.Rollback(); } } if (lstExceptions.Count > 0) { throw new Exception("Excption Occure"); } } catch (Exception exp) { throw exp; } finally { objConnection.Close(); } return(updatedCount); }
public ROLEDC LoadRoleDetails(int ROLE_ID) { DBConnection objConnection = new DBConnection(); ROLEDA objROLEDA = new ROLEDA(); ROLEDC objROLEDC = null; try { objConnection.Open(false); objROLEDC = objROLEDA.LoadRoleDetails(objConnection, ROLE_ID); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objROLEDC); }
public List <ROLEDC> LoadAll() { DBConnection objConnection = new DBConnection(); ROLEDA objROLEDA = new ROLEDA(); List <ROLEDC> objROLEDC = null; try { objConnection.Open(false); objROLEDC = objROLEDA.LoadAll(objConnection); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objROLEDC); }
public int Delete(List <ROLEDC> objROLEs) { int deletedCount = 0; DBConnection objConnection = new DBConnection(); ROLEDA objROLEDA = new ROLEDA(); try { objConnection.Open(true); deletedCount = objROLEDA.Delete(objConnection, objROLEs); objConnection.Commit(); } catch (Exception ex) { objConnection.Rollback(); throw ex; } finally { objConnection.Close(); } return(deletedCount); }