public static List <PostalLocation> FindAllPostalLocation()
{
var result = new List <PostalLocation>();
var connection = new System.Data.SqlClient.SqlConnection(_connectionString);
connection.Open();
var command = new System.Data.SqlClient.SqlCommand("", connection);
command.CommandText = @"
Select * from [PostalLocation]";
var reader = command.ExecuteReader();
while (reader.Read())
{
PostalLocation item = new PostalLocation();
//item.ID = reader["ID"].ToString();
item.PostalCode = (UInt16)Convert.ToInt16(reader["PostalCode"]);
item.Section = reader["Section"].ToString();
item.Longitude = (float)Convert.ToDouble(reader["Longitude"]);
item.Latitude = (float)Convert.ToDouble(reader["Latitude"]);
result.Add(item);
}
connection.Close();
return(result);
}
// GET: Postal
public ActionResult Index(string search = "", int PostalCode = -1)
{
var postallocations = RV.Databases.PostalLocationDatabase.FindAllPostalLocation();
var postals = RV.Databases.PostalDatabase.FindAllPostals();
if (postallocations.Count == 0)
{
postallocations = PostalData.GetPostalLocation();
RV.Databases.PostalLocationDatabase.Create(postallocations);
}
if (postals.Count == 0)
{
postals = PostalData.GetPostal();
RV.Databases.PostalDatabase.Create(postals);
}
if (!string.IsNullOrEmpty(search))
{
postals = postals
.Where(x =>
x.PostalCode.ToString().Contains(search) ||
x.Section.Contains(search))
.ToList();
}
ViewBag.Search = search;
if (PostalCode != -1)
{
foreach (var postallocation in postallocations)
{
if (postallocation.PostalCode == PostalCode)
{
PostalController.postallocation = postallocation;
}
}
foreach (var postal in postals)
{
if (postal.PostalCode == PostalCode)
{
PostalController.postal = postal;
}
}
}
//ViewBag.Stations = stations;
return(View(postals));
}
