public void Insert(GlAccountSubGroupModel model) { using (EHMSEntities ent = new EHMSEntities()) { int Level = 0; string Hierachy = ""; var data = ent.GL_AccSubGroups.Where(x => x.AccSubGruupID == model.ParentID).FirstOrDefault(); if (model.ParentID == 0) { Level = 2; Hierachy = model.AccGroupID.ToString(); } else { Hierachy = data.HierarchyCode + "." + model.ParentID.ToString(); Level = data.HeadLevel + 1; } var objGlAccount = new GL_AccSubGroups() { AccGroupID = model.AccGroupID, ParentID = model.ParentID, Remarks = model.Remarks, IsLeafLevel = model.IsLeafLevel, CreatedDate = DateTime.Now, CreatedBy = Utility.GetCurrentLoginUserId(), HeadLevel = Level, HierarchyCode = Hierachy, Status = true, AccSubGroupName = model.AccSubGroupName }; ent.GL_AccSubGroups.Add(objGlAccount); ent.SaveChanges(); int id = objGlAccount.AccSubGruupID; int parentnewid = Utility.GetAccHeadIDFromDescription("Staff Advance"); if (model.ParentID == parentnewid) { SetupEmployeeMaster SEMP = (from x in ent.SetupEmployeeMasters where x.EmployeeMasterId == model.EmployeeMasterId && x.Status == true select x).First(); SEMP.AccountHeadID = objGlAccount.AccSubGruupID; ent.SaveChanges(); } int SalaryParentid = Utility.GetAccHeadIDFromDescription("Salary Payable"); if (model.ParentID == SalaryParentid) { SetupEmployeeMaster SEMP = (from x in ent.SetupEmployeeMasters where x.EmployeeMasterId == model.EmployeeMasterId && x.Status == true select x).First(); SEMP.SPAccountHeadID = objGlAccount.AccSubGruupID; ent.SaveChanges(); } } }
//to get account sub group detail public string GetAccountSubGroupDetail(int id) { GL_AccSubGroups result = ent.GL_AccSubGroups.Where(x => x.AccSubGroupId == id).FirstOrDefault(); LedgerMasterModel model = new LedgerMasterModel(); model.AccSubGroupId = result.AccSubGroupId; model.AccSubGroupName = result.AccSubGroupName; return(model.AccSubGroupName); }
public int Insert(StockSupplierModel model) { using (EHMSEntities ent = new EHMSEntities()) { if (ent.SetupStockSuppliers.Where(x => x.StockSupplierName == model.StockSupplierName).Any()) { return(0); } //first add in coa, Sundry Creditors add accgroupid =2 parenet id 1706 , hierarchycode 2.1253.1256 head level 5 isleave yes var Globj = new GL_AccSubGroups() { AccGroupID = 2, AccSubGroupName = model.StockSupplierName, ParentID = 1706, HeadLevel = 5, HierarchyCode = "2.1253.1256.1706", IsLeafLevel = true, Status = true, CreatedBy = Utility.GetCurrentLoginUserId(), CreatedDate = DateTime.Today, Remarks = "Automatic from stock", }; ent.GL_AccSubGroups.Add(Globj); ent.SaveChanges(); var objToSave = AutoMapper.Mapper.Map <StockSupplierModel, SetupStockSupplier>(model); objToSave.Status = true; objToSave.CreatedBy = 1; objToSave.AccountHeadId = Globj.AccSubGruupID; objToSave.CreatedDate = DateTime.Now; ent.SetupStockSuppliers.Add(objToSave); ent.SaveChanges(); } return(1); }
public int Insert(SetupPathoTestModel model) { using (EHMSEntities ent = new EHMSEntities()) { var objToSave = AutoMapper.Mapper.Map <SetupPathoTestModel, SetupPathoTest>(model); objToSave.CreatedBy = 1; objToSave.CreatedDate = DateTime.Now; objToSave.Status = 1; decimal TaxTotal = Convert.ToDecimal((model.PayableGrandTotal * 5) / 100); objToSave.PayableTaxTotal = TaxTotal; decimal PathoTaxTotal = Convert.ToDecimal((model.PathologyCommAmt * 5) / 100); objToSave.PathologyCommPer = PathoTaxTotal; ent.SetupPathoTests.Add(objToSave); ent.SaveChanges(); int LastInsertedId = objToSave.TestId; //insert into Gl_accsub group coa if (model.SectionId == 24) { var GlAccSubgroup = new GL_AccSubGroups() { AccGroupID = 3, AccSubGroupName = model.TestName, ParentID = 423, HierarchyCode = "3.1.2.3.423", HeadLevel = 6, AccountCode = null, IsLeafLevel = true, Status = true, CreatedBy = Utility.GetCurrentLoginUserId(), CreatedDate = DateTime.Today, Remarks = "SpecialTest", BranchId = 1 }; ent.GL_AccSubGroups.Add(GlAccSubgroup); ent.SaveChanges(); int LastInsertedCoaId = GlAccSubgroup.AccSubGruupID; //Update setuppatho test SetupPathoTest PathoTest = (from x in ent.SetupPathoTests where x.TestId == LastInsertedId select x).First(); PathoTest.AccountHeadId = LastInsertedCoaId; try { ent.SaveChanges(); } catch (DbEntityValidationException ex) { StringBuilder sb = new StringBuilder(); foreach (var failure in ex.EntityValidationErrors) { sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType()); foreach (var error in failure.ValidationErrors) { sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage); sb.AppendLine(); } } throw new DbEntityValidationException( "Entity Validation Failed - errors follow:\n" + sb.ToString(), ex ); // Add the original exception as the innerException } } } return(1); }
public int Insert(DepositMasterModel model) { using (EHMSEntities ent = new EHMSEntities()) { //Insert into CA Table //If User already exist, dont insert //check if user has alreary accountheadcode in opdmaster //Get Currnet receipt number int UserReceiptNumber = Utility.GetMaxBillNumberFromDepartment("Deposit", 1); int UserAccountHeadIdInt = 0; var userAccountHeadId = ent.OpdMasters.Where(x => x.OpdID == model.PatientId).FirstOrDefault(); if (userAccountHeadId.AccountHeadId != null) { UserAccountHeadIdInt = (int)userAccountHeadId.AccountHeadId; } var ObjGlAccSubGroup = new GL_AccSubGroups(); if (UserAccountHeadIdInt > 0) { } else { ObjGlAccSubGroup = new GL_AccSubGroups() { AccGroupID = 2, AccSubGroupName = HospitalManagementSystem.Utility.GetPatientNameWithIdFromOpd(model.PatientId), ParentID = 1258, HierarchyCode = "2.1253.1257.1258", HeadLevel = 5, AccountCode = null, IsLeafLevel = true, Status = true, CreatedBy = HospitalManagementSystem.Utility.GetCurrentLoginUserId(), CreatedDate = DateTime.Now, Remarks = "Deposit", BranchId = 1 }; ent.GL_AccSubGroups.Add(ObjGlAccSubGroup); ent.SaveChanges(); UserAccountHeadIdInt = ObjGlAccSubGroup.AccSubGruupID; } //Update in opdmaster table OpdMaster AccountHeadId = (from x in ent.OpdMasters where x.OpdID == model.PatientId select x).First(); AccountHeadId.AccountHeadId = UserAccountHeadIdInt; var SaveDepositMaster = AutoMapper.Mapper.Map <DepositMasterModel, PatientDepositMaster>(model); SaveDepositMaster.CreatedBy = Utility.GetCurrentLoginUserId(); SaveDepositMaster.CreatedDate = DateTime.Now; SaveDepositMaster.CreatedDepartmentId = Utility.GetCurrentUserDepartmentId(); SaveDepositMaster.Status = true; SaveDepositMaster.SwipeCardId = "NN009"; SaveDepositMaster.ReceiptID = UserReceiptNumber; SaveDepositMaster.SwipeCardDetail = "ScardDetails"; ent.PatientDepositMasters.Add(SaveDepositMaster); //Get Currrent Receipt Number int ReceiptNumberInt = Utility.GetMaxBillNumberFromDepartment("Hospital", 1); var ObjCentralizedBillingMaster = new CentralizedBillingMaster() { BillNo = ReceiptNumberInt, BillDate = DateTime.Now, TotalBillAmount = model.DepositedAmount, Narration1 = "Deposit", Narration2 = "", DepartmentName = "CB", SubDepartmentId = 1, PatientLogId = HospitalManagementSystem.Utility.getPatientLogID(model.PatientId), PatientId = model.PatientId, CreatedDepartmentId = HospitalManagementSystem.Utility.GetCurrentUserDepartmentId(), CreatedBy = HospitalManagementSystem.Utility.GetCurrentLoginUserId(), CreatedDate = DateTime.Now, Remarks = "Deposit", Status = true, BranchId = 1, JVStatus = false, ReceiptId = Utility.GetMaxDepositeNumber(), IsHandover = false, ReturnedAmount = Convert.ToDecimal(0), TenderAmount = Convert.ToDecimal(0), TotalDiscountAmount = Convert.ToDecimal(0), TotalDiscountID = 0, PayableType = 1//general }; ent.CentralizedBillingMasters.Add(ObjCentralizedBillingMaster); var ObjCentralizedBillingDetails = new CentralizedBillingDetail() { BillNo = ReceiptNumberInt, AccountHeadID = 1258, //deposit AccountSubHeadID = UserAccountHeadIdInt, //patientId Amount = model.DepositedAmount, Status = true, DepartmentId = 1003//Ipd Department }; ent.CentralizedBillingDetails.Add(ObjCentralizedBillingDetails); var ObjCentralizedBillingPaymentType = new CentralizedBillingPaymentType() { BillNo = ReceiptNumberInt, PaymentTypeID = 372, Amount = model.DepositedAmount, Status = true, PaymentSubTypeID = Convert.ToInt32(0) }; ent.CentralizedBillingPaymentTypes.Add(ObjCentralizedBillingPaymentType); //update Bill Number SetupHospitalBillNumber billNumber = (from x in ent.SetupHospitalBillNumbers where x.DepartmentName == "Hospital" && x.FiscalYearId == 1 select x).First(); billNumber.BillNumber = billNumber.BillNumber + 1; ent.SaveChanges(); //update Bill Number SetupHospitalBillNumber billNumberDeposit = (from x in ent.SetupHospitalBillNumbers where x.DepartmentName == "Deposit" && x.FiscalYearId == 1 select x).First(); billNumberDeposit.BillNumber = billNumberDeposit.BillNumber + 1; ent.SaveChanges(); return(SaveDepositMaster.PatientDepositMasterId); } }