public questStatus List(ParameterListViewModel viewModel, out ParameterListViewModel parameterListViewModel)
{
// Initialize
questStatus status = null;
parameterListViewModel = null;
// Get stored procedure parameters
StoredProcedureId storedProcedureId = new StoredProcedureId(viewModel.StoredProcedureId);
List <StoredProcedureParameter> storedProcedureParameterList = null;
StoredProcedureParametersMgr storedProcedureParametersMgr = new StoredProcedureParametersMgr(this.UserSession);
status = storedProcedureParametersMgr.Read(storedProcedureId, out storedProcedureParameterList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Sort by display order
// NOTE: ORDER IN DATABASE -SHOULD- BE ORDER IN SPROC.
// Transfer model.
parameterListViewModel = new ParameterListViewModel(this.UserSession, viewModel);
parameterListViewModel.StoredProcedureId = viewModel.StoredProcedureId;
foreach (StoredProcedureParameter storedProcedureParameter in storedProcedureParameterList)
{
ParameterLineItemViewModel parameterLineItemViewModel = new ParameterLineItemViewModel();
BufferMgr.TransferBuffer(storedProcedureParameter, parameterLineItemViewModel);
parameterLineItemViewModel.bRequired = storedProcedureParameter.bRequired ? "Yes" : "No";
parameterListViewModel.Items.Add(parameterLineItemViewModel);
}
return(new questStatus(Severity.Success));
}
public ActionResult Global()
{
ViewData["label1"] = "Produk";
ViewData["lblSP1"] = "Kode";
ViewData["lblSP2"] = "Deskripsi";
ViewData["lblSP4"] = "Tanggal valuta";
ViewData["lblOffice"] = "Kode Kantor";
ParameterListViewModel vModel = new ParameterListViewModel();
List <TreeViewModel> listTree = new List <TreeViewModel>();
listTree = GetTreeView("mnuParamGlobal");
var items = new List <TreeViewModel>();
var root = listTree[0];
for (int i = 0; i < listTree.Count; i++)
{
if (listTree[i].ParentId == "")
{
root = listTree[i];
items.Add(root);
}
else
{
root.Children.Add(listTree[i]);
}
}
this.ViewBag.Tree = items;
return(View(vModel));
}
// GET: PerformanceCard/PerformanceParameter
public ActionResult CreateParameter(int Id)
{
ParameterListViewModel Model = new ParameterListViewModel();
Model.ParameterTypeName = _parameterTypeService.ParameterTypeNameById(Id);
Model.tblParameterTypeId = Id;
return(View(Model));
}
public JsonResult ParameterSaveUpdate(ParameterListViewModel Model)
{
try
{
var data = _parameterTypeService.ParameterSaveUpdate(Model);
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Model.Message = ex.Message + " " + ex.InnerException;
return(Json(Model, JsonRequestBehavior.AllowGet));
}
}
public ActionResult List(ParameterListViewModel viewModel)
{
// Initialize
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(viewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
userMessageModeler = new UserMessageModeler(status);
return(Json(userMessageModeler, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Get stored procedure parameters.
*---------------------------------------------------------------------------------------------------------------------------------*/
ParameterListViewModel parameterListViewModel = null;
ParameterListModeler parameterListModeler = new ParameterListModeler(this.Request, this.UserSession);
status = parameterListModeler.List(viewModel, out parameterListViewModel);
if (!questStatusDef.IsSuccess(status))
{
userMessageModeler = new UserMessageModeler(status);
return(Json(userMessageModeler, JsonRequestBehavior.AllowGet));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return data.
*---------------------------------------------------------------------------------------------------------------------------------*/
status = new questStatus(Severity.Success);
parameterListViewModel.questStatus = status;
return(Json(parameterListViewModel, JsonRequestBehavior.AllowGet));
}
public ActionResult Index(ParameterListViewModel viewModel)
{
questStatus status = null;
/*----------------------------------------------------------------------------------------------------------------------------------
* Log Operation
*---------------------------------------------------------------------------------------------------------------------------------*/
status = LogOperation();
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(View("Index", viewModel));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Authorize
*---------------------------------------------------------------------------------------------------------------------------------*/
status = Authorize(viewModel._ctx);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(View("Index", viewModel));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Read the database info.
*---------------------------------------------------------------------------------------------------------------------------------*/
ParameterListViewModel parameterListViewModel = null;
ParameterListModeler parameterListModeler = new ParameterListModeler(this.Request, this.UserSession);
status = parameterListModeler.GetParamerListInfo(viewModel, out parameterListViewModel);
if (!questStatusDef.IsSuccess(status))
{
viewModel.questStatus = status;
return(View("Index", viewModel));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Return view.
*---------------------------------------------------------------------------------------------------------------------------------*/
parameterListViewModel.questStatus = new questStatus(Severity.Success);
return(View(parameterListViewModel));
}
public ParameterListViewModel ParameterSaveUpdate(ParameterListViewModel Model)
{
tblParameterList list = _context.tblParameterLists.Where(t => t.tblParameterTypeId == Model.tblParameterTypeId &&
t.Id == Model.ParameterId).FirstOrDefault();
if (list == null)
{
list = new tblParameterList();
}
list.IsActive = Model.IsActive;
list.Name = Model.Name;
list.ReviewId = Model.ReviewId > 0 ? Model.ReviewId : (int?)null;
if (Model.GenderId > 0)
{
if (Model.GenderId == 1)
{
list.Gender = "F";
}
else
{
list.Gender = "M";
}
}
else
{
list.Gender = null;
}
list.tblParameterTypeId = Model.tblParameterTypeId;
if (list.Id == 0)
{
list.KeyId = Model.KeyId;
Model.Message = "Sub-Parameter saved successfully!";
list.Id = Model.ParameterId;
_context.tblParameterLists.Add(list);
}
else
{
Model.Message = "Sub-Parameter update successfully!";
}
_context.SaveChanges();
return(Model);
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
#region LIST
//----------------------------------------------------------------------------------------------------------------------------------
// LIST
//----------------------------------------------------------------------------------------------------------------------------------
public questStatus GetParamerListInfo(ParameterListViewModel viewModel, out ParameterListViewModel parameterListViewModel)
{
// Initialize
questStatus status = null;
parameterListViewModel = null;
DatabaseId databaseId = new DatabaseId(viewModel.DatabaseId);
// Read the database
DatabaseBaseViewModel databaseBaseViewModel = null;
DatabaseBaseModeler databaseBaseModeler = new DatabaseBaseModeler(this.HttpRequestBase, this.UserSession);
status = databaseBaseModeler.GetDatabase(databaseId, out databaseBaseViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Read the stored procedure
StoredProceduresListViewModel storedProceduresListViewModel = null;
StoredProceduresListModeler storedProceduresListModeler = new StoredProceduresListModeler(this.HttpRequestBase, this.UserSession);
status = storedProceduresListModeler.List(databaseId, out storedProceduresListViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Get stored procedure info
StoredProcedureId storedProcedureId = new StoredProcedureId(viewModel.Id);
// Read the stored procedure info
StoredProcedure storedProcedure = null;
StoredProceduresMgr storedProceduresMgr = new StoredProceduresMgr(this.UserSession);
status = storedProceduresMgr.Read(storedProcedureId, out storedProcedure);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Get stored procedure parameters
viewModel.StoredProcedureId = viewModel.Id;
ParameterListViewModel _parameterListViewModel = null;
status = List(viewModel, out _parameterListViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Sort by display order
// NOTE: ORDER IN DATABASE -SHOULD- BE ORDER IN SPROC.
// Transfer model.
parameterListViewModel = new ParameterListViewModel(this.UserSession, viewModel);
parameterListViewModel.DatabaseId = databaseId.Id;
parameterListViewModel.Database = databaseBaseViewModel;
foreach (StoredProcedureLineItemViewModel storedProcedureLineItemViewModel in storedProceduresListViewModel.Items)
{
OptionValuePair opv = new OptionValuePair();
opv.Id = storedProcedureLineItemViewModel.Id.ToString();
opv.Label = storedProcedureLineItemViewModel.Name;
parameterListViewModel.StoredProcedureOptions.Add(opv);
}
parameterListViewModel.ParentEntityType = viewModel.ParentEntityType;
parameterListViewModel.StoredProcedureId = viewModel.StoredProcedureId;
StoredProcedureViewModel storedProcedureViewModel = new StoredProcedureViewModel();
BufferMgr.TransferBuffer(storedProcedure, storedProcedureViewModel);
parameterListViewModel.StoredProcedure = storedProcedureViewModel;
parameterListViewModel.Items = _parameterListViewModel.Items;
return(new questStatus(Severity.Success));
}
public ParameterListModeler(HttpRequestBase httpRequestBase, UserSession userSession, ParameterListViewModel parameterListViewModel)
: base(httpRequestBase, userSession)
{
this._parameterListViewModel = parameterListViewModel;
initialize();
}
public ActionResult UploadWaperd()
{
ParameterListViewModel vModel = new ParameterListViewModel();
return(View(vModel));
}
public ActionResult PindahCabang()
{
ParameterListViewModel vModel = new ParameterListViewModel();
return(View(vModel));
}
public ActionResult ClientCodeControl()
{
ParameterListViewModel vModel = new ParameterListViewModel();
return(View(vModel));
}
