public void UpdateSubStateRegionForReport(SubStateRegionForReport subStateRegionForReport)
{
if (subStateRegionForReport == null)
{
throw new ArgumentNullException("subStateRegionForReport");
}
if (subStateRegionForReport.ServiceAreas == null || subStateRegionForReport.ServiceAreas.Count == 0)
{
throw new ArgumentNullException("subStateRegionForReport",
"At least one location is required to create a subStateRegionForReport.");
}
using (var command = database.GetStoredProcCommand("dbo.UpdateSubStateRegionForReport"))
{
database.AddInParameter(command, "@SubStateRegionID", DbType.String, subStateRegionForReport.ID);
database.AddInParameter(command, "@StateFIPS", DbType.String, subStateRegionForReport.State.Code);
database.AddInParameter(command, "@SubStateRegionName", DbType.String, subStateRegionForReport.SubStateRegionName);
database.AddInParameter(command, "@SubStateRegionServiceEntityCode", DbType.String, subStateRegionForReport.SubStateRegionServiceEntityCode);
database.AddInParameter(command, "@SubStateRegionType", DbType.Int16, (int)subStateRegionForReport.Type);
database.AddInParameter(command, "@CreatedBy", DbType.Int32, subStateRegionForReport.CreatedBy);
database.AddInParameter(command, "@FormType", DbType.Int32, (int)subStateRegionForReport.ReprotFormType);
database.AddInParameter(command, SP.CreateAgency.ServiceAreas, DbType.String, string.Join(",", (from p in subStateRegionForReport.ServiceAreas select p.ZIPFIPSCountyCode).ToArray()));
database.ExecuteNonQuery(command);
}
}
public SubStateRegionForReport GetSubStateRegionForReport(int id)
{
SubStateRegionForReport subStateRegionForReport = null;
using (var command = database.GetStoredProcCommand("dbo.GetSubStateRegionForReport"))
{
database.AddInParameter(command, "@SubStateRegionID", DbType.Int32, id);
using (var reader = database.ExecuteReader(command))
{
if (reader.Read())
{
subStateRegionForReport = new SubStateRegionForReport
{
ID = reader.GetDefaultIfDBNull("SubStateRegionID", GetNullableInt32, null),
SubStateRegionName = reader.GetDefaultIfDBNull("SubStateRegionName", GetString, null),
SubStateRegionServiceEntityCode = reader.GetDefaultIfDBNull("SubStateRegionServiceEntityCode", GetString, null),
ReprotFormType = (FormType)reader.GetDefaultIfDBNull("FormType", GetNullableInt16, null),
Type = (SubStateReportType)reader.GetDefaultIfDBNull("SubStateRegionType", GetNullableInt16, null),
State = new State(reader.GetDefaultIfDBNull("StateFIPSCode", GetString, null)),
ServiceAreas = new List <SubStateRegionZIPFIPSForReport>()
};
reader.NextResult();
while (reader.Read())
{
subStateRegionForReport.ServiceAreas.Add(
new SubStateRegionZIPFIPSForReport
{
ZIPFIPSCountyCode = reader.GetDefaultIfDBNull("ZIPFIPSCountyCode", GetString, null),
Name = reader.GetDefaultIfDBNull("Name", GetString, null),
CreatedDate = reader.GetDefaultIfDBNull(T.County.CreatedDate, GetNullableDateTime, null)
});
}
reader.NextResult();
}
}
}
return(subStateRegionForReport);
}
