public OTRegistration GetMultipleDoctor()
{
DoctorMaster obj = new DoctorMaster();
obj.CMD = "View";
obj.hid = Convert.ToInt32(HttpContext.Current.Session["hospital"].ToString());
string xml = Common.ToXML(obj);
DBConnection con = new DBConnection();
DataSet ds = con.ExecuteProcedure("SP_DoctorRegistration", xml);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
doctor.Add(new SelectListItem {
Text = ds.Tables[0].Rows[i]["fname"].ToString() + " " + ds.Tables[0].Rows[i]["lname"].ToString(), Value = ds.Tables[0].Rows[i]["fname"].ToString() + " " + ds.Tables[0].Rows[i]["lname"].ToString()
});
}
return(this);
}
public List <DoctorMaster> GetAllDoctor()
{
this.CMD = "View";
this.hid = Convert.ToInt32(HttpContext.Current.Session["hospital"].ToString());
string xml = Common.ToXML(this);
DBConnection con = new DBConnection();
DataSet ds = con.ExecuteProcedure("SP_DoctorRegistration", xml);
List <DoctorMaster> Doctorlist = new List <DoctorMaster>();
if (ds != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DoctorMaster om = new DoctorMaster();
om.doctorid = Convert.ToInt32(ds.Tables[0].Rows[i]["doctorid"].ToString());
om.fname = ds.Tables[0].Rows[i]["fname"].ToString();
om.lname = ds.Tables[0].Rows[i]["lname"].ToString();
Doctorlist.Add(om);
}
}
return(Doctorlist);
}