public FdpTrim FdpTrimSave(FdpTrim trim)
{
FdpTrim retVal = new EmptyFdpTrim();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@ProgrammeId", trim.ProgrammeId, DbType.Int32);
para.Add("@Gateway", trim.Gateway, DbType.String);
para.Add("@DerivativeCode", trim.BMC, DbType.String);
para.Add("@TrimName", trim.Name, DbType.String);
para.Add("@TrimAbbreviation", trim.Abbreviation, DbType.String);
para.Add("@TrimLevel", trim.Level, DbType.String);
para.Add("@DPCK", trim.DPCK, DbType.String);
retVal = conn.Query <FdpTrim>("dbo.Fdp_Trim_Save", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public async Task <ActionResult> Delete(TrimParameters parameters)
{
var derivativeView = await GetModelFromParameters(parameters);
if (derivativeView.Trim is EmptyFdpTrim)
{
return(JsonGetFailure(string.Format("Trim does not exist", parameters.TrimId)));
}
derivativeView.Trim = await DataContext.Vehicle.DeleteFdpTrim(FdpTrim.FromParameters(parameters));
if (derivativeView.Trim is EmptyFdpTrim)
{
return(JsonGetFailure(string.Format("Trim '{0}' could not be deleted", derivativeView.Trim.Name)));
}
return(JsonGetSuccess());
}
public FdpTrim FdpTrimDelete(FdpTrim trimToDelete)
{
FdpTrim retVal = new EmptyFdpTrim();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@FdpTrimId", trimToDelete.FdpTrimId.GetValueOrDefault(), DbType.Int32);
retVal = conn.Query <FdpTrim>("dbo.Fdp_Trim_Delete", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public async Task <ActionResult> AddMissingTrim(ImportExceptionParameters parameters)
{
var filter = ImportQueueFilter.FromExceptionId(parameters.ExceptionId.Value);
var importView = await GetModelFromParameters(parameters);
var trim = new FdpTrim()
{
ProgrammeId = parameters.ProgrammeId.GetValueOrDefault(),
Gateway = parameters.Gateway,
Name = parameters.TrimName,
Abbreviation = parameters.TrimAbbreviation,
Level = parameters.TrimLevel,
DPCK = parameters.DPCK,
BMC = parameters.DerivativeCode
};
importView.CurrentException = await DataContext.Import.AddTrim(filter, trim);
await DeactivateException(importView.CurrentException);
await ReProcessException(importView.CurrentException);
return(Json(JsonActionResult.GetSuccess(), JsonRequestBehavior.AllowGet));
}
// Trim and mappings
public async Task <FdpTrim> DeleteFdpTrim(FdpTrim trimToDelete)
{
return(await Task.FromResult(_trimDataStore.FdpTrimDelete(trimToDelete)));
}
public async Task <ImportError> AddTrim(ImportQueueFilter filter, FdpTrim trimToAdd)
{
var task = await Task.FromResult(_trimDataStore.FdpTrimSave(trimToAdd));
return(await Task.FromResult(_importDataStore.ImportErrorGet(filter)));
}
