public ActionResult Visitors()
{
List <Visitors> CategoryList = new List <Visitors>();
Property p = new Property();
DataSet ds = new DataSet();
p.OnTable = "FetchVisitors";
ds = dl.FetchVisitors_sp(p);
List <SelectListItem> Purposeinventory = new List <SelectListItem>();
Purposeinventory.Add(new SelectListItem {
Text = "Select", Value = ""
});
foreach (DataRow dr in ds.Tables[1].Rows)
{
Purposeinventory.Add(new SelectListItem {
Text = dr["PName"].ToString(), Value = dr["PId"].ToString()
});
}
ViewBag.Purposeinventory = new SelectList(Purposeinventory, "Value", "Text");
try
{
foreach (DataRow item in ds.Tables[0].Rows)
{
Visitors m = new Visitors();
m.VId = item["VId"].ToString();
m.VName = item["VName"].ToString();
m.Phone = item["Phone"].ToString();
m.Date = item["Date"].ToString();
m.IDCard = item["IDCard"].ToString();
m.InTime = item["InTime"].ToString();
m.OutTime = item["OutTime"].ToString();
m.NOP = item["NOP"].ToString();
m.PId = item["PId"].ToString();
m.PName = item["PName"].ToString();
m.Attachment = item["Attachment"].ToString();
m.AddedBy = item["AddedBy"].ToString();
m.Note = item["Note"].ToString();
m.IsActive = item["IsActive"].ToString();
CategoryList.Add(m);
}
ViewBag.CategoryList = CategoryList;
}
catch (Exception e)
{
}
return(View());
}