public IList <WebUrlModelFireFighters> TimelineviewFirstfighters()
{
List <WebUrlModelFireFighters> FireFightertable = new List <WebUrlModelFireFighters>();
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("WebUrlDataFetch", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Pool", "FireFighters");
SqlDataReader read = cmd.ExecuteReader();
while (read.Read())
{
WebUrlModelFireFighters rowFightersFromDB = new WebUrlModelFireFighters();
rowFightersFromDB.FFsno = Convert.ToInt32(read[0].ToString());
rowFightersFromDB.FFname = read[2].ToString();
rowFightersFromDB.FFdepartment = read[3].ToString();
rowFightersFromDB.FFpunchcount = read[5].ToString();
FireFightertable.Add(rowFightersFromDB);
}
read.Close();
conn.Close();
}
catch (Exception e1)
{
throw;
}
return(FireFightertable);
}
public ActionResult WebUrlView()
{
try
{
WebUrlModelFireFighters masterTableData = new WebUrlModelFireFighters();
masterTableData.WUVTabledatafromdbFireFighters = this.TimelineviewFirstfighters();
masterTableData.WUVTabledatafromdbFireAiders = this.TimelineviewFirstaiders();
return(View(masterTableData));
}
catch (Exception)
{
return(RedirectToAction("WebUrlView", "WebUrlView"));
}
}
