protected void Delete_Click(object sender, EventArgs e)
{
try
{
CheckBox chk = new CheckBox();
Label lbl = new Label();
string phyid = "";
PhysicianDataTier std = new PhysicianDataTier();
if (grdStudents.Rows.Count > 0)
{
foreach (GridViewRow row in grdStudents.Rows)
{
chk = (CheckBox)row.FindControl("chkPhyID");
if (chk.Checked)
{
lbl = (Label)row.Controls[0].FindControl("hidPhyID");
phyid = lbl.Text.Trim();
std.DeletePhysician(phyid);
}
}
DataBind();
}
}
catch
{
}
}
private void DataBind()
{
PhysicianDataTier aDatatier = new PhysicianDataTier();
DataSet aDataSet = new DataSet();
aDataSet = aDatatier.ViewPhysician("", "", "");
grdStudents.DataSource = aDataSet.Tables[0];
// Cache for a while
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);
}
grdStudents.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PhysicianDataTier dataTier = new PhysicianDataTier();
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
DataSet dataSet = new DataSet();
string phyid = Request.QueryString["ID"];
dataSet = dataTier.FindByID(phyid);
if (Request.QueryString["ID"].Trim().ToUpper() == "EDIT")
{
}
else
{
//Response.Redirect("~/ViewPatients.aspx");
lblPhysicianID.Text = dataSet.Tables[0].Rows[0]["physician_id"].ToString();
txtFName.Text = dataSet.Tables[0].Rows[0]["fname"].ToString();
txtMidInit.Text = dataSet.Tables[0].Rows[0]["midint"].ToString();
txtLName.Text = dataSet.Tables[0].Rows[0]["lname"].ToString();
ddlGender.Text = dataSet.Tables[0].Rows[0]["gender"].ToString();
txtDOB.Text = dataSet.Tables[0].Rows[0]["dob"].ToString();
txtStreet.Text = dataSet.Tables[0].Rows[0]["streetname"].ToString();
txtCity.Text = dataSet.Tables[0].Rows[0]["city"].ToString();
ddlState.Text = dataSet.Tables[0].Rows[0]["doc_state"].ToString();
// Binds state to the dropdown list
ddlState.DataSource = StateManager.getStates();
ddlState.DataTextField = "FullAndAbbrev";
ddlState.DataValueField = "abbreviation";
ddlState.SelectedValue = "PA";
ddlState.DataBind();
txtZIP.Text = dataSet.Tables[0].Rows[0]["zip"].ToString();
txtOfficePhone.Text = dataSet.Tables[0].Rows[0]["office_phone"].ToString();
txtPersonalPhone.Text = dataSet.Tables[0].Rows[0]["personal_phone"].ToString();
txtEmailI.Text = dataSet.Tables[0].Rows[0]["personal_email"].ToString();
txtWorkEmail.Text = dataSet.Tables[0].Rows[0]["work_email"].ToString();
txtSpecialty.Text = dataSet.Tables[0].Rows[0]["speciality"].ToString();
txtSalary.Text = dataSet.Tables[0].Rows[0]["salary"].ToString();
}
}
}
}
private void DataBind()
{
PhysicianDataTier aDatatier = new PhysicianDataTier();
ViewState["vphyid"] = txtPhysicianID.Text.Trim();
DataSet aDataSet = new DataSet();
aDataSet = aDatatier.getphysician(Convert.ToString(ViewState["vphyid"]));
grdPhysician.DataSource = aDataSet.Tables[0];
// Cache for a while
if (Cache["CustomerData"] != null)
{
Cache.Add("PhysicianData", new DataView(aDataSet.Tables[0]),
null, System.Web.Caching.Cache.NoAbsoluteExpiration, System.TimeSpan.FromMinutes(10),
System.Web.Caching.CacheItemPriority.Default, null);
}
grdPhysician.DataBind();
}
protected void btnHidden_Click(object sender, EventArgs e)
{
string reply;
// Adds into SQL database
try
{
PhysicianDataTier.AddPhysician(txtFName.Text, txtMidInit.Text, txtLName.Text, ddlGender.Text, txtStreet.Text,
txtCity.Text, ddlState.Text, decimal.Parse(txtZIP.Text), DateTime.Parse(txtDOB.Text), txtOfficePhone.Text,
txtPersonalPhone.Text, txtEmailI.Text, txtWorkEmail.Text, txtSpecialty.Text, decimal.Parse(txtSalary.Text));
reply = "Success";
lblDisplay.Text = reply;
}
catch (Exception Ex)
{
throw new Exception(Ex.Message);
}
finally
{
}
}
