public List <RoleWisePermission> RoleWisePermission_GetAll()
{
DbDataReader oDbDataReader = null;
try
{
List <RoleWisePermission> lstRoleWisePermission = new List <RoleWisePermission>();
DbCommand oDbCommand = DbProviderHelper.CreateCommand("RoleWisePermission_GetAll", CommandType.StoredProcedure);
oDbDataReader = DbProviderHelper.ExecuteReader(oDbCommand);
while (oDbDataReader.Read())
{
RoleWisePermission oRoleWisePermission = new RoleWisePermission();
BuildEntity(oDbDataReader, oRoleWisePermission);
lstRoleWisePermission.Add(oRoleWisePermission);
}
return(lstRoleWisePermission);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (!oDbDataReader.IsClosed)
{
oDbDataReader.Close();
oDbDataReader.Dispose();
}
}
}
private void cmbRole_SelectedValueChanged(object sender, EventArgs e)
{
if (cmbRole.SelectedIndex > -1 && FirstLoadDone)
{
List <RoleWisePermission> lst = new RoleWisePermissionDAO().RoleWisePermission_GetByRoleId(Convert.ToInt32(cmbRole.SelectedValue));
foreach (DataGridViewRow row in dgvPageList.Rows)
{
int pageId = Convert.ToInt32(row.Cells["cPageId"].Value);
if (lst.Count > 0)
{
RoleWisePermission rwp = lst.Where(p => p.PageId == pageId).FirstOrDefault();
if (rwp != null)
{
row.Cells[0].Value = rwp.PermissionId;
row.Cells[1].Value = rwp.PageId;
row.Cells[3].Value = rwp.CanSelect;
}
else
{
row.Cells[0].Value = 0;
row.Cells[1].Value = pageId;
row.Cells[3].Value = false;
}
}
else
{
row.Cells[0].Value = 0;
row.Cells[1].Value = pageId;
row.Cells[3].Value = false;
}
}
}
}
public RoleWisePermission RoleWisePermission_GetById(Int64 PermissionId)
{
DbDataReader oDbDataReader = null;
try
{
RoleWisePermission oRoleWisePermission = new RoleWisePermission();
DbCommand oDbCommand = DbProviderHelper.CreateCommand("RoleWisePermission_GetById", CommandType.StoredProcedure);
AddParameter(oDbCommand, "@PermissionId", DbType.Int64, PermissionId);
oDbDataReader = DbProviderHelper.ExecuteReader(oDbCommand);
while (oDbDataReader.Read())
{
BuildEntity(oDbDataReader, oRoleWisePermission);
}
return(oRoleWisePermission);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (!oDbDataReader.IsClosed)
{
oDbDataReader.Close();
oDbDataReader.Dispose();
}
}
}
public List <RoleWisePermission> RoleWisePermission_GetDynamic(string WhereCondition, string OrderByExpression)
{
DbDataReader oDbDataReader = null;
try
{
List <RoleWisePermission> lstRoleWisePermission = new List <RoleWisePermission>();
DbCommand oDbCommand = DbProviderHelper.CreateCommand("RoleWisePermission_GetDynamic", CommandType.StoredProcedure);
AddParameter(oDbCommand, "@WhereCondition", DbType.String, WhereCondition);
AddParameter(oDbCommand, "@OrderByExpression", DbType.String, OrderByExpression);
oDbDataReader = DbProviderHelper.ExecuteReader(oDbCommand);
while (oDbDataReader.Read())
{
RoleWisePermission oRoleWisePermission = new RoleWisePermission();
BuildEntity(oDbDataReader, oRoleWisePermission);
lstRoleWisePermission.Add(oRoleWisePermission);
}
return(lstRoleWisePermission);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (!oDbDataReader.IsClosed)
{
oDbDataReader.Close();
oDbDataReader.Dispose();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (cmbRole.SelectedIndex > -1)
{
foreach (DataGridViewRow row in dgvPageList.Rows)
{
RoleWisePermission rwp = new RoleWisePermission();
rwp.PermissionId = Convert.ToInt32(row.Cells[0].Value);
rwp.RoleId = Convert.ToInt32(cmbRole.SelectedValue);
rwp.PageId = Convert.ToInt32(row.Cells[1].Value);
rwp.CanSelect = Convert.ToBoolean(row.Cells[3].Value);
rwp.AssignedBy = MDIParent.userId;
rwp.CompanyId = 1;
if (rwp.PermissionId == 0)
{
new RoleWisePermissionDAO().Add(rwp);
}
else
{
new RoleWisePermissionDAO().Update(rwp);
}
}
ClearControls();
MessageBox.Show("Saved Successfully.", "POSsible");
}
else
{
if (cmbRole.SelectedIndex < 0)
{
MessageBox.Show("Please select Role.");
return;
}
}
}
public IActionResult RoleWisePermission([FromBody] RoleWisePermissionCommon permission)
{
if (!ModelState.IsValid)
{
return(StatusCode(400));
}
try
{
//first delete
RoleWisePermission oldPermission = _context.RoleWisePermission.FirstOrDefault(x => x.RoleId == permission.roleWiseUserPermission.RoleId);
if (oldPermission != null)
{
_context.RoleWisePermission.Remove(oldPermission);
}
List <RoleWiseMenuPermission> oldMenuPermission = _context.RoleWiseMenuPermission.Where(x => x.RoleId == permission.roleWiseMenuPermissions.FirstOrDefault().RoleId).ToList();
if (oldMenuPermission != null)
{
_context.RoleWiseMenuPermission.RemoveRange(oldMenuPermission);
}
//then add
_context.RoleWisePermission.Add(permission.roleWiseUserPermission);
_context.RoleWiseMenuPermission.AddRange(permission.roleWiseMenuPermissions);
//finally save all changes
_context.SaveChanges();
TempData["StatusMessage"] = "Saved Successfully !!";
return(Ok(permission.roleWiseUserPermission.RoleId));
}
catch
{
ModelState.AddModelError("Error", "Error occour, try again later !!");
return(StatusCode(500));
}
}
public IHttpActionResult UpdateRolePermission([FromBody] RoleWisePermission rolePermission)
{
DataBind data = activities.SaveUpdateRolePermission(rolePermission);
AuditTrialReport.SaveAuditReport(User.Identity.Name, "Update", data.dataBefore, data.dataAfter);
return(Ok("Successfully updated Role Permission"));
}
private static void BuildEntity(DbDataReader oDbDataReader, RoleWisePermission oRoleWisePermission)
{
DataTable dt = oDbDataReader.GetSchemaTable();
foreach (DataRow item in dt.Rows)
{
string col = item.ItemArray[0].ToString();
switch (col)
{
case "PermissionId":
oRoleWisePermission.PermissionId = Convert.ToInt64(oDbDataReader["PermissionId"]);
break;
case "RoleId":
oRoleWisePermission.RoleId = Convert.ToInt32(oDbDataReader["RoleId"]);
break;
case "PageId":
oRoleWisePermission.PageId = Convert.ToInt32(oDbDataReader["PageId"]);
break;
case "CanCreate":
oRoleWisePermission.CanCreate = Convert.ToBoolean(oDbDataReader["CanCreate"]);
break;
case "CanDelete":
oRoleWisePermission.CanDelete = Convert.ToBoolean(oDbDataReader["CanDelete"]);
break;
case "CanUpdate":
oRoleWisePermission.CanUpdate = Convert.ToBoolean(oDbDataReader["CanUpdate"]);
break;
case "CanSelect":
oRoleWisePermission.CanSelect = Convert.ToBoolean(oDbDataReader["CanSelect"]);
break;
case "AssignedBy":
oRoleWisePermission.AssignedBy = Convert.ToInt32(oDbDataReader["AssignedBy"]);
break;
case "CompanyId":
oRoleWisePermission.CompanyId = Convert.ToInt32(oDbDataReader["CompanyId"]);
break;
default:
break;
}
}
}
public int Update(RoleWisePermission _RoleWisePermission)
{
try
{
DbCommand oDbCommand = DbProviderHelper.CreateCommand("RoleWisePermission_Update", CommandType.StoredProcedure);
AddParameter(oDbCommand, "@RoleId", DbType.Int32, _RoleWisePermission.RoleId);
AddParameter(oDbCommand, "@PageId", DbType.Int32, _RoleWisePermission.PageId);
AddParameter(oDbCommand, "@CanCreate", DbType.Boolean, _RoleWisePermission.CanCreate);
AddParameter(oDbCommand, "@CanDelete", DbType.Boolean, _RoleWisePermission.CanDelete);
AddParameter(oDbCommand, "@CanUpdate", DbType.Boolean, _RoleWisePermission.CanUpdate);
AddParameter(oDbCommand, "@CanSelect", DbType.Boolean, _RoleWisePermission.CanSelect);
AddParameter(oDbCommand, "@AssignedBy", DbType.Int32, _RoleWisePermission.AssignedBy);
AddParameter(oDbCommand, "@CompanyId", DbType.Int32, _RoleWisePermission.CompanyId);
AddParameter(oDbCommand, "@PermissionId", DbType.Int64, _RoleWisePermission.PermissionId);
return(DbProviderHelper.ExecuteNonQuery(oDbCommand));
}
catch (Exception ex)
{
throw ex;
}
}
public List <RoleWisePermission> RoleWisePermission_GetPaged(int StartRowIndex, int RowPerPage, string WhereClause, string SortColumn, string SortOrder, ref int rows)
{
DbDataReader oDbDataReader = null;
try
{
List <RoleWisePermission> lstRoleWisePermission = new List <RoleWisePermission>();
DbCommand oDbCommand = DbProviderHelper.CreateCommand("RoleWisePermission_GetPaged", CommandType.StoredProcedure);
AddParameter(oDbCommand, "@StartRowIndex", DbType.Int32, StartRowIndex);
AddParameter(oDbCommand, "@RowPerPage", DbType.Int32, RowPerPage);
AddParameter(oDbCommand, "@WhereClause", DbType.String, WhereClause);
AddParameter(oDbCommand, "@SortColumn", DbType.String, SortColumn);
AddParameter(oDbCommand, "@SortOrder", DbType.String, SortOrder);
oDbDataReader = DbProviderHelper.ExecuteReader(oDbCommand);
while (oDbDataReader.Read())
{
RoleWisePermission oRoleWisePermission = new RoleWisePermission();
BuildEntity(oDbDataReader, oRoleWisePermission);
lstRoleWisePermission.Add(oRoleWisePermission);
}
if ((oDbDataReader.NextResult()) && (oDbDataReader.Read()))
{
rows = oDbDataReader.GetInt32(0);
}
return(lstRoleWisePermission);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (!oDbDataReader.IsClosed)
{
oDbDataReader.Close();
oDbDataReader.Dispose();
}
}
}
public DataBind SaveUpdateRolePermission(RoleWisePermission rolePermissionList)
{
var RoleObject = db.Roles.Where(s => s.Id == rolePermissionList.RoleId).FirstOrDefault();
if (RoleObject.AspNetRoles.Any())
{
List <string> access = new List <string>();
foreach (var rolePermission in RoleObject.AspNetRoles.ToList())
{
RoleObject.AspNetRoles.Remove(rolePermission);
access.Add(rolePermission.Name);
}
var data1 = new { RoleName = RoleObject.RoleName, AccessList = access.ToArray() };
dataBind.dataBefore = JsonConvert.SerializeObject(data1);
}
List <string> access1 = new List <string>();
foreach (var Role in rolePermissionList.PermissionList.Distinct())
{
RoleObject.AspNetRoles.Add(db.AspNetRoles.Where(p => p.Id == Role.Id).FirstOrDefault());
access1.Add(Role.Name);
}
var data2 = new { RoleName = RoleObject.RoleName, AccessList = access1.ToArray() };
dataBind.dataAfter = JsonConvert.SerializeObject(data2);
db.SaveChanges();
db.Dispose();
return(dataBind);
}
public IHttpActionResult SaveRolePermission([FromBody] RoleWisePermission rolePermission)
{
activities.SaveUpdateRolePermission(rolePermission);
return(Ok("Successfully added Role Permission"));
}
