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 }