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