protected void grvTime_RowDeleting(object sender, GridViewDeleteEventArgs e) { var id = long.Parse(grvTime.DataKeys[e.RowIndex].Value.ToString()); using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities()) { var financialFileToDelete = mc.Petient_Visiting_Financials.Where(o => o.Id == id).First(); mc.Petient_Visiting_Financials.Remove(financialFileToDelete); mc.SaveChanges(); } bindGridView(); }
protected void grvTime_RowUpdating(object sender, GridViewUpdateEventArgs e) { using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities()) { var row = grvTime.Rows[e.RowIndex]; var financialId = (long)grvTime.DataKeys[e.RowIndex].Value; var financialFile = mc.Petient_Visiting_Financials.Where(o => o.Id == financialId).First(); var petientId = financialFile.Connectors.First().Petient.Id; var calEdit = (JQControls.JQDatePicker)row.FindControl("calEdit"); var ucTimePickerControlStart = (Controls.TimePickerControl)row.FindControl("ucTimePickerControlStart"); var ucTimePickerControlEnd = (Controls.TimePickerControl)row.FindControl("ucTimePickerControlEnd"); var ucServicesControl = (ServicesControl)row.FindControl("ucServicesControl"); var ddlDoctorEdit = (DropDownList)row.FindControl("ddlDoctorEdit"); var ddlTechEdit = (DropDownList)row.FindControl("ddlTechEdit"); var chkIsPetientCanceled = (CheckBox)row.FindControl("chkIsPetientCanceled"); //Change Timing var date = calEdit.Date.Value.Date; var startTime = ucTimePickerControlStart.Time; var timeVisitStarts = new DateTime(date.Year, date.Month, date.Day, startTime.Hour, startTime.Minute, 0); var endTime = ucTimePickerControlEnd.Time; var timeVisitEnds = new DateTime(date.Year, date.Month, date.Day, endTime.Hour, endTime.Minute, 0); financialFile.TimeVisitStarts = timeVisitStarts; financialFile.TimeVisitEnds = timeVisitEnds; //Change Doctor, Tech //Change Service string reason = null; int? selectedService = null; List<int> selectedParts = null; getServicesOfFile(out reason, out selectedService, out selectedParts, ref ucServicesControl); financialFile.Reason = reason; createRemoveConnections(mc, selectedService, financialFile.Connectors.First().Petient.Id, financialId, selectedParts, ref ucServicesControl, ref ddlDoctorEdit, ref ddlTechEdit); //Canceled financialFile.Is_Petient_Canceled = chkIsPetientCanceled.Checked; if (financialFile.Is_Petient_Canceled == false) { //Recalculate Balance On Not Canceled if (reason == null) { financialFile.Money_To_Pay = costOfService(ucServicesControl.SelectedService, ref ucServicesControl); } else { financialFile.Money_To_Pay = 0; } int lastBalance = 0; var petientVisitingFiles = mc.Connectors.Where(o => o.PetientId == petientId && o.FinancialId != null && o.Petient_Visiting_Financials.TimeVisitStarts < financialFile.TimeVisitStarts) .OrderByDescending(o => o.Petient_Visiting_Financials.TimeVisitStarts).ToList(); if (petientVisitingFiles.Count() != 0) { lastBalance = petientVisitingFiles.ElementAt(petientVisitingFiles.IndexOf(petientVisitingFiles.First())).Petient_Visiting_Financials.Balance; } financialFile.Balance = lastBalance + (financialFile.Money_To_Pay - (financialFile.Money_Paid_Cash + financialFile.Money_Paid_Card)); if (financialFile.Money_Changed != null) { financialFile.Balance = financialFile.Balance + financialFile.Money_Changed.Value; } } else { //Recalculate Balance On Canceled int lastBalance = 0; var petientVisitingFiles = mc.Connectors.Where(o => o.PetientId == petientId && o.FinancialId != null && o.Petient_Visiting_Financials.TimeVisitStarts < financialFile.TimeVisitStarts) .OrderByDescending(o => o.Petient_Visiting_Financials.TimeVisitStarts).ToList(); if (petientVisitingFiles.Count() != 0) { lastBalance = petientVisitingFiles.ElementAt(petientVisitingFiles.IndexOf(petientVisitingFiles.First())).Petient_Visiting_Financials.Balance; } financialFile.Money_Changed = 0; financialFile.Money_Paid_Cash = 0; financialFile.Money_Paid_Card = 0; financialFile.POS_Name = ""; financialFile.Balance = lastBalance; financialFile.Is_Petient_Returned = false; financialFile.Is_Money_Paid = false; financialFile.Is_Petient_Visited = false; } //Save Changes mc.SaveChanges(); } grvTime.EditIndex = -1; bindGridView(); }
protected void grvState_RowUpdating(object sender, GridViewUpdateEventArgs e) { using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities()) { var row = grvState.Rows[e.RowIndex]; var id = grvState.DataKeys[e.RowIndex].Value; var visitingFile = mc.Petient_Visiting_Financials.Where(o => o.Id == (long)id).First(); var petientId = Guid.Parse(((Label)row.FindControl("lblPetientId")).Text); if (visitingFile.Connectors.First().BSI__Employee_Service_Set == null) { visitingFile.Money_To_Pay = int.Parse(((TextBox)row.FindControl("txtMoneyToPay")).Text); } var moneyChanged = ((TextBox)row.FindControl("txtMoneyChanged")).Text; visitingFile.Money_Changed = int.Parse(moneyChanged == "" ? "0" : moneyChanged); visitingFile.Money_Paid_Cash = int.Parse(((TextBox)row.FindControl("txtCashPaid")).Text); visitingFile.Money_Paid_Card = int.Parse(((TextBox)row.FindControl("txtCardPaid")).Text); visitingFile.POS_Name = ((DropDownList)row.FindControl("ddlPOS")).Text; visitingFile.Description = ((TextBox)row.FindControl("txtDescription")).Text; var txtOperatorUnitValue = (TextBox)row.FindControl("txtOperatorUnitValue"); if (txtOperatorUnitValue.Visible == true) { if(txtOperatorUnitValue.Text != "") { visitingFile.Operator_Unit_Value = short.Parse(txtOperatorUnitValue.Text); if (visitingFile.Connectors.First().BSI__Employee_Service_Set != null && ModelClass.GetUnitName((long?)id) != SharedClass.GetUnit(SharedClass.UnitType.Shut)) { var parentServiceStandardValue = ModelClass.GetParentServiceStandardValue((long?)id); if (parentServiceStandardValue.HasValue == true && parentServiceStandardValue.Value != 0) { visitingFile.Money_To_Pay = visitingFile.Money_To_Pay * visitingFile.Operator_Unit_Value.Value / parentServiceStandardValue.Value; } } } else { visitingFile.Operator_Unit_Value = null; } } else { visitingFile.Operator_Unit_Value = null; } int lastBalance = 0; var petientVisitingFiles = mc.Connectors.Where(o => o.PetientId == petientId && o.FinancialId != null && o.Petient_Visiting_Financials.TimeVisitStarts < visitingFile.TimeVisitStarts) .OrderByDescending(o => o.Petient_Visiting_Financials.TimeVisitStarts).ToList(); if (petientVisitingFiles.Count() != 0) { lastBalance = petientVisitingFiles.ElementAt(petientVisitingFiles.IndexOf(petientVisitingFiles.First())).Petient_Visiting_Financials.Balance; } visitingFile.Balance = lastBalance + (visitingFile.Money_To_Pay - (visitingFile.Money_Paid_Cash + visitingFile.Money_Paid_Card)); if (visitingFile.Money_Changed != null) { visitingFile.Balance = visitingFile.Balance + visitingFile.Money_Changed.Value; } mc.SaveChanges(); } grvState.EditIndex = -1; bindGridView(); }