protected void btnSave_Click(object sender, EventArgs e)
{
try {
PhysicianDataTier patDT = new PhysicianDataTier();
DataSet ds = new DataSet();
string phy_ID = txtPhyID.Text;
string fname = txtFName.Text;
string lname = txtLName.Text;
//decimal salary = decimal.Parse(txtSalary.Text);
string gender = ddlGender.SelectedValue.ToString();
string phy_state = ddlState.SelectedValue.ToString();
string phy_address = txtAddress.Text;
string city = txtCity.Text;
string zip = textZipCode.Text;
string phone = textPhone.Text;
string email = textEmail.Text;
string office = textOffice.Text;
patDT.addPhysician(phy_ID, fname, lname, gender, phy_state, phy_address, city, zip, phone, email, office);
lblComplete.Text = "Physician Added!";
}
catch (Exception ex) {
lblException.Text = ex.Message.ToString();
}
}
public void Delete_Click(object sender, CommandEventArgs e)
{
try
{
CheckBox chk = new CheckBox();
Label lbl = new Label();
string phyID = "";
PhysicianDataTier ptd = new PhysicianDataTier();
Cache.Remove("StudentData");
if (grdStudent.Rows.Count > 0)
{
foreach (GridViewRow row in grdStudent.Rows)
{
chk = (CheckBox)row.FindControl("chkStudentID");
if (chk.Checked)
{
lbl = (Label)row.Controls[0].FindControl("hidStudentID");
phyID = lbl.Text.Trim();
ptd.deletePhysicians(phyID);
}
}
BindData();
}
}
catch (Exception ex)
{
lblException.Text = ex.Message.ToString();
}
}
protected void btnClose_Click(object sender, EventArgs e)
{
PhysicianDataTier patDT = new PhysicianDataTier();
DataSet ds = new DataSet();
string phy_ID = txtPhyID.Text;
string fname = txtFName.Text;
string lname = txtLName.Text;
//decimal salary = decimal.Parse(txtSalary.Text);
string gender = ddlGender.Text;
string phy_state = ddlState.Text;
string phy_address = txtAddress.Text;
string city = txtCity.Text;
string zip = textZipCode.Text;
string phone = textPhone.Text;
string email = textEmail.Text;
string office = textOffice.Text;
try
{
if (btnClose.Text.ToUpper() == "REFRESH")
{
GetPhysician(phy_ID.Trim(), Request.QueryString["type"].Trim().ToUpper());
//patDT.SHOWALLBYPHYID(phy_ID); //add patient with args
//Session["GRIDREFRESH"] = "REFRESHDGRID";
//System.Text.StringBuilder cb = new System.Text.StringBuilder();
//cb.Append(" opener.location.href = 'PhysicianTable.aspx';");
//cb.Append("var ie7 = (document.all && !window.opera && window.XMLHttpRequest) ? true : false;");
//cb.Append(" if (ie7)");
//cb.Append(" { ");
//cb.Append("window.open('','_parent','');");
//cb.Append("window.close();");
//cb.Append(" } ");
//cb.Append(" else ");
//cb.Append(" { ");
//cb.Append(" this.focus();");
//cb.Append(" self.opener = this;");
//cb.Append(" self.close();");
//cb.Append(" } ");
//ClientScript.RegisterClientScriptBlock(this.GetType(), "CloseReloadScript", cb.ToString(), true);
}
else //if (btnClose.Text.ToUpper() == "CLOSE")
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "closeform", "CloseMe()", true);
}
}
catch (Exception ex)
{
lblException.Text = ex.Message.ToString();
}
}
private void BindData()
{
PhysicianDataTier aDatatier = new PhysicianDataTier();
string phyID = Convert.ToString(Session["vPhyID"]);
string fname = Convert.ToString(Session["vFName"]);
string lname = Convert.ToString(Session["vLName"]);
txtPhysicianID.Text = phyID;
txtFName.Text = fname;
txtLName.Text = lname;
if ((phyID.Length > 0) || (fname.Length > 0) || (lname.Length > 0))
{
DataSet aDataset = new DataSet();
aDataset = aDatatier.GetAllPhysicians(phyID, fname, lname);
if (aDataset.Tables[0].Rows.Count > 0)
{
grdStudent.Visible = true;
grdStudent.DataSource = aDataset.Tables[0];
if (Cache["StudentData"] == null)
{
Cache.Add("StudentData", new DataView(aDataset.Tables[0]), null, System.Web.Caching.Cache.NoAbsoluteExpiration,
System.TimeSpan.FromMinutes(10), System.Web.Caching.CacheItemPriority.Default, null);
grdStudent.DataBind();
}
}
else
{
grdStudent.Visible = false;
}
}
else
{
grdStudent.Visible = false;
}
}
public void GetPhysician(string phy_ID, string type)
{
PhysicianDataTier phyDT = new PhysicianDataTier();
DataSet ds = new DataSet();
string gender;
//Home record = new Home();
//DataSet recordTBE = new DataSet();
//string recordToBeEdited = recordToBeEdited;
//record.decryptQueryString(recordToBeEdited.ToString());
ds = phyDT.SHOWALLBYPHYID(phy_ID);
if (ds.Tables[0].Rows.Count > 0)
{
txtPhyID.Text = ds.Tables[0].Rows[0]["phy_ID"].ToString();
txtFName.Text = ds.Tables[0].Rows[0]["fname"].ToString();
txtLName.Text = ds.Tables[0].Rows[0]["lname"].ToString();
//txtSalary.Text = ds.Tables[0].Rows[0]["salary"].ToString();
txtAddress.Text = ds.Tables[0].Rows[0]["phy_address"].ToString();
txtCity.Text = ds.Tables[0].Rows[0]["city"].ToString();
textZipCode.Text = ds.Tables[0].Rows[0]["zip"].ToString();
textOffice.Text = ds.Tables[0].Rows[0]["office_name"].ToString();
textEmail.Text = ds.Tables[0].Rows[0]["email"].ToString();
textPhone.Text = ds.Tables[0].Rows[0]["phone"].ToString();
gender = ds.Tables[0].Rows[0]["gender"].ToString().Trim();
if (gender.ToUpper() == "FEMALE")
{
ddlGender.SelectedItem.Text = "Female";
}
else
{
ddlGender.SelectedItem.Text = "Male";
}
//ddlGender.Enabled = false;
ddlState.DataSource = StateManager.getStates();
ddlState.DataTextField = "FullAndAbbrev";
ddlState.DataValueField = "Abbreviation";
ddlState.SelectedValue = "PA";
ddlState.DataBind();
ddlState.SelectedValue = ds.Tables[0].Rows[0]["phy_state"].ToString();
if (type.ToUpper() == "VIEW")
{
txtPhyID.Enabled = false;
txtFName.Enabled = false;
txtLName.Enabled = false;
txtAddress.Enabled = false;
txtCity.Enabled = false;
textEmail.Enabled = false;
textOffice.Enabled = false;
textPhone.Enabled = false;
textZipCode.Enabled = false;
//txtSalary.Enabled = false;
ddlGender.Enabled = false;
ddlState.Enabled = false;
btnSave.Visible = false;
btnClose.Visible = false;
}
else if (type.ToUpper() == "EDIT")
{
txtPhyID.Enabled = false;
txtFName.Enabled = true;
txtLName.Enabled = true;
txtAddress.Enabled = true;
txtCity.Enabled = true;
// txtSalary.Enabled = true;
ddlGender.Enabled = false;
ddlState.Enabled = true;
btnSave.Visible = true;
btnClose.Visible = true;
btnSave.Text = "UPDATE";
btnClose.Text = "REFRESH";
btnSave.ForeColor = Color.Red;
btnClose.ForeColor = Color.Blue;
}
}
}