public OTRegistration GetMultipleNurse() { SisterMaster obj = new SisterMaster(); 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_SisterRegistration", xml); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { nurse.Add(new SelectListItem { Text = ds.Tables[0].Rows[i]["fname"].ToString() + " " + ds.Tables[0].Rows[i]["lname"].ToString(), Value = ds.Tables[0].Rows[i]["sisterid"].ToString() }); } return(this); }
public List <SisterMaster> GetAllSister() { 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_SisterRegistration", xml); List <SisterMaster> Sisterlist = new List <SisterMaster>(); if (ds != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { SisterMaster om = new SisterMaster(); om.sisterid = Convert.ToInt32(ds.Tables[0].Rows[i]["sisterid"].ToString()); om.fname = ds.Tables[0].Rows[i]["fname"].ToString(); om.lname = ds.Tables[0].Rows[i]["lname"].ToString(); Sisterlist.Add(om); } } return(Sisterlist); }