private void Btn2_Click(object sender, RoutedEventArgs e) { Cost.GetBindingExpression(NumericUpDown.ValueProperty).UpdateSource(); OldDebt.GetBindingExpression(NumericUpDown.ValueProperty).UpdateSource(); CashPaid.GetBindingExpression(NumericUpDown.ValueProperty).UpdateSource(); DiscountPaid.GetBindingExpression(NumericUpDown.ValueProperty).UpdateSource(); }
public dynamic ToDBCampAdmission(CampAdmission CampAdmission) { if (CampAdmission.Patient_Name != null || CampAdmission.Patient_Name != "") { var mrNo = ""; var uin = ""; var aadNo = ""; var ipano = ""; var ipno = ""; var invno = ""; var patientClass = ""; var statusDesc = Context.State_Master.Where(x => x.State_Name == CampAdmission.C_StateDesc).Select(x => x.State_Code).FirstOrDefault(); CampAdmission.StateCode = statusDesc; var CountryDesc = Context.Country_Master.Where(x => x.Country_Name == CampAdmission.C_CountryDesc).Select(x => x.Country_Code).FirstOrDefault(); CampAdmission.ContryCode = CountryDesc; var Districtcodes = Context.District_Master.Where(x => x.District_Name == CampAdmission.C_DistrictDesc).Select(x => x.District_Code).FirstOrDefault(); CampAdmission.DistrictCode = Districtcodes; var talukcodes = Context.Taluk_Master.Where(x => x.Taluk_Name == CampAdmission.C_TalukDesc).Select(x => x.Taluk_Code).FirstOrDefault(); CampAdmission.Taluk_Code = talukcodes; if (CampAdmission.IsCOTChecked == "Y") { CampAdmission.bedCharges = Context.StateBedCharges.Where(o => o.StateID == CampAdmission.StateCode).Select(x => x.COTCharges).FirstOrDefault(); } else if (CampAdmission.IsMATChecked == "Y") { CampAdmission.bedCharges = Context.StateBedCharges.Where(o => o.StateID == CampAdmission.StateCode).Select(x => x.MATCharges).FirstOrDefault(); } mrNo = GenerateRunningCtrlNo("MR_NO_CAMP", CampAdmission.Site_ID); uin = GenerateRunningCtrlNo("UIN", CampAdmission.Site_ID); CampAdmission.mr_no = mrNo; CampAdmission.uin = uin; if (CampAdmission.IDProof_Desc == "Aadhar Card") { aadNo = CampAdmission.IDProof_Code; } //if (CampAdmission.bedCharges > 0) //{ // ipano = GenerateRunningCtrlNo("CIPA_NO", CampAdmission.Site_ID); // patientClass = "SITE03"; //} //else if (CampAdmission.bedCharges == 0) //{ ipano = GenerateRunningCtrlNo("FIPA_NO", CampAdmission.Site_ID); patientClass = "SITE02"; // } ipno = GenerateRunningCtrlNo("CAMP_IP_NO ", CampAdmission.Site_ID); CampAdmission.ipno = ipno; invno = GenerateRunningCtrlNo("INVOICE_NO", CampAdmission.Site_ID); var icpl = new Ip_Camp_Place(); icpl.mr_no = mrNo; icpl.ipa_no = ipano; icpl.Admission_place = CampAdmission.Admission_Place; icpl.Sysdate = DateTime.Now; Context.ip_camp_place.Add(icpl); var ipadmissions = Context.Free_Accommodations_Master.Where(x => x.ROOM_NO == CampAdmission.Room_No).FirstOrDefault(); if (ipadmissions != null) { ipadmissions.LAST_ALLOCATION -= 1; Context.Entry(ipadmissions).State = EntityState.Modified; } var isOPeXists = Context.Op_Visit_Datewise.Where(x => x.Date == DateTime.Now.Date && x.Patient_Class == patientClass).Count(); var opvd = Context.Op_Visit_Datewise.Where(x => x.Patient_Class == patientClass && x.Date == DateTime.Now.Date).FirstOrDefault(); var opvdw = new OpVisitDatewise(); opvdw.Patient_Class = patientClass; opvdw.Date = DateTime.Now.Date; opvdw.New = 0; opvdw.Old = 0; opvdw.Week_Day = (int)DateTime.Now.DayOfWeek; if (isOPeXists > 0) { //Context.Op_Visit_Datewise.Update(opvdw); if (opvd != null) { opvd.Admission += 1; Context.Entry(opvd).State = EntityState.Modified; } } //else if (isOPeXists == 0) //{ // Context.Op_Visit_Datewise.Add(opvdw); //} var PRM = new PatientRegistrationMaster(); PRM.MR_NO = mrNo; PRM.IP_NO = ipno; PRM.Patient_Class = patientClass; PRM.Patient_Name = CampAdmission.Patient_Name; PRM.Next_Of_Kin = $"{CampAdmission.Next_Of_Kin_Prefix},{CampAdmission.Next_Of_Kin_Suffix}"; PRM.Date_Of_Birth = CampAdmission.Patient_DOB; PRM.Sex = CampAdmission.Gender; PRM.Door = CampAdmission.Door; PRM.Street_Locality = CampAdmission.Street; PRM.Pincode = CampAdmission.Pincode; PRM.Town_City = CampAdmission.City; PRM.Taluk = CampAdmission.Taluk_Code; PRM.District = CampAdmission.DistrictCode; PRM.State = CampAdmission.StateCode; PRM.Country = CampAdmission.ContryCode; PRM.Phone = CampAdmission.Phone_No; PRM.Registered_Date = DateTime.Now; PRM.Last_Visit_Date = DateTime.Now; PRM.AadhaarNo = CampAdmission.Master.AadhaarNo; PRM.Base_Unit = "LC15"; PRM.Last_Unit_Visited = "LC15"; PRM.Visit_Number = 1; PRM.Sysdate = DateTime.Now; PRM.UIN = uin; //PRM.AadhaarNo = aadNo; PRM.SiteId = CampAdmission.Site_ID; Context.Patient_Registration_Master.Add(PRM); var PRD = new PatientRegistrationDetail(); PRD.MR_NO = mrNo; PRD.Allocation_Code = "LC15"; PRD.Visit_Date = DateTime.Now; PRD.Visit_Number = 1; PRD.Category_Code = "CATC002"; PRD.Type_Code = "PTY001"; PRD.Instance_Code = "INSC001"; PRD.Speciality_Code = "SPC001"; PRD.Sysdate = DateTime.Now; PRD.Allocation_Code = "LC007"; PRD.Camp_Code = CampAdmission.Camp_Code; PRD.UIN = uin; PRD.SiteId = CampAdmission.Site_ID; Context.Patient_Registration_Detail.Add(PRD); var LM = new MRLocationMaster(); LM.MR_NO = mrNo; LM.Location_Code = "LC15"; LM.Patient_Name = CampAdmission.Patient_Name; LM.Town_City = CampAdmission.City; LM.UIN = uin; LM.SiteId = 1; Context.MR_Location_Master.Add(LM); var PS = new PatientStatus(); PS.Visit_Date = DateTime.Now; PS.MR_NO = mrNo; PS.Assign_Doctor = "N"; PS.UIN = uin; //PS.PurposeId = Convert.ToInt32( CampAdmission.Camp_Code); PS.PurposeId = 42; PS.SiteId = CampAdmission.Site_ID; Context.Patient_Status.Add(PS); if (CampAdmission.History.Count() > 0) { foreach (var item in CampAdmission.History.ToList()) { var PH = new PatientHistory(); PH.UIN = uin; PH.MR_NO = mrNo; PH.PatientHistoryDescription = item.PatientHistoryDescription; PH.DurationMonth = item.DurationMonth; PH.DurationYear = item.DurationYear; PH.CreatedUTC = DateTime.Now; PH.CreatedBy = Convert.ToInt32(CampAdmission.Operator_ID); PH.SiteId = CampAdmission.Site_ID; Context.PatientHistory.AddRange(PH); } } var IDPD = new IDProofDtl(); IDPD.UIN = uin; IDPD.MR_NO = mrNo; IDPD.PROOF_TYPE = CampAdmission.IDProof_Code; IDPD.PROOF_NO = CampAdmission.IDProof_Desc; IDPD.CASTE_CODE = Convert.ToString(CampAdmission.Caste_Code); Context.IDProof_Dtl.Add(IDPD); var IPSD = new IpSurgeryDtl(); IPSD.Ipa_No = ipano; IPSD.Surgery_Code = CampAdmission.Surgery_Code; IPSD.Surgery_Type_Code = "T"; IPSD.Anaesthesia = "AN002"; IPSD.Doctor_Code = "401"; IPSD.Eye = CampAdmission.Eye_Code; IPSD.Surgery_Date = DateTime.Now.Date; IPSD.Surgery_Approval = "Y"; IPSD.Surgery_Done = "N"; IPSD.SiteId = CampAdmission.Site_ID; IPSD.UIN = uin; Context.Ip_Surgery_Dtl.Add(IPSD); var IPAcc = new IPAccount(); IPAcc.Ipa_No = ipano; IPAcc.Mr_No = mrNo; IPAcc.Status = "ADM"; IPAcc.System = DateTime.Now; IPAcc.Ip_No = ipno; IPAcc.Siteid = CampAdmission.Site_ID; IPAcc.Uin = uin; PRM.IPAccountIC = new List <IPAccount>() { IPAcc }; var IPA = new IPAdmission(); IPA.Ipa_No = ipano; IPA.Ip_No = ipno; IPA.Mr_No = mrNo; IPA.Surgery_Code = CampAdmission.Surgery_Code; IPA.Surgery_Type_Code = "T"; IPA.Admission_Date = DateTime.Now; IPA.Room_Type = "FREETYPE7"; IPA.Room_No = CampAdmission.Room_No; IPA.Expected_Discharge_Date = DateTime.Now.AddDays(2); IPA.Doctor_Code = "401"; IPA.Category_Code = "CATC002"; IPA.Anesthesia = "AN002"; IPA.Discharge_Status = "ADM"; IPA.Eye = CampAdmission.Eye_Code; //IPA.Ipa_No = ipno; IPA.Room_Type2 = null; IPA.Lens_Code = CampAdmission.Lens_Code; IPA.Operator_Code = CampAdmission.Operator_ID; IPA.Camp_Code = CampAdmission.Camp_Code; IPA.UIN = uin; IPA.SiteId = CampAdmission.Site_ID; PRM.IPAdmissionIC = new List <IPAdmission>() { IPA }; if (CampAdmission.bedCharges > 0) { var IM = new InvoiceMaster(); IM.Invoice_No = invno; IM.Invoice_Date = DateTime.Now; IM.Invoice_Value = float.Parse(CampAdmission.bedCharges.ToString()); IM.Invoice_Received_Value = float.Parse(CampAdmission.bedCharges.ToString()); IM.Module_Code = "MOD4"; IM.SiteId = CampAdmission.Site_ID; IM.UIN = uin; IM.MR_NO = mrNo; PRM.Invoice_Master = new List <InvoiceMaster>() { IM }; var accDtl = new IpAccountDtl(); if (CampAdmission.bedCharges > 0) { accDtl.Ipa_Sl_No = Convert.ToInt32(GenerateRunningCtrlNo("IPA_SL_NO", CampAdmission.Site_ID)); accDtl.Ipa_No = ipano; accDtl.Cash_Flow_Code = "501"; accDtl.Tinvoice_No = invno; accDtl.Sysdate = DateTime.Now; accDtl.Date = DateTime.Now.Date; accDtl.Cost_Value = Convert.ToDecimal(CampAdmission.bedCharges); accDtl.UIN = uin; accDtl.SiteId = CampAdmission.Site_ID; Context.Ip_Account_Dtl.Add(accDtl); } var cashPaid = new CashPaid(); if (CampAdmission.bedCharges > 0) { cashPaid.Operator_Code = CampAdmission.Operator_ID; cashPaid.Module_Code = "MOD4"; cashPaid.MR_NO = mrNo; cashPaid.IPA_NO = ipano; cashPaid.Receipt_NO = GenerateRunningCtrlNo("FRES_RECEIPT_NO", CampAdmission.Site_ID); cashPaid.Fees_Paid = Convert.ToDouble(CampAdmission.bedCharges); cashPaid.Date = DateTime.Now.Date; cashPaid.Transaction_Code = "RECPT"; cashPaid.Category_Code = "CATC001"; cashPaid.Sysdate = DateTime.Now; cashPaid.OP_IP_Flag = "IP"; cashPaid.Paymode_Code = "PC001"; cashPaid.Outstanding = "N"; cashPaid.Invoice_No = invno; cashPaid.UIN = uin; cashPaid.SiteId = CampAdmission.Site_ID; Context.Cash_Paid.Add(cashPaid); } } } try { if (Context.SaveChanges() > 0) { return new { Success = true, name = CampAdmission.Patient_Name, eyes = CampAdmission.Eye_Code, taluks = CampAdmission.C_TalukDesc, DistrictDesc = CampAdmission.C_DistrictDesc, StateDesc = CampAdmission.C_StateDesc, CountryDesc = CampAdmission.C_CountryDesc, MRNO = CampAdmission.mr_no, UIN = CampAdmission.uin, Siteid = CampAdmission.Site_ID, campcodes = CampAdmission.Camp_Code, campnames = Context.CAMP_MASTER.Where(x => x.CAMP_CODE == CampAdmission.Camp_Code).Select(x => x.CAMP_NAME).FirstOrDefault(), ages = CampAdmission.Age, sex = CampAdmission.Gender, kins = CampAdmission.Next_Of_Kin_Suffix, room = CampAdmission.Room_No, town = CampAdmission.City, numer = CampAdmission.Phone_No, ipnos = CampAdmission.ipno, VacantBed = Context.Free_Accommodations_Master.Where(x => x.ROOM_NO == CampAdmission.Room_No).Select(x => x.LAST_ALLOCATION).FirstOrDefault(), Endrange = Context.Free_Accommodations_Master.Where(x => x.ROOM_NO == CampAdmission.Room_No).Select(x => x.END_RANGE).FirstOrDefault(), } } ; } catch (Exception ex) { Console.WriteLine(ex); } return(new { Success = false, message = "Details not saved!" }); }