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);
}
private void InitialiseMembers()
{
Trim = new EmptyFdpTrim();
IdentifierPrefix = "Page";
Programmes = Enumerable.Empty <Programme>();
Gateways = Enumerable.Empty <Gateway>();
CarLines = Enumerable.Empty <CarLine>();
ModelYears = Enumerable.Empty <ModelYear>();
CurrentAction = TrimAction.NotSet;
}
public FdpTrim FdpTrimGet(TrimFilter filter)
{
FdpTrim retVal = new EmptyFdpTrim();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpTrimId", filter.TrimId.GetValueOrDefault(), DbType.Int32);
retVal = conn.Query <FdpTrim>("dbo.Fdp_Trim_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
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);
}
private void InitialiseMembers()
{
Trim = new EmptyFdpTrim();
IdentifierPrefix = "Page";
Programmes = Enumerable.Empty<Programme>();
Gateways = Enumerable.Empty<Gateway>();
CarLines = Enumerable.Empty<CarLine>();
ModelYears = Enumerable.Empty<ModelYear>();
CurrentAction = TrimAction.NotSet;
}
public FdpTrim FdpTrimGet(TrimFilter filter)
{
FdpTrim retVal = new EmptyFdpTrim();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpTrimId", filter.TrimId.GetValueOrDefault(), DbType.Int32);
retVal = conn.Query<FdpTrim>("dbo.Fdp_Trim_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
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 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;
}
