protected void testresultssubmit_Click(object sender, EventArgs e)
{
BALAccounts Bal = new BALAccounts();
TestResultdetails testresultdetails = new TestResultdetails
{
PatientId1 = int.Parse(ddlpatient.SelectedItem.Value),
Doctorid = int.Parse(ddldoctor.SelectedItem.Value),
MedicareService = int.Parse(ddlmedicareservices.SelectedItem.Value),
AgentId = int.Parse(ddlagent.SelectedItem.Value),
Servicedate = txtservicedate.Text,
Testresultdate = txttestresultdate.Text,
Diag1_normal_value = txtdiag1_normal_value.Text,
Diag1_actual_value = txtdiag1_actual_value.Text,
Diag2_normal_value = txtdiag2_normal_value.Text,
Diag2_actual_value = txtdiag2_actual_value.Text,
Diag3_normal_value = txtdiag3_normal_value.Text,
Diag3_actual_value = txtdiag3_actual_value.Text,
Diag4_normal_value = txtdiag4_normal_value.Text,
Diag4_actual_value = txtdiag4_actual_value.Text,
Diag5_normal_value = txtdiag5_normal_value.Text,
Diag5_actual_value = txtdiag5_actual_value.Text,
Diag6_normal_value = txtdiag6_normal_value.Text,
Diag6_actual_value = txtdiag6_actual_value.Text,
Doctor_comments = txtDoctorComments.Text,
Otherinfo = txtOtherInformation.Text
};
Bal.addtestresults(testresultdetails);
}
protected void Button1_Click(object sender, EventArgs e)
{
BALAccounts Bal = new BALAccounts();
PatientDetails patientDetails = new PatientDetails
{
FirstName1 = txtPatientFname.Text,
LastName1 = txtPatientLname.Text,
Age1 = int.Parse(txtPatientAge.Text),
Gender1 = ddlPatientGender.Text,
DoB1 = txtPatientdob.Text,
ContactNumber1 = double.Parse(txtPatientcntct.Text),
AltContactNumber1 = double.Parse(txtPatientAltcntct.Text),
EmailId1 = txtPatientEmail.Text,
UserName1 = txtPatientUserName.Text,
Password1 = txtPatientPasswd.Text,
AddressLine11 = txtPatientAddress.Text,
AddressLine21 = txtPatientAltAddress.Text,
City1 = txtPatientcity.Text,
State1 = txtPatientstate.Text,
Zipcode1 = int.Parse(txtPatientzip.Text),
Isapproved1 = false
};
if (Bal.regpatientdetails(patientDetails))
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "regalert();", true);
}
}
protected void btnAdminSubmit_Click(object sender, EventArgs e)
{
try
{
BALAccounts Bal = new BALAccounts();
List <AdminDetails> adminDetail = Bal.displayadmindetails();
AdminDetails adminDetails = new AdminDetails
{
FirstName1 = txtAdminFname.Text,
LastName1 = txtAdminLname.Text,
Age1 = int.Parse(txtAge.Text),
Gender1 = ddlAdminGender.Text,
DoB1 = txtdob.Text,
ContactNumber1 = double.Parse(txtcntct.Text),
AltContactNumber1 = double.Parse(txtAltcntct.Text),
EmailId1 = txtEmail.Text,
UserName1 = txtAdminUserName.Text,
Password1 = txtPasswd.Text,
Isapproved1 = false
};
if (Bal.regadmin(adminDetails))
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "regalert();", true);
}
}
catch (Exception ex)
{
}
}
public void GetMedicareServices()
{
BALAccounts Bal = new BALAccounts();
List <MedicareServices> medicareservices = Bal.displaymedicareservices();
Mservice.DataSource = medicareservices;
Mservice.DataBind();
}
protected void btnServiceupdate_Click(object sender, EventArgs e)
{
BALAccounts Bal = new BALAccounts();
MedicareServices medicareservices = new MedicareServices
{
MedicareServicesId1 = int.Parse(Request.QueryString["medicareservicesid"].ToString()),
Medicare_service1 = txtMS.Text,
Service_Description1 = txtMSDescription.Text,
Amount1 = int.Parse(txtAmount.Text)
};
Bal.modifymedicareservices(medicareservices);
}
public void GetMedicareServices()
{
BALAccounts Bal = new BALAccounts();
List <MedicareServices> medicareservices = Bal.displaymedicareservices();
MserviceDetails.DataSource = medicareservices;
MserviceDetails.DataBind();
if (medicareservices.Count == 0)
{
lblStatus.Text = "Services not available";
}
else
{
headStatusservices.Text = "Medicare Services";
}
}
public void GetAgent()
{
BALAccounts Bal = new BALAccounts();
List <AgentDetails> agentDetails = Bal.displayagentdetails();
gdvAgentDetails.DataSource = agentDetails;
gdvAgentDetails.DataBind();
if (agentDetails.Count == 0)
{
lblStatusAgent.Text = " No Agent Details To Display";
}
else
{
headStatus.Text = "Agent Details";
}
}
public void GetDoctor()
{
BALAccounts Bal = new BALAccounts();
List <DoctorDetails> doctorDetails = Bal.displaydoctordetails();
gdvDoctorDetails.DataSource = doctorDetails;
gdvDoctorDetails.DataBind();
if (doctorDetails.Count == 0)
{
lblStatus.Text = " No Doctor Details To Display";
}
else
{
headStatusdoctor.Text = "Doctor Details";
}
}
public void GetTestResults()
{
BALAccounts Bal = new BALAccounts();
List <TestResultdetails> testresults = Bal.displaytestresults();
gdvTestresults.DataSource = testresults;
gdvTestresults.DataBind();
if (testresults.Count == 0)
{
lblStatusAgent.Text = " No Test Results To Display";
}
else
{
headStatus.Text = "Test Results";
}
}
protected void btnServiceSubmit_Click(object sender, EventArgs e)
{
BALAccounts Bal = new BALAccounts();
MedicareServicesSql medicareServicesSql = new MedicareServicesSql();
MedicareServices mediServices = new MedicareServices
{
Medicare_service1 = txtMS.Text,
Service_Description1 = txtMSDescription.Text,
Amount1 = int.Parse(txtAmount.Text)
};
Bal.addmedicareservices(mediServices);
lblerror.Text = "Added Successfully";
txtMS.Text = "";
txtMSDescription.Text = "";
txtAmount.Text = "";
}
public void GetPatient()
{
BALAccounts balAccounts = new BALAccounts();
PatientDetailsSql patientDetailsSql = new PatientDetailsSql();
List <PatientDetails> patientDetails = balAccounts.DisplayPatientDetail();
gdvPatientDetails.DataSource = patientDetails;
gdvPatientDetails.DataBind();
if (patientDetails.Count == 0)
{
lblStatusPatient.Text = " No Patient Details To Display";
}
else
{
headStatusPatient.Text = "Patient Details";
}
}
protected void btnDoctorSubmit_Click(object sender, EventArgs e)
{
try
{
BALAccounts Bal = new BALAccounts();
DoctorDetailsSql doctorDetailsSql = new DoctorDetailsSql();
DoctorDetails doctorDetails = new DoctorDetails
{
FirstName1 = txtDoctorFname.Text,
LastName1 = txtDoctorLname.Text,
Age1 = int.Parse(txtDoctorAge.Text),
Gender1 = ddlDoctorGender.Text,
DoB1 = txtDoctordob.Text,
ContactNumber1 = double.Parse(txtDoctorcntct.Text),
AltContactNumber1 = double.Parse(txtDoctorAltcntct.Text),
EmailID1 = txtDoctorEmail.Text,
UserName1 = txtDoctorUserName.Text,
Password1 = txtDoctorPasswd.Text,
AddressLine11 = txtDoctorAddress.Text,
AddressLine21 = txtDoctoraltAddress.Text,
City1 = txtDoctorcity.Text,
State1 = txtDoctorstate.Text,
Zipcode1 = int.Parse(txtDoctorZipcode.Text),
Degree1 = txtDoctorDegree.Text,
Specialty1 = txtDoctorSpeciality.Text,
Workhours1 = int.Parse(txtDoctorWorkhours.Text),
HospitalName1 = txtDoctorHspName.Text,
MedicareServiceID1 = int.Parse(txtDoctorMediServID.Text),
Isapproved1 = false
};
if (Bal.regdoctordetails(doctorDetails))
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "regalert();", true);
}
}
catch (Exception ex)
{
}
}
protected void MserviceDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow row = MserviceDetails.Rows[e.RowIndex];
string name = (row.FindControl("lblmedicareservice") as Label).Text;
MedicareServices medicareservices = new MedicareServices();
BALAccounts Bal = new BALAccounts();
List <MedicareServices> medservices = Bal.displaymedicareservices();
if (medservices.Count > 0)
{
for (int i = 0; i < medservices.Count; i++)
{
if (medservices[i].Medicare_service1 == name)
{
medservices.RemoveAt(i);
}
}
Bal.removemedicareservices(name);
lblStatus.Text = "Medicare Services Deleted successfully";
GetMedicareServices();
}
}
protected void gdvDoctorDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
BALAccounts Bal = new BALAccounts();
GridViewRow row = gdvDoctorDetails.Rows[e.RowIndex];
int id = int.Parse((row.FindControl("lblID") as Label).Text);
DoctorDetails doctordetails = new DoctorDetails();
List <DoctorDetails> docdetails = Bal.displaydoctordetails();
if (docdetails.Count > 0)
{
for (int i = 0; i < docdetails.Count; i++)
{
if (docdetails[i].DoctorID1 == id)
{
docdetails.RemoveAt(i);
}
}
Bal.removedoctor(id);
lblStatus.Text = "Doctor Details Deleted Successfully";
GetDoctor();
}
}
protected void gdvAgentDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
BALAccounts Bal = new BALAccounts();
GridViewRow row = gdvAgentDetails.Rows[e.RowIndex];
string name = (row.FindControl("lblAgentfname") as Label).Text;
AgentDetails agentDetails = new AgentDetails();
AgentDetailsSql agentDetailsSql = new AgentDetailsSql();
List <AgentDetails> agndetails = Bal.displayagentdetails();
if (agndetails.Count > 0)
{
for (int i = 0; i < agndetails.Count; i++)
{
if (agndetails[i].FirstName1 == name)
{
agndetails.RemoveAt(i);
}
}
Bal.removeagent(name);
lblStatusAgent.Text = "Agent Details Deleted Successfully";
GetAgent();
}
}
protected void gdvPatientDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
BALAccounts Bal = new BALAccounts();
GridViewRow row = gdvPatientDetails.Rows[e.RowIndex];
string name = (row.FindControl("lblpatientfname") as Label).Text;
PatientDetails patientDetails = new PatientDetails();
PatientDetailsSql patientDetailsSql = new PatientDetailsSql();
List <PatientDetails> patdetails = patientDetailsSql.DisplayPatientDetails();
if (patdetails.Count > 0)
{
for (int i = 0; i < patdetails.Count; i++)
{
if (patdetails[i].FirstName1 == name)
{
patdetails.RemoveAt(i);
}
}
Bal.removepatient(name);
lblStatusPatient.Text = "Patient Details Deleted Successfully";
GetPatient();
}
}
