public EngineCodeMapping EngineCodeMappingSave(EngineCodeMapping mapping)
{
var retVal = mapping;
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@ProgrammeId", mapping.ProgrammeId, DbType.Int32);
para.Add("@EngineId", mapping.EngineId, DbType.Int32);
para.Add("@ExternalEngineCode",
string.IsNullOrEmpty(mapping.ExternalEngineCode) ? null : mapping.ExternalEngineCode, DbType.String);
para.Add("@MappingId", null, DbType.Int32, ParameterDirection.Output);
conn.Execute("dbo.Fdp_EngineCode_Save", para, commandType: CommandType.StoredProcedure);
if (!mapping.MappingId.HasValue)
{
mapping.MappingId = para.Get<int>("@MappingId");
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return mapping;
}
public EngineCodeMapping UpdateEngineCodeMapping(EngineCodeMapping mapping)
{
return _programmeDataStore.EngineCodeMappingSave(mapping);
}