public IHttpActionResult LoadRoleDetails(int id) { ROLEBL objRole = new ROLEBL(); ROLEDC objResult = new ROLEDC(); try { objResult = objRole.LoadRoleDetails(id); return(Ok(new { objResult })); } catch (Exception ex) { return(new TextResult(ex.Message, Request, ex.StackTrace)); } }
public IHttpActionResult UpdateRoleWithPermissions([FromBody] ROLEDC objROLE) { ROLEBL objRoleHandler = new ROLEBL(); List <EXCEPTIONDC> lstException = new List <EXCEPTIONDC>(); List <ROLEDC> objROLES = new List <ROLEDC>(1); objROLES.Add(objROLE); try { int IsUpdated = objRoleHandler.Update(objROLES, true, ref lstException); return(Ok(IsUpdated)); } catch (Exception ex) { return(new TextResult(ex.Message, Request, ex.StackTrace)); } }
private ROLEDC FillObject(DataRow row) { ROLEDC objROLE = null; objROLE = new ROLEDC(); objROLE.ROLE_ID = (int)row["ROLE_ID"]; objROLE.ROLE_NAME = (String)row["ROLE_NAME"]; objROLE.DESCRIPTION = (String)row["DESCRIPTION"]; objROLE.IS_RESTRICTED = (Boolean)row["IS_RESTRICTED"]; objROLE.STATUS = (String)row["STATUS"]; objROLE.CREATED_ON = (DateTime)row["CREATED_ON"]; objROLE.CREATED_BY = (int)row["CREATED_BY"]; objROLE.MODIFIED_ON = (DateTime)row["MODIFIED_ON"]; objROLE.MODIFIED_BY = (int)row["MODIFIED_BY"]; objROLE.LOCK_COUNTER = (!string.IsNullOrEmpty(row["LOCK_COUNTER"].ToString()) ? (int)row["LOCK_COUNTER"] : 0); objROLE.IS_ADMIN = (Boolean)row["IS_ADMIN"]; return(objROLE); }
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 ROLEDC LoadRoleDetails(DBConnection Connection, int ROLE_ID) { ROLEDC objROLE = new ROLEDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_ROLESLoadRoleDetails"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_ROLE_ID", DbType.Int32, ROLE_ID); DataSet dsRoleDetails; if (Connection.Transaction != null) { dsRoleDetails = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction); } else { dsRoleDetails = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand); } if (dsRoleDetails.Tables[0].Rows.Count > 0) { objROLE = FillObject(dsRoleDetails.Tables[0].Rows[0]); if (dsRoleDetails.Tables[1].Rows.Count > 0) { ROLES_PERMISSIONDA rolesPermissionsDA = new ROLES_PERMISSIONDA(); foreach (DataRow dr in dsRoleDetails.Tables[1].Rows) { ROLES_PERMISSIONDC objRolePermission = rolesPermissionsDA.FillObject(dr); objROLE.PERMISSIONS.Add(objRolePermission); } } } return(objROLE); }
//public int Insert(DBConnection Connection, ROLEDC objROLEs) //{ // int insertCount = 0; // //foreach (ROLEDC objROLE in objROLEs) // //{ // insertCount = Insert(Connection, objROLEs); // // } // return insertCount; //} public int Insert(DBConnection Connection, ROLEDC objROLE) { int insertCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_ROLESInsert"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddOutParameter("p_ROLE_ID", DbType.Int32, objROLE.ROLE_ID); dbCommandWrapper.AddInParameter("p_ROLE_NAME", DbType.String, objROLE.ROLE_NAME); dbCommandWrapper.AddInParameter("p_DESCRIPTION", DbType.String, objROLE.DESCRIPTION); dbCommandWrapper.AddInParameter("p_IS_RESTRICTED", DbType.Boolean, objROLE.IS_RESTRICTED); dbCommandWrapper.AddInParameter("p_STATUS", DbType.String, objROLE.STATUS); dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objROLE.CREATED_BY); dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objROLE.MODIFIED_BY); try { if (Connection.Transaction != null) { insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } } catch (Exception exp) { //Utilities.InsertIntoErrorLog("Error: ROLE INSERTION ", exp.Message + "\r\n" + exp.StackTrace, objROLE.MODIFIED_BY); objROLE.SetError(exp); throw exp; } objROLE.ROLE_ID = (int)dbCommandWrapper.DBCommand.Parameters["@p_ROLE_ID"].Value; return(insertCount); }
private ROLEDC FillObject(IDataReader reader) { ROLEDC objROLE = null; if (reader != null && reader.Read()) { objROLE = new ROLEDC(); objROLE.ROLE_ID = (int)reader["ROLE_ID"]; objROLE.ROLE_NAME = (String)reader["ROLE_NAME"]; objROLE.DESCRIPTION = (String)reader["DESCRIPTION"]; objROLE.IS_RESTRICTED = (Boolean)reader["IS_RESTRICTED"]; objROLE.STATUS = (String)reader["STATUS"]; objROLE.CREATED_ON = (DateTime)reader["CREATED_ON"]; objROLE.CREATED_BY = (int)reader["CREATED_BY"]; objROLE.MODIFIED_ON = (DateTime)reader["MODIFIED_ON"]; objROLE.MODIFIED_BY = (int)reader["MODIFIED_BY"]; objROLE.LOCK_COUNTER = (!string.IsNullOrEmpty(reader["LOCK_COUNTER"].ToString()) ? (int)reader["LOCK_COUNTER"] : 0); objROLE.IS_ADMIN = (Boolean)reader["IS_ADMIN"]; reader.Close(); reader.Dispose(); } return(objROLE); }
private int Delete(DBConnection Connection, ROLEDC objROLE) { int deleteCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_ROLESDelete"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_ROLE_ID", DbType.Int32, objROLE.ROLE_ID); if (Connection.Transaction != null) { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } return(deleteCount); }
public int Update(DBConnection Connection, ROLEDC objROLE, bool updatePermissions) { int updateCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_ROLESUpdate"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_ROLE_ID", DbType.Int32, objROLE.ROLE_ID); dbCommandWrapper.AddInParameter("p_ROLE_NAME", DbType.String, objROLE.ROLE_NAME); dbCommandWrapper.AddInParameter("p_DESCRIPTION", DbType.String, objROLE.DESCRIPTION); dbCommandWrapper.AddInParameter("p_IS_RESTRICTED", DbType.Boolean, objROLE.IS_RESTRICTED); dbCommandWrapper.AddInParameter("p_STATUS", DbType.String, objROLE.STATUS); dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objROLE.MODIFIED_BY); dbCommandWrapper.AddInParameter("p_lock_counter", DbType.Int32, objROLE.LOCK_COUNTER); try { if (Connection.Transaction != null) { updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } if (updateCount == 0) { objROLE.IsDirty = IsDirty = true; throw new Exception(Constants.ConcurrencyMessageSingleRow); } } catch (Exception exp) { //Utilities.InsertIntoErrorLog("Error: ROLE UPDATE ", exp.Message + "\r\n" + exp.StackTrace, objROLE.MODIFIED_BY); objROLE.SetError(exp); throw exp; } if (updatePermissions && objROLE.PERMISSIONS.Count > 0) { DataTable dtPermissions = new DataTable(); dtPermissions.Columns.Add("ROLE_ID"); dtPermissions.Columns.Add("SCREEN_ID"); dtPermissions.Columns.Add("PERMISSION_TYPE_ID"); dtPermissions.Columns.Add("PERMISSION_TYPE"); dtPermissions.Columns.Add("PERMISSION_TITLE"); dtPermissions.Columns.Add("GENERAL_EDIT_ACCESS_TYPE"); dtPermissions.Columns.Add("VIEW_ACCESS_GENERAL"); dtPermissions.Columns.Add("EDIT_ACCESS"); foreach (ROLES_PERMISSIONDC permission in objROLE.PERMISSIONS) { dtPermissions.Rows.Add(permission.ROLE_ID, permission.SCREEN_ID, permission.PERMISSION_TYPE_ID, permission.PERMISSION_TYPE, permission.PERMISSION_TITLE, permission.GENERAL_EDIT_ACCESS_TYPE, permission.VIEW_ACCESS_GENERAL, permission.EDIT_ACCESS); } sql.Clear(); sql.Append("proc_ROLESUpdateROLES_PERMISSIONS"); SqlDatabase database = (SqlDatabase)Connection.dataBase; DbCommand cmd = database.GetStoredProcCommand(sql.ToString()); database.AddInParameter(cmd, "p_ROLE_ID", SqlDbType.Int, objROLE.ROLE_ID); database.AddInParameter(cmd, "@p_ROLE_PERMISSIONS_TABLE", SqlDbType.Structured, dtPermissions); try { if (Connection.Transaction != null) { updateCount = database.ExecuteNonQuery(cmd, Connection.Transaction); } else { updateCount = database.ExecuteNonQuery(cmd); } if (updateCount == 0) { objROLE.IsDirty = IsDirty = true; throw new Exception(Constants.ConcurrencyMessageSingleRow); } } catch (Exception exp) { //Utilities.InsertIntoErrorLog("Error: ROLES_PERMISSIONS UPDATE ", exp.Message + "\r\n" + exp.StackTrace, objROLE.MODIFIED_BY); objROLE.SetError(exp); throw exp; } } return(updateCount); }