private questStatus read(FMSEntities dbContext, string username, out Quest.Services.Dbio.FMS.Users user)
{
// Initialize
user = null;
try
{
user = dbContext.Users.Where(r => r.Username == username).SingleOrDefault();
if (user == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("Id {0} not found", username))));
}
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
String fullErrorMessage = string.Join("; ", errorMessages);
String exceptionMessage = string.Concat(ex.Message, " The DbEntityValidationException errors are: ", fullErrorMessage);
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
exceptionMessage)));
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, string username, out User user)
{
// Initialize
questStatus status = null;
user = null;
// Perform transaction read.
Quest.Services.Dbio.FMS.Users _user = null;
status = read((FMSEntities)trans.DbContext, username, out _user);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
user = new User();
BufferMgr.TransferBuffer(_user, user);
return(new questStatus(Severity.Success));
}
private questStatus setPassword(FMSEntities dbContext, PasswordPair passwordPair)
{
// Initialize
questStatus status = null;
try
{
// Read the user.
UserId userId = new UserId(passwordPair.Id);
Quest.Services.Dbio.FMS.Users _user = null;
status = read(dbContext, userId, out _user);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Update the password.
_user.Password = passwordPair.Password;
dbContext.SaveChanges();
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
String fullErrorMessage = string.Join("; ", errorMessages);
String exceptionMessage = string.Concat(ex.Message, " The DbEntityValidationException errors are: ", fullErrorMessage);
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
exceptionMessage)));
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
public questStatus Read(string username, out User user)
{
// Initialize
questStatus status = null;
user = null;
// Perform read
using (FMSEntities dbContext = new FMSEntities())
{
Quest.Services.Dbio.FMS.Users _user = null;
status = read(dbContext, username, out _user);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
user = new User();
BufferMgr.TransferBuffer(_user, user);
}
return(new questStatus(Severity.Success));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Users
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(FMSEntities dbContext, User user, out UserId userId)
{
// Initialize
userId = null;
// Perform create
try
{
Quest.Services.Dbio.FMS.Users _user = new Quest.Services.Dbio.FMS.Users();
BufferMgr.TransferBuffer(user, _user);
dbContext.Users.Add(_user);
dbContext.SaveChanges();
if (_user.Id == 0)
{
return(new questStatus(Severity.Error, "User not created"));
}
userId = new UserId(_user.Id);
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
String fullErrorMessage = string.Join("; ", errorMessages);
String exceptionMessage = string.Concat(ex.Message, " The DbEntityValidationException errors are: ", fullErrorMessage);
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
exceptionMessage)));
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
