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(); } } } }