public FdpSpecialFeature FdpSpecialFeatureSave(FdpSpecialFeature specialFeature)
{
FdpSpecialFeature retVal = new EmptyFdpSpecialFeature();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@FeatureCode", specialFeature.FeatureCode, DbType.String);
para.Add("@FdpSpecialFeatureTypeId", specialFeature.Type.FdpSpecialFeatureTypeId, DbType.Int32);
para.Add("@DocumentId", specialFeature.DocumentId, DbType.Int32);
retVal = conn.Query<FdpSpecialFeature>("dbo.Fdp_SpecialFeatureMapping_Save", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpSpecialFeature FdpSpecialFeatureGet(int fdpFeatureId)
{
FdpSpecialFeature retVal = new EmptyFdpSpecialFeature();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpSpecialFeatureId", fdpFeatureId, DbType.Int32);
retVal = conn.Query<FdpSpecialFeature>("dbo.Fdp_SpecialFeatureMapping_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}