private void PhValueUpdate(PhysiciansValueTempDBContext db, int ID, int i, double PHabit, double NoOfPat, int rec, bool deleted, double WT) { //PhysicianValueByLine updatePhVal = (from PhVal_tbl in db.PhysicianValueByLines where PhVal_tbl.Deleted == null && PhVal_tbl.AffiliationID == ID && PhVal_tbl.LineID == i select PhVal_tbl).FirstOrDefault(); PhysicianValueByLineTemp updatePhVal = new PhysicianValueByLineTemp(); updatePhVal.AffiliationID = ID; updatePhVal.PrescriptionHappit = PHabit; updatePhVal.NoOfPatients = NoOfPat; updatePhVal.RecID = rec; updatePhVal.LineID = i; updatePhVal.Deleted = deleted; updatePhVal.WaitingTime = WT; using (SpecialtyPriorityDBContext SVdb = new SpecialtyPriorityDBContext()) { int spcode = int.Parse(txtSpCode.Text); var SVData = (from SV_tbl in SVdb.SpecPriorityByLines where SV_tbl.LineID == i && SV_tbl.SpecialtyID == spcode select SV_tbl).FirstOrDefault(); updatePhVal.SpecialtyValue = SVData.SpecValue / 10; } updatePhVal.TotalValue = updatePhVal.SpecialtyValue + updatePhVal.PrescriptionHappit + updatePhVal.NoOfPatients; if (updatePhVal.TotalValue >= 8) { updatePhVal.PhysicianClass = "A+"; } if (updatePhVal.TotalValue < 8) { if (updatePhVal.TotalValue >= 4.5) { updatePhVal.PhysicianClass = "A"; } if (updatePhVal.TotalValue < 4.5) { updatePhVal.PhysicianClass = "C"; } } updatePhVal.LastModifierID = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString()); updatePhVal.LastModificationDate = DateTime.Now; updatePhVal.Status = false; updatePhVal.New = false; db.PhysicianValueByLineTemps.Add(updatePhVal); int roweffected = db.SaveChanges(); affiliationslblSaveStatus.Text = "Updated"; }
protected void btnSave_Click(object sender, EventArgs e) { using (AffiliationTempDBContext newAff = new AffiliationTempDBContext()) { AffiliationsTemp Aff = new AffiliationsTemp(); using (PhysicianBDContext PHdb = new PhysicianBDContext()) { int PhyCode = int.Parse(txtAffPhyCode.Text); var PhysicianData = (from physicion_tbl in PHdb.Physicians where physicion_tbl.PhysicianID == PhyCode select physicion_tbl).FirstOrDefault(); txtAffiliationName.Text = PhysicianData.PhysicianName; txtSpCode.Text = (PhysicianData.SpecialtyID).ToString(); } Aff.AffiliationName = txtAffiliationName.Text; Aff.PhysicianID = int.Parse(txtAffPhyCode.Text); Aff.EntityID = int.Parse(txtAffClinicCode.Text); Aff.BestTimeFrom = txtBestTimeFrom.Text; Aff.BestTimeTo = txtBestTimeTo.Text; Aff.Notes = txtNotes.Text; Aff.New = true; Aff.Status = false; Aff.Deleted = false; Aff.EntryEmployeeID = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString()); Aff.EntryDate = DateTime.Now; newAff.AffiliationsTemps.Add(Aff); int roweffected = newAff.SaveChanges(); if (roweffected > 0) { affiliationslblSaveStatus.Text = "Saved"; using (AffiliationTempDBContext db = new AffiliationTempDBContext()) { int maxent = db.AffiliationsTemps.Max(en => en.ID); txtAffID.Text = maxent.ToString(); } } else { affiliationslblSaveStatus.Text = "Error"; } } using (PhysiciansValueTempDBContext newPhVal = new PhysiciansValueTempDBContext()) { int spcode = int.Parse(txtSpCode.Text); PhysicianValueByLineTemp PhyVal = new PhysicianValueByLineTemp(); for (int i = 1; i <= 7; i++) { PhyVal.AffiliationID = int.Parse(txtAffID.Text); PhyVal.LineID = i; if (i == 1) { PhyVal.PrescriptionHappit = Double.Parse(ddlLine1.SelectedValue); PhyVal.NoOfPatients = Double.Parse(ddlNoPatients1.SelectedValue); PhyVal.WaitingTime = Double.Parse(ddlWT1.SelectedValue); } if (i == 2) { PhyVal.PrescriptionHappit = Double.Parse(ddlLine2.SelectedValue); PhyVal.NoOfPatients = Double.Parse(ddlNoPatients2.SelectedValue); PhyVal.WaitingTime = Double.Parse(ddlWT2.SelectedValue); } if (i == 3) { PhyVal.PrescriptionHappit = Double.Parse(ddlLine3.SelectedValue); PhyVal.NoOfPatients = Double.Parse(ddlNoPatients3.SelectedValue); PhyVal.WaitingTime = Double.Parse(ddlWT3.SelectedValue); } if (i == 4) { PhyVal.PrescriptionHappit = Double.Parse(ddlLine4.SelectedValue); PhyVal.NoOfPatients = Double.Parse(ddlNoPatients4.SelectedValue); PhyVal.WaitingTime = Double.Parse(ddlWT4.SelectedValue); } if (i == 5) { PhyVal.PrescriptionHappit = Double.Parse(ddlLine5.SelectedValue); PhyVal.NoOfPatients = Double.Parse(ddlNoPatients5.SelectedValue); PhyVal.WaitingTime = Double.Parse(ddlWT5.SelectedValue); } if (i == 6) { PhyVal.PrescriptionHappit = Double.Parse(ddlLine6.SelectedValue); PhyVal.NoOfPatients = Double.Parse(ddlNoPatients6.SelectedValue); PhyVal.WaitingTime = Double.Parse(ddlWT6.SelectedValue); } if (i == 7) { PhyVal.PrescriptionHappit = Double.Parse(ddlLine7.SelectedValue); PhyVal.NoOfPatients = Double.Parse(ddlNoPatients7.SelectedValue); PhyVal.WaitingTime = Double.Parse(ddlWT7.SelectedValue); } using (SpecialtyPriorityDBContext SVdb = new SpecialtyPriorityDBContext()) { var SVData = (from SV_tbl in SVdb.SpecPriorityByLines where SV_tbl.LineID == i && SV_tbl.SpecialtyID == spcode select SV_tbl).FirstOrDefault(); PhyVal.SpecialtyValue = SVData.SpecValue / 10; } PhyVal.TotalValue = PhyVal.SpecialtyValue + PhyVal.PrescriptionHappit + PhyVal.NoOfPatients; if (PhyVal.TotalValue >= 8) { PhyVal.PhysicianClass = "A+"; } if (PhyVal.TotalValue < 8) { if (PhyVal.TotalValue >= 4.5) { PhyVal.PhysicianClass = "A"; } if (PhyVal.TotalValue < 4.5) { PhyVal.PhysicianClass = "C"; } } PhyVal.LastModifierID = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString()); PhyVal.CreateDate = DateTime.Now; PhyVal.CreatorID = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString()); PhyVal.LastModificationDate = DateTime.Now; PhyVal.New = true; PhyVal.Deleted = false; PhyVal.Status = false; newPhVal.PhysicianValueByLineTemps.Add(PhyVal); int roweffected = newPhVal.SaveChanges(); if (roweffected > 0) { affiliationslblSaveStatus.Text = "Saved"; } else { affiliationslblSaveStatus.Text = "Error"; } } } }