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 Guid Add(UserBE entity)
{
var dbContext = new DBContext();
try
{
var dataSet = new DataSet();
var parameters = Array.Empty <SqlParameter>();
var userguid = Guid.NewGuid();
parameters = new SqlParameter[11];
parameters[0] = dbContext.CreateParameters("@imgKey", !string.IsNullOrEmpty(entity.ImgKey) ? entity.ImgKey : null);
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[8] = dbContext.CreateParameters("@artistName", !string.IsNullOrEmpty(entity.ArtistName) ? entity.ArtistName : null);
parameters[7] = dbContext.CreateParameters("@serviceID", entity.Contract.Service.Id == Guid.Empty ? Guid.Empty : entity.Contract.Service.Id);
parameters[9] = dbContext.CreateParameters("@userid", userguid);
parameters[10] = dbContext.CreateParameters("@contractID", entity.Contract.Service.Id == Guid.Empty ? Guid.Empty : Guid.NewGuid());
dbContext.BeginTran();
if (dbContext.Write("AddUser", parameters) > 0)
{
entity.Id = userguid;
PermissionDAL per = new PermissionDAL();
bool resultper = per.SetUserPermission(entity, dbContext);
if (resultper)
{
dbContext.CommitTran();
return(userguid);
}
}
dbContext.RollBackTran();
return(Guid.Empty);
}
catch (Exception ex)
{
dbContext.RollBackTran();
throw new Exception(Messages.Generic_Error);
}
}
