public questStatus Read(TypeListId typeListId, out TypeListEditorViewModel typeListEditorViewModel)
{
// Initialize
questStatus status = null;
typeListEditorViewModel = null;
// Read
Quest.Functional.MasterPricing.TypeList typeList = null;
TypeListsMgr typeListsMgr = new TypeListsMgr(this.UserSession);
status = typeListsMgr.Read(typeListId, out typeList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Transfer model.
typeListEditorViewModel = new TypeListEditorViewModel(this.UserSession);
BufferMgr.TransferBuffer(typeList, typeListEditorViewModel);
return(new questStatus(Severity.Success));
}
private questStatus read(MasterPricingEntities dbContext, TypeListId typeListId, out Quest.Services.Dbio.MasterPricing.TypeLists typeList)
{
// Initialize
questStatus status = null;
typeList = null;
try
{
typeList = dbContext.TypeLists.Where(r => r.Id == typeListId.Id).SingleOrDefault();
if (typeList == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("Id {0} not found", typeListId.Id))));
}
}
catch (System.Exception ex)
{
status = new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message));
LogException(ex, status);
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(DbMgrTransaction trans, TypeListId typeListId)
{
// Initialize
questStatus status = null;
// Delete typeList
status = _dbTypeListsMgr.Delete(trans, typeListId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus GetTypeListOptions(TypeListId typeListId, List <TypeListArgument> typeListArgumentList, out List <OptionValuePair> typeListOptionList)
{
// Initialize
questStatus status = null;
// Get typeList options
status = _dbTypeListMgr.GetTypeListOptions(typeListId, typeListArgumentList, out typeListOptionList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(TypeListId typeListId, out TypeList typeList)
{
// Initialize
typeList = null;
questStatus status = null;
// Read typeList
status = _dbTypeListsMgr.Read(typeListId, out typeList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Properties
*=================================================================================================================================*/
#endregion
#region Public Methods
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Create(TypeList typeList, out TypeListId typeListId)
{
// Initialize
typeListId = null;
questStatus status = null;
// Create typeList
status = _dbTypeListsMgr.Create(typeList, out typeListId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(DbMgrTransaction trans, TypeListId typeListId)
{
// Initialize
questStatus status = null;
// Perform delete in this transaction.
status = delete((MasterPricingEntities)trans.DbContext, typeListId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(TypeListId typeListId)
{
// Initialize
questStatus status = null;
// Delete
TypeListsMgr typeListsMgr = new TypeListsMgr(this.UserSession);
status = typeListsMgr.Delete(typeListId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(TypeListId typeListId)
{
// Initialize
questStatus status = null;
// Perform delete.
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = delete(dbContext, typeListId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
public ActionResult Read(TypeListEditorViewModel editorViewModel)
{
questStatus status = null;
UserMessageModeler userMessageModeler = null;
/*----------------------------------------------------------------------------------------------------------------------------------
* Log Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
status = LogOperation();
if (!questStatusDef.IsSuccess(status))
{
userMessageModeler = new UserMessageModeler(status);
return(Json(userMessageModeler, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Authorize
*---------------------------------------------------------------------------------------------------------------------------------*/
status = Authorize(editorViewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
userMessageModeler = new UserMessageModeler(status);
return(Json(userMessageModeler, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Perform operation.
*---------------------------------------------------------------------------------------------------------------------------------*/
TypeListId typeListId = new TypeListId(editorViewModel.Id);
TypeListEditorViewModel typeListEditorViewModel = null;
TypeListEditorModeler typeListEditorModeler = new Modelers.TypeListEditorModeler(this.Request, this.UserSession);
status = typeListEditorModeler.Read(typeListId, out typeListEditorViewModel);
if (!questStatusDef.IsSuccess(status))
{
userMessageModeler = new UserMessageModeler(status);
return(Json(userMessageModeler, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return result.
*---------------------------------------------------------------------------------------------------------------------------------*/
status = new questStatus(Severity.Success);
typeListEditorViewModel.questStatus = status;
return(Json(typeListEditorViewModel, JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(TypeListEditorViewModel typeListEditorViewModel)
{
questStatus status = null;
/*----------------------------------------------------------------------------------------------------------------------------------
* Log Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
status = LogOperation();
if (!questStatusDef.IsSuccess(status))
{
// TODO
throw new Exception("LogOperation failed");
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Authorize
*---------------------------------------------------------------------------------------------------------------------------------*/
status = Authorize(typeListEditorViewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
// TODO
throw new Exception("Authorize failed");
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Perform operation.
*---------------------------------------------------------------------------------------------------------------------------------*/
TypeListId typeListId = new TypeListId(typeListEditorViewModel.Id);
TypeListEditorModeler typeListEditorModeler = new TypeListEditorModeler(this.Request, this.UserSession);
status = typeListEditorModeler.Delete(typeListId);
if (!questStatusDef.IsSuccess(status))
{
typeListEditorViewModel.questStatus = status;
return(Json(typeListEditorViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return result.
*---------------------------------------------------------------------------------------------------------------------------------*/
status = new questStatus(Severity.Success, "TypeList successfully deleted");
typeListEditorViewModel.questStatus = status;
return(Json(typeListEditorViewModel, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* TypeLists
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(MasterPricingEntities dbContext, Quest.Functional.MasterPricing.TypeList typeList, out TypeListId typeListId)
{
// Initialize
questStatus status = null;
typeListId = null;
// Perform create
try
{
Quest.Services.Dbio.MasterPricing.TypeLists _typeList = new Quest.Services.Dbio.MasterPricing.TypeLists();
BufferMgr.TransferBuffer(typeList, _typeList);
dbContext.TypeLists.Add(_typeList);
dbContext.SaveChanges();
if (_typeList.Id == 0)
{
return(new questStatus(Severity.Error, "Quest.Functional.MasterPricing.TypeList not created"));
}
typeListId = new TypeListId(_typeList.Id);
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
String fullErrorMessage = string.Join("; ", errorMessages);
String exceptionMessage = string.Concat(ex.Message, fullErrorMessage);
status = new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
exceptionMessage));
LogException(ex, status);
return(status);
}
catch (System.Exception ex)
{
status = new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message));
LogException(ex, status);
return(status);
}
return(new questStatus(Severity.Success));
}
private questStatus delete(MasterPricingEntities dbContext, TypeListId typeListId)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
Quest.Services.Dbio.MasterPricing.TypeLists _typeList = null;
status = read(dbContext, typeListId, out _typeList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete the record.
dbContext.TypeLists.Remove(_typeList);
dbContext.SaveChanges();
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
String fullErrorMessage = string.Join("; ", errorMessages);
String exceptionMessage = string.Concat(ex.Message, fullErrorMessage);
status = new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
exceptionMessage));
LogException(ex, status);
return(status);
}
catch (System.Exception ex)
{
status = new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message));
LogException(ex, status);
return(status);
}
status = new questStatus(Severity.Success, "TypeList successfully deleted. TypeListId.Id=" + typeListId.Id);
return(status);
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Read(TypeListViewModel typeListViewModel, out List <OptionValuePair> typeListOptionList)
{
// Initialize
questStatus status = null;
typeListOptionList = null;
// Get typeList options
TypeListId typeListId = new TypeListId(typeListViewModel.Id);
List <TypeListArgument> typeListArgumentList = null; // TODO
TypeListMgr typeListMgr = new TypeListMgr(this.UserSession);
status = typeListMgr.GetTypeListOptions(typeListId, typeListArgumentList, out typeListOptionList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Properties
*=================================================================================================================================*/
#endregion
#region Public Methods
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Create(Quest.Functional.MasterPricing.TypeList typeList, out TypeListId typeListId)
{
// Initialize
questStatus status = null;
typeListId = null;
// Data rules.
// Create the typeList
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = create(dbContext, typeList, out typeListId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, TypeListId typeListId, out Quest.Functional.MasterPricing.TypeList typeList)
{
// Initialize
questStatus status = null;
typeList = null;
// Perform read.
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
Quest.Services.Dbio.MasterPricing.TypeLists _typeList = null;
status = read((MasterPricingEntities)trans.DbContext, typeListId, out _typeList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
typeList = new Quest.Functional.MasterPricing.TypeList();
BufferMgr.TransferBuffer(_typeList, typeList);
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
#region CRUD
//----------------------------------------------------------------------------------------------------------------------------------
// CRUD
//----------------------------------------------------------------------------------------------------------------------------------
public questStatus Save(TypeListEditorViewModel typeListEditorViewModel)
{
// Initialize
questStatus status = null;
// Transfer model
Quest.Functional.MasterPricing.TypeList typeList = new Functional.MasterPricing.TypeList();
BufferMgr.TransferBuffer(typeListEditorViewModel, typeList);
// Determine if this is a create or update
TypeListsMgr typeListsMgr = new TypeListsMgr(this.UserSession);
if (typeListEditorViewModel.Id < BaseId.VALID_ID)
{
// Create
TypeListId typeListId = null;
status = typeListsMgr.Create(typeList, out typeListId);
if (!questStatusDef.IsSuccess(status))
{
FormatErrorMessage(status, typeListEditorViewModel);
return(status);
}
typeListEditorViewModel.Id = typeListId.Id;
}
else
{
// Update
status = typeListsMgr.Update(typeList);
if (!questStatusDef.IsSuccess(status))
{
FormatErrorMessage(status, typeListEditorViewModel);
return(status);
}
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, Quest.Functional.MasterPricing.TypeList typeList, out TypeListId typeListId)
{
// Initialize
questStatus status = null;
typeListId = null;
// Data rules.
// Create the typeList in this transaction.
status = create((MasterPricingEntities)trans.DbContext, typeList, out typeListId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Properties
*=================================================================================================================================*/
#endregion
#region Public Methods
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus GetTypeListOptions(TypeListId typeListId, List <TypeListArgument> typeListArgumentList, out List <OptionValuePair> typeListOptionList)
{
// Initialize
questStatus status = null;
typeListOptionList = null;
// Get the typeList.
TypeList typeList = null;
DbTypeListsMgr dbTypeListsMgr = new DbTypeListsMgr(this.UserSession);
status = dbTypeListsMgr.Read(typeListId, out typeList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Get the database.
DatabaseId databaseId = new DatabaseId(typeList.DatabaseId);
Quest.Functional.MasterPricing.Database database = null;
DbDatabasesMgr dbDatabasesMgr = new DbDatabasesMgr(this.UserSession);
status = dbDatabasesMgr.Read(databaseId, out database);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Apply typeList arguments.
if (typeListArgumentList == null)
{
typeListArgumentList = new List <TypeListArgument>();
}
string sql = typeList.SQL;
foreach (TypeListArgument typeListArgument in typeListArgumentList)
{
sql = sql.Replace(typeListArgument.Name, typeListArgument.Value);
}
try
{
using (SqlConnection conn = new SqlConnection(database.ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(null, conn))
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
using (SqlDataReader rdr = cmd.ExecuteReader())
{
typeListOptionList = new List <OptionValuePair>();
while (rdr.Read())
{
OptionValuePair optionValuePair = new OptionValuePair();
optionValuePair.Id = rdr[0].ToString();
optionValuePair.Label = rdr[0].ToString();
typeListOptionList.Add(optionValuePair);
}
}
}
}
}
catch (System.Exception ex)
{
status = new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().ToString(), MethodInfo.GetCurrentMethod().Name, ex.Message));
return(status);
}
return(new questStatus(Severity.Success));
}
