public JsonResult ShowDoctors()
{
Models.Staffs staffs = new Staffs();
DataSet dsDoctor = staffs.getDoctor();
List <Staffs> staffList = new List <Staffs>();
foreach (DataRow dr in dsDoctor.Tables[0].Rows)
{
staffList.Add(new Staffs
{
Staff_ID = Convert.ToInt32(dr["Staff_ID"]),
Staff_Name = dr["Staff_Name"].ToString(),
Staff_Spec = dr["Spec_Name"].ToString(),
Staff_Qualification = dr["Staff_Qualification"].ToString(),
Staff_DOB = dr["Staff_DOB"].ToString(),
Staff_Gender = dr["Staff_Gender"].ToString(),
Staff_BloodGroup = dr["Staff_BloodGp"].ToString(),
Staff_Email = dr["Staff_Email"].ToString(),
Staff_Contact = dr["Staff_Contact"].ToString(),
Staff_City = dr["Staff_City"].ToString(),
Staff_State = dr["Staff_State"].ToString(),
Staff_Country = dr["Staff_Country"].ToString(),
Staff_Pin = Convert.ToInt32(dr["Staff_Pin"]),
Staff_Acnt_Date = dr["Staff_Acnt_Date"].ToString(),
Active = dr["Active"].ToString()
});
}
var data = staffList;
return(Json(new { data = data }, JsonRequestBehavior.AllowGet));
}