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";
}
}
