/// <summary>
/// Summary View of the data from database.
/// </summary>
/// <returns></returns>
// [TypeFilter(typeof(AuthorizeAction), Arguments = new object[] {"Read"})]
public IActionResult SummaryView()
{
AssetClassViewModel model = new AssetClassViewModel();
InitAccessModel(model);
return(View(model));
}
public IActionResult AddUpdate(AssetClassViewModel model)
{
// If the model valid go ti the next level
if (ModelState.IsValid)
{
return(Json(_interface.AddUpdate(model.assetClass)));
}// Else it shows the error message.
else
{
resp.Message = Constants.ControllerMessage.All_Fields_Mandatory;
return(Json(resp));
}
}
/// <summary>
/// Get the Data based on ID and return to the model to update view.
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
// [TypeFilter(typeof(AuthorizeAction), Arguments = new object[] {"Write"})]
public IActionResult Update(int ID)
{
AssetClassViewModel model = new AssetClassViewModel();
InitAccessModel(model);
model.assetClass = _interface.GetData(ID);
if (model.assetClass != null)
{
return(View("Index", model));
}
else
{
return(RedirectToAction("DateNotFound", "Home"));
}
}
public async Task <IEnumerable <dynamic> > GetAssetClassByParams(AssetClassViewModel avm)
{
string sql = "dbo.EAppListAssetClass";
using (var conn = util.MasterCon())
{
try
{
return(await(conn.QueryAsync <dynamic>(sql, new { avm.LanguageId, avm.Status }, commandType: CommandType.StoredProcedure)));
}
catch (Exception ex)
{
throw new CustomException("Unable to Load Data, Please Contact Support!!!", "Error", true, ex);
}
}
}
public async Task <IActionResult> Search([FromBody] AssetClassViewModel avm)
{
try
{
return(Ok(await AssetClassRepo.GetAssetClassByParams(avm)));
}
catch (CustomException cex)
{
var responseObj = new EmaintenanceMessage(cex.Message, cex.Type, cex.IsException, cex.Exception?.ToString());
return(StatusCode(StatusCodes.Status500InternalServerError, responseObj));
}
catch (Exception ex)
{
return(Ok(new EmaintenanceMessage(ex.Message)));
}
}
public async Task <IActionResult> Update([FromBody] AssetClassViewModel svm)
{
try
{
return(Ok(await AssetClassRepo.SaveOrUpdate(svm)));
}
catch (CustomException cex)
{
var returnObj = new EmaintenanceMessage(cex.Message, cex.Type, cex.IsException, cex.Exception?.ToString());
return(StatusCode(StatusCodes.Status500InternalServerError, returnObj));
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError, new EmaintenanceMessage(ex.Message)));
}
}
public async Task <IActionResult> Create([FromBody] AssetClassViewModel avm)
{
try
{
CurrentUser cUser = new CurrentUser(HttpContext, _configuration);
avm.UserId = cUser.UserId;
avm.AssetClassId = 0;
avm.Active = "Y";
return(Ok(await AssetClassRepo.SaveOrUpdate(avm)));
}
catch (CustomException cex)
{
var returnObj = new EmaintenanceMessage(cex.Message, cex.Type, cex.IsException, cex.Exception?.ToString());
return(StatusCode(StatusCodes.Status500InternalServerError, returnObj));
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError, new EmaintenanceMessage(ex.Message)));
}
}
public async Task <IEnumerable <dynamic> > SaveOrUpdate([FromBody] AssetClassViewModel avm)
{
string sql = "dbo.EAppSaveAssetClass";
using (var conn = util.MasterCon())
{
try
{
return(await(conn.QueryAsync <dynamic>(sql, new
{
avm.AssetClassId,
avm.LanguageId,
avm.AssetClassCode,
avm.AssetClassName,
avm.Descriptions,
avm.Active,
avm.UserId
}, commandType: CommandType.StoredProcedure)));
}
catch (SqlException sqlException)
{
if (sqlException.Number == 2601 || sqlException.Number == 2627)
{
throw new CustomException("Duplicate", "Asset Type Code already Exists.", "Error", true, sqlException);
}
else
{
throw new CustomException("Due to some Technical Reason, Unable to Save or Update", "Error", true, sqlException);
}
}
catch (Exception ex)
{
throw new CustomException("Unable to Save Or Update, Please Contact Support!!!", "Error", true, ex);
}
}
}
