public bool SetUserPermission(UserBE entity) { var dbContext = new DBContext(); bool result = false; try { dbContext.BeginTran(); PermissionDAL per = new PermissionDAL(); if (per.DeleteUserPermission(entity, dbContext)) { result = per.SetUserPermission(entity, dbContext); } if (result) { dbContext.CommitTran(); return(result); } dbContext.RollBackTran(); return(result); } catch (Exception) { return(result); } }
public bool Update(UserBE entity) { var dbContext = new DBContext(); try { var dataSet = new DataSet(); var parameters = Array.Empty <SqlParameter>(); PermissionDAL permissionDAL = new PermissionDAL(); parameters = new SqlParameter[11]; parameters[0] = dbContext.CreateParameters("@userid", entity.Id); parameters[1] = dbContext.CreateParameters("@userName", entity.UserName); parameters[2] = dbContext.CreateParameters("@lastName", entity.LastName); parameters[3] = dbContext.CreateParameters("@name", entity.Name); parameters[4] = dbContext.CreateParameters("@languageID", entity.Language.Id); parameters[5] = dbContext.CreateParameters("@email", !string.IsNullOrEmpty(entity.Email) ? entity.Email : null); parameters[6] = dbContext.CreateParameters("@password", entity.Password); parameters[9] = dbContext.CreateParameters("@artistName", !string.IsNullOrEmpty(entity.ArtistName) ? entity.ArtistName : null); parameters[7] = dbContext.CreateParameters("@contractID", entity.Contract == null ? Guid.Empty : Guid.NewGuid()); parameters[8] = dbContext.CreateParameters("@imgKey", !string.IsNullOrEmpty(entity.ImgKey) ? entity.ImgKey : null); parameters[10] = dbContext.CreateParameters("@serviceID", entity.Contract == null ? Guid.Empty : entity.Contract.Service.Id); dbContext.BeginTran(); if (dbContext.Write("UpdateUser", parameters) > 0) { permissionDAL.DeleteUserPermission(entity, dbContext); permissionDAL.SetUserPermission(entity, dbContext); dbContext.CommitTran(); return(true); } dbContext.RollBackTran(); return(false); } catch (Exception ex) { dbContext.RollBackTran(); throw new Exception(Messages.Generic_Error); } }