protected void btnUpdate_Click(object sender, EventArgs e)
{
if (ddlPHappit.SelectedIndex != -1)
{
int AffID = int.Parse(txtAffiliationID.Text);
//using (AppointmentDBContext appdb = new AppointmentDBContext())
//{
// int AffID = int.Parse(txtAffiliationID.Text);
// int cycleID = int.Parse(Session["CycleIDFromAdmin"].ToString());
// Appointment checkapp = (from Appointment_tbl in appdb.Appointments where Appointment_tbl.AffiliationID == AffID && Appointment_tbl.CycleID == cycleID select Appointment_tbl).FirstOrDefault();
// if (checkapp == null)
// {
using (AffiliationsDBContext db = new AffiliationsDBContext())
{
Affiliation updateAff = (from Affiliation_tbl in db.Affiliations where Affiliation_tbl.Deleted == null && Affiliation_tbl.AffiliationID == AffID select Affiliation_tbl).FirstOrDefault();
updateAff.BestTimeFrom = txtBestTimeFrom.Text;
updateAff.BestTimeTo = txtBestTimeTo.Text;
updateAff.Notes = txtNotes.Text;
int roweffected = db.SaveChanges();
if (roweffected > 0)
{
affiliationslblSaveStatus.Text = "Updated";
}
else
{
affiliationslblSaveStatus.Text = "Error";
}
}
int LineID = int.Parse(Session["LineID"].ToString());
using (PhysicianValueDBContext db = new PhysicianValueDBContext())
{
PhysicianValueByLine updatePhByLine = (from PhyByLine_tbl in db.PhysicianValueByLines where PhyByLine_tbl.Deleted == null && PhyByLine_tbl.AffiliationID == AffID && PhyByLine_tbl.LineID == LineID select PhyByLine_tbl).FirstOrDefault();
updatePhByLine.NoOfPatients = Math.Round(float.Parse(ddlNoOfPatients.SelectedValue), 3, MidpointRounding.AwayFromZero);
updatePhByLine.WaitingTime = Math.Round(float.Parse(ddlWaitingTime.SelectedValue), 3, MidpointRounding.AwayFromZero);
updatePhByLine.PrescriptionHappit = Math.Round(float.Parse(ddlPHappit.SelectedValue), 3, MidpointRounding.AwayFromZero);
//updatePhByLine.PrescriptionHappit = Math.Round(float.Parse(ddlPHappit.SelectedValue), 3, MidpointRounding.AwayFromZero);
updatePhByLine.TotalValue = updatePhByLine.NoOfPatients + updatePhByLine.PrescriptionHappit + Math.Round(float.Parse(txtSpecValue.Text), 3, MidpointRounding.AwayFromZero);
updatePhByLine.LastModifierID = int.Parse(Session["EmployeeHRCode"].ToString());
updatePhByLine.LastModificationDate = DateTime.Today;
if (updatePhByLine.TotalValue >= 7)
{
updatePhByLine.PhysicianClass = "A";
}
if (updatePhByLine.TotalValue < 7)
{
if (updatePhByLine.TotalValue >= 5)
{
updatePhByLine.PhysicianClass = "B";
}
if (updatePhByLine.TotalValue < 5)
{
updatePhByLine.PhysicianClass = "C";
}
}
int roweffected = db.SaveChanges();
if (roweffected > 0)
{
affiliationslblSaveStatus.Text = "Updated";
btnUpdate.Visible = false;
saveorupdate();
clearFields();
Panel1.Visible = false;
}
else
{
affiliationslblSaveStatus.Text = "Error";
}
}
using (AffiliationsAdminViewDBContext db = new AffiliationsAdminViewDBContext())
{
var affiliationdata = from affiliation_tbl in db.View_Affiliations_Admin where affiliation_tbl.Deleted == null && affiliation_tbl.AffiliationID == AffID && affiliation_tbl.LineID == LineID select affiliation_tbl;
gvAffiliations.DataSource = affiliationdata.ToList();
gvAffiliations.DataBind();
}
}
// else if (checkapp != null)
// {
// affiliationslblSaveStatus.Text = "Cannot update this affiliation.It has appointments";
//}
//}
//}
else
{
if (ddlPHappit.SelectedIndex == -1)
{
lblPHappitReq.Visible = true;
}
affiliationslblSaveStatus.Text = "All Fields with red(*) is mandatory";
}
}
protected void gvAffiliations_SelectedIndexChanged(object sender, EventArgs e)
{
btnDelete.Visible = true;
btnUpdate.Visible = true;
btnSave.Visible = false;
phyRow = gvAffiliations.SelectedRow;
txtAffiliationName.Text = phyRow.Cells[2].Text.Replace(" ", "");
txtAffID.Text = phyRow.Cells[1].Text.Replace(" ", "");
txtBestTimeFrom.Text = phyRow.Cells[13].Text.Replace(" ", "");
txtBestTimeTo.Text = phyRow.Cells[14].Text.Replace(" ", "");
txtNotes.Text = phyRow.Cells[15].Text.Replace(" ", "");
txtAffClinicCode.Text = phyRow.Cells[11].Text.Replace(" ", "");
txtAffPhyCode.Text = phyRow.Cells[10].Text.Replace(" ", "");
txtSpCode.Text = phyRow.Cells[16].Text.Replace(" ", "");
using (PhysicianValueDBContext PhValDB = new PhysicianValueDBContext())
{
int affID = int.Parse(txtAffID.Text);
for (int i = 1; i <= 7; i++)
{
if (i == 1)
{
var PhValdata = (from PhVal_tbl in PhValDB.PhysicianValueByLines where (PhVal_tbl.Deleted == null || PhVal_tbl.Deleted == false) && PhVal_tbl.AffiliationID == affID && PhVal_tbl.LineID == i select PhVal_tbl).FirstOrDefault();
ddlLine1.SelectedValue = PhValdata.PrescriptionHappit.ToString();
ddlNoPatients1.SelectedValue = PhValdata.NoOfPatients.ToString();
if (PhValdata.WaitingTime.ToString() != "0")
{
ddlWT1.SelectedValue = PhValdata.WaitingTime.ToString();
}
txtRecID1.Text = PhValdata.RecID.ToString();
}
if (i == 2)
{
var PhValdata = (from PhVal_tbl in PhValDB.PhysicianValueByLines where (PhVal_tbl.Deleted == null || PhVal_tbl.Deleted == false) && PhVal_tbl.AffiliationID == affID && PhVal_tbl.LineID == i select PhVal_tbl).FirstOrDefault();
ddlLine2.SelectedValue = PhValdata.PrescriptionHappit.ToString();
ddlNoPatients2.SelectedValue = PhValdata.NoOfPatients.ToString();
if (PhValdata.WaitingTime.ToString() != "0")
{
ddlWT2.SelectedValue = PhValdata.WaitingTime.ToString();
}
txtRecID2.Text = PhValdata.RecID.ToString();
}
if (i == 3)
{
var PhValdata = (from PhVal_tbl in PhValDB.PhysicianValueByLines where (PhVal_tbl.Deleted == null || PhVal_tbl.Deleted == false) && PhVal_tbl.AffiliationID == affID && PhVal_tbl.LineID == i select PhVal_tbl).FirstOrDefault();
ddlLine3.SelectedValue = PhValdata.PrescriptionHappit.ToString();
ddlNoPatients3.SelectedValue = PhValdata.NoOfPatients.ToString();
if (PhValdata.WaitingTime.ToString() != "0")
{
ddlWT3.SelectedValue = PhValdata.WaitingTime.ToString();
}
txtRecID3.Text = PhValdata.RecID.ToString();
}
if (i == 4)
{
var PhValdata = (from PhVal_tbl in PhValDB.PhysicianValueByLines where (PhVal_tbl.Deleted == null || PhVal_tbl.Deleted == false) && PhVal_tbl.AffiliationID == affID && PhVal_tbl.LineID == i select PhVal_tbl).FirstOrDefault();
ddlLine4.SelectedValue = PhValdata.PrescriptionHappit.ToString();
ddlNoPatients4.SelectedValue = PhValdata.NoOfPatients.ToString();
if (PhValdata.WaitingTime.ToString() != "0")
{
ddlWT4.SelectedValue = PhValdata.WaitingTime.ToString();
}
txtRecID4.Text = PhValdata.RecID.ToString();
}
if (i == 5)
{
var PhValdata = (from PhVal_tbl in PhValDB.PhysicianValueByLines where (PhVal_tbl.Deleted == null || PhVal_tbl.Deleted == false) && PhVal_tbl.AffiliationID == affID && PhVal_tbl.LineID == i select PhVal_tbl).FirstOrDefault();
ddlLine5.SelectedValue = PhValdata.PrescriptionHappit.ToString();
ddlNoPatients5.SelectedValue = PhValdata.NoOfPatients.ToString();
if (PhValdata.WaitingTime.ToString() != "0")
{
ddlWT5.SelectedValue = PhValdata.WaitingTime.ToString();
}
txtRecID5.Text = PhValdata.RecID.ToString();
}
if (i == 6)
{
var PhValdata = (from PhVal_tbl in PhValDB.PhysicianValueByLines where (PhVal_tbl.Deleted == null || PhVal_tbl.Deleted == false) && PhVal_tbl.AffiliationID == affID && PhVal_tbl.LineID == i select PhVal_tbl).FirstOrDefault();
ddlLine6.SelectedValue = PhValdata.PrescriptionHappit.ToString();
ddlNoPatients6.SelectedValue = PhValdata.NoOfPatients.ToString();
if (PhValdata.WaitingTime.ToString() != "0")
{
ddlWT6.SelectedValue = PhValdata.WaitingTime.ToString();
}
txtRecID6.Text = PhValdata.RecID.ToString();
}
if (i == 7)
{
var PhValdata = (from PhVal_tbl in PhValDB.PhysicianValueByLines where (PhVal_tbl.Deleted == null || PhVal_tbl.Deleted == false) && PhVal_tbl.AffiliationID == affID && PhVal_tbl.LineID == i select PhVal_tbl).FirstOrDefault();
ddlLine7.SelectedValue = PhValdata.PrescriptionHappit.ToString();
ddlNoPatients7.SelectedValue = PhValdata.NoOfPatients.ToString();
if (PhValdata.WaitingTime.ToString() != "0")
{
ddlWT7.SelectedValue = PhValdata.WaitingTime.ToString();
}
txtRecID7.Text = PhValdata.RecID.ToString();
}
}
}
}
