public async Task <ResponseAC> AddRole(RoleAC roleAC, long userId, string loginUserName)
{
ResponseAC responeAC = new ResponseAC();
if (!await _dbTeleBilling_V01Context.MstRole.AnyAsync(x => x.RoleName.ToLower() == roleAC.RoleName.Trim().ToLower() && !x.IsDelete))
{
MstRole mstRole = new MstRole();
mstRole.IsActive = true;
mstRole.RoleName = roleAC.RoleName.Trim();
mstRole.CreatedBy = userId;
mstRole.CreatedDate = DateTime.Now;
mstRole.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
try
{
await _dbTeleBilling_V01Context.AddAsync(mstRole);
await _dbTeleBilling_V01Context.SaveChangesAsync();
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.AddRole, loginUserName, userId, "Role(" + roleAC.RoleName.Trim() + ")", (int)EnumList.ActionTemplateTypes.Add, mstRole.RoleId);
}
catch (Exception e)
{
throw e;
}
responeAC.Message = _iStringConstant.RoleAddedSuccessfully;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
}
else
{
responeAC.Message = _iStringConstant.RoleExists;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
}
return(responeAC);
}
public async Task <IActionResult> Edit(int id, [Bind("PkRoleId,RoleName,IsActive")] MstRole mstRole)
{
if (id != mstRole.PkRoleId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(mstRole);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MstRoleExists(mstRole.PkRoleId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(mstRole));
}
public async Task <IActionResult> Create([Bind("PkRoleId,RoleName,IsActive")] MstRole mstRole)
{
if (ModelState.IsValid)
{
_context.Add(mstRole);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(mstRole));
}
public async Task <ResponseAC> EditRole(RoleAC roleAC, long userId, string loginUserName)
{
ResponseAC responeAC = new ResponseAC();
try
{
if (!await _dbTeleBilling_V01Context.MstRole.AnyAsync(x => x.RoleId != roleAC.RoleId && x.RoleName.ToLower() == roleAC.RoleName.Trim().ToLower() && !x.IsDelete))
{
MstRole mstRole = await _dbTeleBilling_V01Context.MstRole.FirstOrDefaultAsync(x => x.RoleId == roleAC.RoleId && !x.IsDelete);
#region Transaction Log Entry
if (mstRole.TransactionId == null)
{
mstRole.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
}
var jsonSerailzeObj = JsonConvert.SerializeObject(mstRole);
await _iLogManagement.SaveRequestTraseLog(Convert.ToInt64(mstRole.TransactionId), userId, Convert.ToInt64(EnumList.TransactionTraseLog.UpdateRecord), jsonSerailzeObj);
#endregion
mstRole.RoleName = roleAC.RoleName.Trim();
mstRole.UpdatedBy = userId;
mstRole.UpdatedDate = DateTime.Now;
_dbTeleBilling_V01Context.Update(mstRole);
await _dbTeleBilling_V01Context.SaveChangesAsync();
responeAC.Message = _iStringConstant.RoleUpdatedSuccessfully;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.EditRole, loginUserName, userId, "Role(" + roleAC.RoleName.Trim() + ")", (int)EnumList.ActionTemplateTypes.Edit, mstRole.RoleId);
}
else
{
responeAC.Message = _iStringConstant.RoleExists;
responeAC.StatusCode = Convert.ToInt16(EnumList.ResponseType.Error);
}
}
catch (Exception e)
{
throw e;
}
return(responeAC);
}
public async Task <ResponseAC> UpdateRoleRights(long userId, List <RoleRightsAC> roleRightsACList, string loginUserName)
{
ResponseAC responseAc = new ResponseAC();
long roleId = roleRightsACList[0].RoleId;
List <MstRolerights> roleRights = await _dbTeleBilling_V01Context.MstRolerights.Where(x => x.RoleId == roleId).Include(x => x.Role).ToListAsync();
int actionId = (int)EnumList.ActionTemplateTypes.Add;
MstRole role = new MstRole();
role = await _dbTeleBilling_V01Context.MstRole.FindAsync(roleId);
if (roleRights.Any())
{
//#region Transaction Log Entry
//var jsonSerailzeObj = JsonConvert.SerializeObject(roleRights);
//await _iLogManagement.SaveRequestTraseLog(Convert.ToInt64(roleRights[0].TransactionId), userId, Convert.ToInt64(EnumList.TransactionTraseLog.UpdateRecord), jsonSerailzeObj);
//#endregion
_dbTeleBilling_V01Context.MstRolerights.RemoveRange(roleRights);
_dbTeleBilling_V01Context.SaveChanges();
actionId = (int)EnumList.ActionTemplateTypes.Edit;
}
roleRights = new List <MstRolerights>();
foreach (var item in roleRightsACList)
{
MstRolerights newRoleRights = new MstRolerights();
newRoleRights = _mapper.Map <MstRolerights>(item);
newRoleRights.CreatedBy = userId;
newRoleRights.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
newRoleRights.CreatedDate = DateTime.Now;
roleRights.Add(newRoleRights);
}
await _dbTeleBilling_V01Context.MstRolerights.AddRangeAsync(roleRights);
_dbTeleBilling_V01Context.SaveChanges();
responseAc.Message = _iStringConstant.RoleRightsUpdatedSuccessfully;
responseAc.StatusCode = Convert.ToInt16(EnumList.ResponseType.Success);
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.ChangeRoleRights, loginUserName, userId, "Rolerights(" + Convert.ToString(role.RoleName) + ")", actionId, null);
return(responseAc);
}
public async Task <bool> DeleteRole(long roleId, long userId, string loginUserName)
{
List <MstEmployee> mstEmployee = await _dbTeleBilling_V01Context.MstEmployee.Where(x => x.RoleId == roleId && x.IsActive && !x.IsDelete).ToListAsync();
if (!mstEmployee.Any())
{
MstRole mstRole = await _dbTeleBilling_V01Context.MstRole.FirstOrDefaultAsync(x => x.RoleId == roleId);
mstRole.IsDelete = true;
mstRole.UpdatedBy = userId;
mstRole.UpdatedDate = DateTime.Now;
_dbTeleBilling_V01Context.Update(mstRole);
await _dbTeleBilling_V01Context.SaveChangesAsync();
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.DeleteRole, loginUserName, userId, "Role(" + mstRole.RoleName.Trim() + ")", (int)EnumList.ActionTemplateTypes.Delete, mstRole.RoleId);
return(true);
}
return(false);
}
public async Task <bool> ChangeRoleStatus(long roleId, long userId, string loginUserName)
{
MstRole mstRole = await _dbTeleBilling_V01Context.MstRole.FirstOrDefaultAsync(x => x.RoleId == roleId);
if (mstRole != null)
{
#region Transaction Log Entry
if (mstRole.TransactionId == null)
{
mstRole.TransactionId = _iLogManagement.GenerateTeleBillingTransctionID();
}
var jsonSerailzeObj = JsonConvert.SerializeObject(mstRole);
await _iLogManagement.SaveRequestTraseLog(Convert.ToInt64(mstRole.TransactionId), userId, Convert.ToInt64(EnumList.TransactionTraseLog.ChangeStatus), jsonSerailzeObj);
#endregion
mstRole.IsActive = !mstRole.IsActive;
mstRole.UpdatedBy = userId;
mstRole.UpdatedDate = DateTime.Now;
_dbTeleBilling_V01Context.Update(mstRole);
await _dbTeleBilling_V01Context.SaveChangesAsync();
if (mstRole.IsActive)
{
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.ActiveRole, loginUserName, userId, "Role(" + mstRole.RoleName.Trim() + ")", (int)EnumList.ActionTemplateTypes.Active, mstRole.RoleId);
}
else
{
await _iLogManagement.SaveAuditActionLog((int)EnumList.AuditLogActionType.DeactiveRole, loginUserName, userId, "Role(" + mstRole.RoleName.Trim() + ")", (int)EnumList.ActionTemplateTypes.Deactive, mstRole.RoleId);
}
return(true);
}
return(false);
}
public async Task <RoleAC> GetRoleById(long roleId)
{
MstRole role = await _dbTeleBilling_V01Context.MstRole.FirstOrDefaultAsync(x => !x.IsDelete && x.RoleId == roleId);
return(_mapper.Map <RoleAC>(role));
}
private async void AddEmploye(IServiceProvider serviceProvider)
{
var _dbTeleBilling_V01Context = serviceProvider.GetService <TeleBilling_V01Context>();
#region Added Role
MstRole mstRole = new MstRole();
mstRole.IsActive = true;
mstRole.RoleName = "Super Admin";
mstRole.CreatedBy = 1;
mstRole.CreatedDate = DateTime.Now;
mstRole.TransactionId = 080820191635;
await _dbTeleBilling_V01Context.AddAsync(mstRole);
await _dbTeleBilling_V01Context.SaveChangesAsync();
#endregion
#region Added Business Unit
MstBusinessUnit mstBusinessUnit = new MstBusinessUnit();
mstBusinessUnit.IsActive = true;
mstBusinessUnit.Name = "RISK MANAGEMENT & CONTROL";
mstBusinessUnit.CreatedBy = 1;
mstBusinessUnit.CreatedDate = DateTime.Now;
await _dbTeleBilling_V01Context.AddAsync(mstBusinessUnit);
await _dbTeleBilling_V01Context.SaveChangesAsync();
#endregion
#region Added Department
MstDepartment mstDepartment = new MstDepartment();
mstDepartment.IsActive = true;
mstDepartment.Name = "Business";
mstDepartment.BusinessUnitId = mstBusinessUnit.Id;
mstDepartment.CreatedBy = 1;
mstDepartment.CreatedDate = DateTime.Now;
await _dbTeleBilling_V01Context.AddAsync(mstDepartment);
await _dbTeleBilling_V01Context.SaveChangesAsync();
#endregion
#region Added CostCenter
MstCostCenter mstCostCenter = new MstCostCenter();
mstCostCenter.BusinessUnitid = mstBusinessUnit.Id;
mstCostCenter.CostCenterCode = "001";
mstCostCenter.Name = "Vadodra Center";
mstCostCenter.CreatedBy = 1;
mstCostCenter.CreatedDate = DateTime.Now;
await _dbTeleBilling_V01Context.AddAsync(mstCostCenter);
await _dbTeleBilling_V01Context.SaveChangesAsync();
#endregion
#region Added Dummy User in Employee
MstEmployee mstEmployee = new MstEmployee();
mstEmployee.FullName = "Super Admin";
mstEmployee.ExtensionNumber = "08082019";
mstEmployee.EmpPfnumber = "123456";
mstEmployee.EmailId = "*****@*****.**";
mstEmployee.Password = "******";
mstEmployee.RoleId = mstRole.RoleId;
mstEmployee.IsActive = true;
mstEmployee.IsSystemUser = true;
mstEmployee.DepartmentId = mstDepartment.Id;
mstEmployee.Designation = "Administrator";
mstEmployee.Description = "super admin role";
mstEmployee.BusinessUnitId = mstBusinessUnit.Id;
mstEmployee.CostCenterId = mstCostCenter.Id;
mstEmployee.CountryId = 1;
mstEmployee.IsPresidentOffice = true;
mstEmployee.LineManagerId = 1;
mstEmployee.CreatedBy = 1;
mstEmployee.CreatedDate = DateTime.Now;
mstEmployee.TransactionId = 080820191636;
await _dbTeleBilling_V01Context.AddAsync(mstEmployee);
await _dbTeleBilling_V01Context.SaveChangesAsync();
#endregion
}
