public CriteriaModel UpdateCriteria(CriteriaModel data)
{
using (var connection = GetSqlConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand("Community.spCriteriaCount", connection))
{
command.Parameters.AddWithValue("@Zipcode", '1');
command.Parameters.AddWithValue("@AgeMax", data.maxAge);
command.Parameters.AddWithValue("@AgeMin", data.minAge);
command.Parameters.AddWithValue("@Gender", data.gender);
command.Parameters.AddWithValue("@IncomeMax", data.maxIncome);
command.Parameters.AddWithValue("@IncomeMin", data.minIncome);
command.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader = command.ExecuteReader())
{
if(reader.Read())
{
string counts = reader.FieldToString("Counts");
data.Counts = counts;
}
}
}
}
return data;
}
public List<CriteriaModel> GetCriteriaList()
{
var queryResult = new List<CriteriaModel>();
using (var connection = GetSqlConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand("Community.spCriteriaList", connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
string zipcode = reader.FieldToString("zipcode");
var item = new CriteriaModel()
{
zipcode = zipcode,
};
queryResult.Add(item);
}
}
}
}
return queryResult;
}
public ActionResult Index(CriteriaModel criteria)
{
DataProvider dataprovider = new DataProvider();
var updatedcriteria = dataprovider.UpdateCriteria(criteria);
return View(updatedcriteria);
}
public ActionResult Index()
{
var dataProvider = new DataProvider();
var criteria = dataProvider.GetCriteriaList();
DataProvider dp = new DataProvider();
List<SelectListItem> listSelectListItem = new List<SelectListItem>();
foreach (var zips in criteria)
{
SelectListItem selectListItem = new SelectListItem()
{
Text = zips.zipcode.ToString(),
};
listSelectListItem.Add(selectListItem);
}
CriteriaModel criteriaViewModel = new CriteriaModel();
criteriaViewModel.Zips = listSelectListItem;
return View(criteriaViewModel);
}
