private void PopulateProfile(int id) { var oDAL = new PhysicianDAL(); var oClass = new PhysicianModel(); var oDs = new DataSet(); oClass.UserID = id; oDs = oDAL.SelectByUserID(oClass); var fullname = oDs.Tables[0].Rows[0][3].ToString() + " " + oDs.Tables[0].Rows[0][2].ToString() + ", " + oDs.Tables[0].Rows[0][4].ToString(); UserFullName.Text = fullname; UserFullNameMain.Text = fullname; UserFullNameSide.Text = fullname; UserSpecialty.Text = oDs.Tables[0].Rows[0][5].ToString(); PhysicianID.Value = oDs.Tables[0].Rows[0][0].ToString(); //PhysicianID.Value = oDs.Tables[0].Rows[0][0].ToString(); //LastName.Value = oDs.Tables[0].Rows[0][1].ToString(); //FirstName.Value = oDs.Tables[0].Rows[0][2].ToString(); //Specialty.Value = oDs.Tables[0].Rows[0][3].ToString(); //txtAddress.Value = oDs.Tables[0].Rows[0][5].ToString(); //txtEmail.Value = oDs.Tables[0].Rows[0][6].ToString(); //txtContact.Value = oDs.Tables[0].Rows[0][7].ToString(); }
private void LoadPhyscianData(int id) { PhysicianDAL physicianDAL = new PhysicianDAL(); PhysicianModel physicianClass = new PhysicianModel(); oDs = new DataSet(); physicianClass.ID = id; oDs = physicianDAL.SelectByID(physicianClass); //PhysicianID.Value = oDs.Tables[0].Rows[0][0].ToString(); LastName.Value = oDs.Tables[0].Rows[0]["LastName"].ToString(); FirstName.Value = oDs.Tables[0].Rows[0]["FirstName"].ToString(); // Specialty.Value = oDs.Tables[0].Rows[0][3].ToString(); // ddlHospitalName.SelectedValue = oDs.Tables[0].Rows[0][4].ToString(); txtAddress.Value = oDs.Tables[0].Rows[0]["address"].ToString(); txtEmail.Value = oDs.Tables[0].Rows[0]["email"].ToString(); txtContact.Value = oDs.Tables[0].Rows[0]["phone"].ToString(); if (oDs.Tables[0].Rows[0]["UserID"].ToString() != "") { var userid = oDs.Tables[0].Rows[0]["UserID"].ToString(); PopulateData(Convert.ToInt16(userid)); } }
private void LoadPhysician() { PhysicianDAL physician = new PhysicianDAL(); ddlPhysician.DataSource = physician.SelectAllCombo(); ddlPhysician.DataTextField = "Fullname"; ddlPhysician.DataValueField = "id"; ddlPhysician.DataBind(); }
private void PopulatePhysicianFacility(int id) { oDAL = new PhysicianDAL(); oClass = new PhysicianModel(); oClass.ID = id; gvFacility.DataSource = oDAL.SelectPhysicianFacilityByID(oClass); gvFacility.DataBind(); }
private double GetRate() { double result = 0; PhysicianDAL physician = new PhysicianDAL(); PhysicianModel physicianModel = new PhysicianModel(); DataSet physicianData = new DataSet(); physicianModel.ID = Convert.ToInt16(ddlPhysician.SelectedValue); physicianData = physician.SelectByID(physicianModel); result = Convert.ToDouble(physicianData.Tables[0].Rows[0]["Rate"]); return(result); }
private void SaveData() { string sUserName = Session["User"].ToString(); oDAL = new PhysicianDAL(); oClass = new PhysicianModel(); oClass.LastName = LastName.Value; oClass.FirstName = FirstName.Value; oClass.Specialty = Specialty.Value; // oClass.HospitalID = Convert.ToInt32(ddlHospitalName.SelectedValue); oClass.Address = txtAddress.InnerText; oClass.Phone = txtContact.Value; oClass.Email = txtEmail.Value; oClass.ID = Convert.ToInt16(PhysicianID.Value); oDAL.UpdateData(sUserName, oClass); }
private void PopulateData(int id) { oDAL = new PhysicianDAL(); oClass = new PhysicianModel(); oDs = new DataSet(); oClass.UserID = id; oDs = oDAL.SelectByUserID(oClass); PhysicianID.Value = oDs.Tables[0].Rows[0][0].ToString(); LastName.Value = oDs.Tables[0].Rows[0][1].ToString(); FirstName.Value = oDs.Tables[0].Rows[0][2].ToString(); Specialty.Value = oDs.Tables[0].Rows[0][3].ToString(); // ddlHospitalName.SelectedValue = oDs.Tables[0].Rows[0][4].ToString(); txtAddress.Value = oDs.Tables[0].Rows[0][5].ToString(); txtEmail.Value = oDs.Tables[0].Rows[0][6].ToString(); txtContact.Value = oDs.Tables[0].Rows[0][7].ToString(); }
protected void Ok_ServerClick(object sender, EventArgs e) { string UserName = Session["User"].ToString(); int ID = Convert.ToInt32(HiddenFieldPatient.Value); oDAL = new PhysicianDAL(); oClass = new PhysicianModel(); oDs = new DataSet(); oClass.IsDeleted = true; oClass.ReasonDelete = itemname.InnerText; string lbl = lblSelectedItem.Text; oClass.ID = ID; oDAL.DeleteData(UserName, oClass); PopulateGrid(); }
private void SaveData() { string sUserName = Session["User"].ToString(); oDAL = new PhysicianDAL(); oClass = new PhysicianModel(); oClass.Title = "Dr"; oClass.LastName = LastName.Value; oClass.FirstName = FirstName.Value; oClass.Suffix = Suffix.Value; oClass.Specialty = Specialty.Value; oClass.LicenseNo = LicenseNo.Value; oClass.Address = txtAddress.InnerText; oClass.Phone = txtContact.Value; oClass.Email = txtEmail.Value; oClass.ID = Convert.ToInt16(PhysicianID.Value); oDAL.UpdateData(sUserName, oClass); }
private void PopulateGrid() { oDAL = new PhysicianDAL(); oDs = new DataSet(); if (searchKeyword.Value != "") { oDs = oDAL.SeachData(searchKeyword.Value); } else { oDs = oDAL.SelectAll(); } if (oDs != null) { gvList.DataSource = oDs.Tables[0]; gvList.DataBind(); } }
private void PopulateData(int id) { oDAL = new PhysicianDAL(); oClass = new PhysicianModel(); oDs = new DataSet(); oClass.ID = id; oDs = oDAL.SelectByID(oClass); PhysicianID.Value = oDs.Tables[0].Rows[0][0].ToString(); NameTitle.Value = oDs.Tables[0].Rows[0][1].ToString(); LastName.Value = oDs.Tables[0].Rows[0][2].ToString(); FirstName.Value = oDs.Tables[0].Rows[0][3].ToString(); SuffixName.Value = oDs.Tables[0].Rows[0][4].ToString(); PhysicianSpecialty.Value = oDs.Tables[0].Rows[0][5].ToString(); LicenseNo.Value = oDs.Tables[0].Rows[0][7].ToString(); // ddlHospitalName.SelectedValue = oDs.Tables[0].Rows[0][4].ToString(); txtAddress.Value = oDs.Tables[0].Rows[0][9].ToString(); txtEmail.Value = oDs.Tables[0].Rows[0][8].ToString(); txtContact.Value = oDs.Tables[0].Rows[0][10].ToString(); txtRate.Value = oDs.Tables[0].Rows[0][12].ToString(); }
private void SaveData() { string sUserName = Session["User"].ToString(); oDAL = new PhysicianDAL(); oClass = new PhysicianModel(); oClass.Title = NameTitle.Value; oClass.LastName = LastName.Value; oClass.FirstName = FirstName.Value; oClass.Suffix = SuffixName.Value; oClass.Specialty = PhysicianSpecialty.Value; oClass.LicenseNo = LicenseNo.Value; // oClass.HospitalID = Convert.ToInt32(ddlHospitalName.SelectedValue); oClass.Address = txtAddress.InnerText; oClass.Phone = txtContact.Value; oClass.Email = txtEmail.Value; if (txtRate.Value == "") { txtRate.Value = "0"; } oClass.Rate = Convert.ToDouble(txtRate.Value); string id = PhysicianID.Value; if (id == "") { oDAL.InsertData(sUserName, oClass); //lblMsg.Text = "New Record has been saved"; } else { oClass.ID = Convert.ToInt16(id); oDAL.UpdateData(sUserName, oClass); // lblMsg.Text = "Record has been updated"; } }