public int Update(List <EntityCustomerTransaction> lst, tblCustomerTransaction obj) { try { tblCustomerTransaction objTest = (from tbl in objData.tblCustomerTransactions where tbl.IsDelete == false && tbl.ReceiptNo == obj.ReceiptNo select tbl).FirstOrDefault(); List <EntityCustomerTransaction> lstTemp = new List <EntityCustomerTransaction>(); List <tblTestInvoice> lstCurrent = (from tbl in objData.tblTestInvoices where tbl.PatientId == obj.PatientId && tbl.IsDelete == false select tbl).ToList(); if (objTest != null) { objTest.ReceiptDate = obj.ReceiptDate; objTest.BillAmount = obj.BillAmount; objTest.PayAmount = obj.PayAmount; objTest.Discount = obj.Discount; objTest.PatientId = obj.PatientId; } objData.SubmitChanges(); return(1); } catch (Exception ex) { throw ex; } }
public int InsertPurchaseInvoice(EntityDebitNote entPurchaseInvoice, List <EntityDebitNoteDetails> lstInvoice) { try { int?id = 0; objData.STP_Insert_DebitNote(Convert.ToDateTime(entPurchaseInvoice.DNDate), Convert.ToInt32(entPurchaseInvoice.SupplierId), false, Convert.ToDecimal(entPurchaseInvoice.Amount), Convert.ToDecimal(entPurchaseInvoice.NetAmount), Convert.ToInt32(entPurchaseInvoice.Tax1), Convert.ToInt32(entPurchaseInvoice.Tax2), Convert.ToInt32(entPurchaseInvoice.Discount), ref id); foreach (EntityDebitNoteDetails item in lstInvoice) { tblDebitNoteDetail obj = new tblDebitNoteDetail() { DNNo = id, ProductCode = item.ProductCode, Quantity = item.Quantity, Price = item.Price, Amount = item.Amount, BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, IsDelete = false }; tblStockDetail objStock = new tblStockDetail() { OpeningQty = 0, InwardQty = 0, InwardPrice = 0, InwardAmount = 0, BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, OutwardQty = item.Quantity, OutwardPrice = item.Price, DocumentNo = id, IsDelete = false, ProductId = Convert.ToInt32(item.ProductCode), TransactionType = "DebitNote", OutwardAmount = item.Amount }; objData.tblStockDetails.InsertOnSubmit(objStock); objData.tblDebitNoteDetails.InsertOnSubmit(obj); } int TId = new PatientInvoiceBLL().GetTransactionId(); tblCustomerTransaction objCust = new tblCustomerTransaction() { PayAmount = entPurchaseInvoice.NetAmount, IsCash = false, IsDelete = false, SupplierId = entPurchaseInvoice.SupplierId, ReceiptDate = entPurchaseInvoice.DNDate, TransactionDocNo = id, TransactionId = TId, TransactionType = "DebitNote" }; objData.tblCustomerTransactions.InsertOnSubmit(objCust); objData.SubmitChanges(); } catch (Exception ex) { throw ex; } return(1); }
public async void Withdraw() { if (WithdrawAmt < 0.01) { Application.Current.MainPage.DisplayAlert("Message", "Insert Valid Amount.", "Ok"); } else { var Transaction = new tblPanelUserTransaction() { iTransactionTypeID = 8, iTransactionRecordID = 0, iMadeBy = GlobalConstant.iPanelUserID, iLocationID = GlobalConstant.LocationId, iShiftID = Convert.ToInt32(ShiftId), iCustomerID = CustomerGridListObservCollection[0].CustomerID, iManagerID = -9999, sTransactionDetails = "Withdrawal made by customer.", decAmount = Convert.ToDecimal(WithdrawAmt), decNewBalance = 0, dtTransactionDate = DateTime.UtcNow, sMachineName = "", sTransactionGUID = Guid.NewGuid() }; var CustomerTransaction = new tblCustomerTransaction() { iTransactionTypeID = 8, iTransactionRecordID = 0, iMadeBy = GlobalConstant.iPanelUserID, sSessionID = "dghjskjdghd", sIPAddress = "192.158.12.45", dtCreateDateTime = DateTime.UtcNow, iCustomerID = CustomerGridListObservCollection[0].CustomerID, iManagerID = -9999, sTransactionDetails = "Customer Account Deposit.", decAmount = Convert.ToDecimal(WithdrawAmt), decNewBalance = 0, dtTransactionDate = DateTime.UtcNow, sTransactionGUID = Guid.NewGuid() }; var SaveCustomerTransaction = await new Service.CustomerService().PostCustomerTransaction(CustomerTransaction, CustomerApi.InsertCustomerTransaction); if (SaveCustomerTransaction.Status == 1) { var SaveLottoTicket = await new VoidTicketService().PosttblLottoTicket(Transaction, VoidTicketApi.InsertUserTransaction); if (SaveLottoTicket.Status == 1) { Clear(); Application.Current.MainPage.DisplayAlert("Message", "Success.", "Ok"); } } } }
protected void btnSearch_Click(object sender, EventArgs e) { try { lbl.Text = "Patient Ledger"; lblFrom.Text = ddlPatient.SelectedItem.Text; lblTo.Text = string.Format("{0:dd-MMM-yyyy}", DateTime.Now); lblMessage.Text = string.Empty; List<tblCustomerTransaction> lst = new CustomerTransactionBLL().GetPatientTransByPatientId(Convert.ToInt32(ddlPatient.SelectedValue)); EntityPatientMaster objPatient = new PatientMasterBLL().GetPatientDetailsByPatientId(Convert.ToInt32(ddlPatient.SelectedValue)); if (objPatient != null) { lblAge.Text = Convert.ToString(objPatient.Age); MRN.Text = Convert.ToString(objPatient.PatientCode); lblSex.Text = Convert.ToString(objPatient.GenderDesc); lblBloodGroup.Text = Convert.ToString(objPatient.BloodGroup); } tblCustomerTransaction obj = new tblCustomerTransaction() { }; lst.Add(obj); tblCustomerTransaction objBills = new tblCustomerTransaction() { TransactionType = "Total Invoices Amt", BillAmount = Convert.ToDecimal(lst.Sum(p => p.BillAmount)) }; lst.Add(objBills); tblCustomerTransaction objReceived = new tblCustomerTransaction() { TransactionType = "Total Received", PayAmount = Convert.ToDecimal(lst.Sum(p => p.PayAmount)) + Convert.ToDecimal(lst.Sum(p => p.AdvanceAmount)) }; lst.Add(objReceived); tblCustomerTransaction objFinal = new tblCustomerTransaction() { TransactionType = "Balance(+)/Refund(-) Amt", BillAmount = objBills.BillAmount - objReceived.PayAmount }; lst.Add(objFinal); dgvTestParameter.DataSource = lst; dgvTestParameter.DataBind(); Session["PatientLedg"] = ListConverter.ToDataTable(lst); } catch (Exception ex) { lblMessage.Text = ex.Message; } }
protected void BtnEdit_Click(object sender, EventArgs e) { try { tblCustomerTransaction entcust = new tblCustomerTransaction(); entcust.PayAmount = Convert.ToDecimal(txtPayAmount.Text); entcust.ReceiptNo = Convert.ToInt32(Session["ReceiptNo"]); entcust.BillAmount = 0; entcust.IsCash = true; entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text); entcust.SupplierId = Convert.ToInt32(ddlSupplier.SelectedValue); EntityCustomerTransaction transact = null; if (IsCheque.Checked) { entcust.IsCash = false; entcust.ISCheque = true; entcust.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text); entcust.ChequeDate = Convert.ToDateTime(txtChequeDate.Text); entcust.ChequeNo = Convert.ToString(txtChequeNo.Text); entcust.BankName = Convert.ToString(txtBankName.Text); transact = new EntityCustomerTransaction(); transact.BankId = Convert.ToInt32(ddlBank.SelectedValue); transact.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text); transact.PayAmount = Convert.ToDecimal(txtPayAmount.Text); transact.ISCheque = true; transact.BillAmount = 0; transact.ChequeDate = Convert.ToDateTime(txtChequeDate.Text); transact.ChequeNo = Convert.ToString(txtChequeNo.Text); transact.BankName = Convert.ToString(txtBankName.Text); } else if (RdoCard.Checked) { entcust.IsCash = false; entcust.ISCheque = false; transact = new EntityCustomerTransaction(); transact.BankId = Convert.ToInt32(ddlBank.SelectedValue); transact.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text); transact.PayAmount = Convert.ToDecimal(txtPayAmount.Text); transact.BillAmount = 0; } int i = new CustomerTransactionBLL().UpdateSupplierTransaction(entcust, transact, IsCash.Checked); GetSupplierTransactionList(); MultiView1.SetActiveView(View2); } catch (Exception ex) { lblMsg.Text = ex.Message; } }
public async Task <ResultModel> PostCustomerTransaction(tblCustomerTransaction model, string Url) { ResultModel _User = new ResultModel(); try { _User = await _helper.Post <tblCustomerTransaction>(model, Url); return(_User); } catch (Exception ex) { // Crashes.TrackError(ex); return(_User); } }
public int Save(EntityCustomerTransaction entCust, bool IsCash) { int TransactionId = new PatientInvoiceBLL().GetTransactionId(); int ReceiptNo = GetReceiptNo(); if (IsCash) { tblCustomerTransaction objDebit = new tblCustomerTransaction() { ReceiptDate = entCust.ReceiptDate, PatientId = entCust.PatientId, TransactionId = TransactionId, TransactionType = "Refund", TransactionDocNo = ReceiptNo, IsCash = true, BillAmount = entCust.BillAmount, PayAmount = 0, IsDelete = false, }; objData.tblCustomerTransactions.InsertOnSubmit(objDebit); } else { tblCustomerTransaction objDebit = new tblCustomerTransaction() { ReceiptDate = entCust.ReceiptDate, PatientId = entCust.PatientId, TransactionId = TransactionId, TransactionType = "Refund", TransactionDocNo = ReceiptNo, ISCheque = true, BillAmount = entCust.BillAmount, PayAmount = 0, ChequeDate = entCust.ReceiptDate, ChequeNo = entCust.ChequeNo, BankName = entCust.BankName, IsDelete = false, }; objData.tblCustomerTransactions.InsertOnSubmit(objDebit); } objData.SubmitChanges(); return(1); }
protected void btnSearch_Click(object sender, EventArgs e) { try { DateTime Curr = Convert.ToDateTime(DateTime.Now); DateTime Next = Curr.AddYears(1); lbl.Text = "SUPPLIER LEDGER REPORT" + " " + string.Format("{0:yyyy}", Curr) + "-" + string.Format("{0:yyyy}", Next); lblFrom.Text = ddlSupplier.SelectedItem.Text; lblTo.Text = string.Format("{0:dd-MMM-yyyy}", DateTime.Now); lblMessage.Text = string.Empty; List <tblCustomerTransaction> lst = new CustomerTransactionBLL().GetSupplierTransBySupplierId(Convert.ToInt32(ddlSupplier.SelectedValue)); tblCustomerTransaction obj = new tblCustomerTransaction() { }; lst.Add(obj); tblCustomerTransaction objReceived = new tblCustomerTransaction() { TransactionType = "Total Received", PayAmount = Convert.ToDecimal(lst.Sum(p => p.PayAmount)) }; lst.Add(objReceived); tblCustomerTransaction objBills = new tblCustomerTransaction() { TransactionType = "Total Bills", BillAmount = Convert.ToDecimal(lst.Sum(p => p.BillAmount)) }; lst.Add(objBills); tblCustomerTransaction objFinal = new tblCustomerTransaction() { TransactionType = "Total Bills", BillAmount = objBills.BillAmount - objReceived.PayAmount }; lst.Add(objFinal); dgvTestParameter.DataSource = lst; dgvTestParameter.DataBind(); Session["SuppLedg"] = ListConverter.ToDataTable(lst); } catch (Exception ex) { lblMessage.Text = ex.Message; } }
public int UpdateInvoice(List <EntityICUInvoiceDetail> lstEdited, List <EntityICUInvoiceDetail> lstUpdate, EntityICUInvoice entInvoice) { try { tblICUBedAlloc objTest = (from tbl in objData.tblICUBedAllocs where tbl.IsDelete == false && tbl.ICUBedAllocId == entInvoice.ICUBedAllocId select tbl).FirstOrDefault(); List <EntityICUInvoiceDetail> lstTemp = new List <EntityICUInvoiceDetail>(); List <tblCustomerTransaction> objCust = (from tbl in objData.tblCustomerTransactions where tbl.IsDelete == false && tbl.TransactionDocNo == entInvoice.ICUBedAllocId && tbl.TransactionType == "ICUInvoice" select tbl).ToList(); if (objTest != null && objCust != null) { if (objCust.Count == 1) { if (entInvoice.IsCash.Value) { tblCustomerTransaction objC = new tblCustomerTransaction() { PayAmount = lstEdited[0].NetAmount, ReceiptDate = entInvoice.AllocationDate, IsCash = entInvoice.IsCash, IsDelete = false, TransactionDocNo = entInvoice.ICUBedAllocId, TransactionId = objCust[0].TransactionId, TransactionType = "Invoice", PatientId = entInvoice.PatientId, }; objData.tblCustomerTransactions.InsertOnSubmit(objC); foreach (tblCustomerTransaction item in objCust) { item.BillAmount = lstEdited[0].NetAmount; item.ReceiptDate = entInvoice.AllocationDate; item.IsCash = entInvoice.IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { item.PayAmount = lstEdited[0].NetAmount; } } } else { foreach (tblCustomerTransaction item in objCust) { item.BillAmount = entInvoice.NetAmount; item.ReceiptDate = entInvoice.AllocationDate; item.IsCash = entInvoice.IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { item.PayAmount = lstEdited[0].NetAmount; } } } } else { foreach (tblCustomerTransaction item in objCust) { item.BillAmount = lstEdited[0].NetAmount; item.ReceiptDate = entInvoice.AllocationDate; item.IsCash = entInvoice.IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { item.PayAmount = lstEdited[0].NetAmount; } } } objTest.AllocationDate = entInvoice.AllocationDate; objTest.TotalAmount = entInvoice.TotalAmount; objTest.NetAmount = lstEdited[0].NetAmount; objTest.Tax1 = entInvoice.Tax1; objTest.Discount = entInvoice.Discount; objTest.Tax2 = entInvoice.Tax2; } foreach (EntityICUInvoiceDetail item in lstEdited) { int cnt = (from tbl in objData.tblICUInvoiceDetails where tbl.ICUBedAllocId == entInvoice.ICUBedAllocId && tbl.ChargesId == item.ChargesId && tbl.IsDelete == false select tbl).ToList().Count; if (cnt == 0) { tblICUInvoiceDetail objNewAdded = new tblICUInvoiceDetail() { ICUBedAllocId = entInvoice.ICUBedAllocId, ChargesId = item.ChargesId, Amount = item.Amount, IsDelete = false }; objData.tblICUInvoiceDetails.InsertOnSubmit(objNewAdded); objData.SubmitChanges(); } else { lstTemp.Add(item); } } foreach (EntityICUInvoiceDetail item in lstUpdate) { tblICUInvoiceDetail cnt = (from tbl in objData.tblICUInvoiceDetails where tbl.ICUBedAllocId == entInvoice.ICUBedAllocId && tbl.ChargesId == item.ChargesId select tbl).FirstOrDefault(); if (cnt != null) { int checkExist = (from tbl in lstTemp where tbl.ChargesId == item.ChargesId select tbl).ToList().Count; if (checkExist == 0) { cnt.IsDelete = true; } } } objData.SubmitChanges(); return(1); } catch (Exception ex) { throw ex; } }
public int Update(EntityPurchaseInvoice invoice, List<EntityPurchaseInvoiceDetails> lst) { int i = 0; try { tblPurchaseInvoice objExistInvoice = (from tbl in objData.tblPurchaseInvoices where tbl.IsDelete == false && tbl.PINo == invoice.PINo select tbl).FirstOrDefault(); if (objExistInvoice != null) { bool flagISPOComplete = false; if (invoice.PONo > 0) { if (objExistInvoice.PONo > 0) { List<tblPurchaseInvoiceDetail> lstExistedItems = (from tbl in objData.tblPurchaseInvoiceDetails where tbl.PINo == invoice.PINo && tbl.IsDelete == false select tbl).ToList(); if (lstExistedItems.Count > lst.Count) { foreach (tblPurchaseInvoiceDetail item in lstExistedItems) { int cnt = (from tbl in lst where tbl.ProductCode == item.ProductCode && tbl.PurchaseInvoiceNo == item.PINo select tbl).Count(); if (cnt == 0) { item.IsDelete = true; } tblPurchaseOrderDetail objOrder = (from tbl in objData.tblPurchaseOrderDetails join tblPurchaseInv in objData.tblPurchaseInvoices on tbl.PO_Id equals tblPurchaseInv.PONo where tblPurchaseInv.PINo == item.PINo && tbl.IsDelete == false && tbl.Product_Id == item.ProductCode select tbl).FirstOrDefault(); if (objOrder != null) { objOrder.InvoiceQuantity = 0; } } objData.SubmitChanges(); } #region Update Invoice Details foreach (EntityPurchaseInvoiceDetails item in lst) { tblPurchaseInvoiceDetail invoiceItem = (from tbl in objData.tblPurchaseInvoiceDetails where tbl.PINo == invoice.PINo && tbl.IsDelete == false && tbl.ProductCode == item.ProductCode select tbl).FirstOrDefault(); if (invoiceItem != null) { invoiceItem.Amount = item.Amount; invoiceItem.BatchNo = item.BatchNo; invoiceItem.ExpiryDate = item.ExpiryDate; invoiceItem.InvoicePrice = item.InvoicePrice; invoiceItem.InvoiceQty = item.InvoiceQty; invoiceItem.PINo = item.PurchaseInvoiceNo; } else { invoiceItem = new tblPurchaseInvoiceDetail() { PINo = invoice.PINo, ProductCode = item.ProductCode, InvoiceQty = item.InvoiceQty, InvoicePrice = item.InvoicePrice, Amount = item.Amount, BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, IsDelete = false }; objData.tblPurchaseInvoiceDetails.InsertOnSubmit(invoiceItem); } tblPurchaseOrderDetail orderItem = (from tbl in objData.tblPurchaseOrderDetails where tbl.IsDelete == false && tbl.PO_Id == invoice.PONo && tbl.Product_Id == item.ProductCode select tbl).FirstOrDefault(); if (orderItem != null) { if (orderItem.Quantity == item.InvoiceQty) { flagISPOComplete = true; } else { flagISPOComplete = false; } orderItem.InvoiceQuantity = item.InvoiceQty; } tblStockDetail stockItem = (from tbl in objData.tblStockDetails where tbl.IsDelete == false && tbl.TransactionType.Equals("PInvoice") && Convert.ToInt32(tbl.DocumentNo) == invoice.PINo && tbl.ProductId == Convert.ToInt32(item.ProductCode) select tbl).FirstOrDefault(); if (stockItem != null) { stockItem.ProductId = Convert.ToInt32(item.ProductCode); stockItem.InwardQty = item.InvoiceQty; stockItem.InwardPrice = item.InvoicePrice; stockItem.BatchNo = item.BatchNo; stockItem.ExpiryDate = item.ExpiryDate; stockItem.InwardAmount = item.Amount; } else { stockItem = new tblStockDetail() { BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, InwardPrice = item.InvoicePrice, InwardQty = item.InvoiceQty, DocumentNo = invoice.PINo, IsDelete = false, ProductId = Convert.ToInt32(item.ProductCode), TransactionType = "PInvoice", InwardAmount = item.Amount }; } } #endregion #region Update Status of Order and Transaction tblCustomerTransaction transact = (from tbl in objData.tblCustomerTransactions where tbl.SupplierId == invoice.SupplierId && tbl.IsDelete == false && tbl.TransactionDocNo == invoice.PINo && tbl.TransactionType.Equals("PInvoice") select tbl).FirstOrDefault(); if (transact != null) { transact.BillAmount = invoice.Amount; } tblPurchaseOrder orderMain = (from tbl in objData.tblPurchaseOrders where tbl.IsDelete == false && tbl.PO_Id == invoice.PONo select tbl).FirstOrDefault(); if (orderMain != null) { if (GetPOProductForEdit(Convert.ToInt32(invoice.PONo)).Count == lst.Count) { flagISPOComplete = true; } else { flagISPOComplete = false; } orderMain.IsPOComplete = flagISPOComplete; } objExistInvoice.Amount = invoice.Amount; objExistInvoice.Discount = invoice.Discount; objExistInvoice.PIDate = invoice.PIDate; objExistInvoice.Tax1 = invoice.Tax1; objExistInvoice.Tax2 = invoice.Tax2; objData.SubmitChanges(); #endregion } else { ///Specifies that Current Invoice with PO foreach (EntityPurchaseInvoiceDetails item in lst) { } } } else if (objExistInvoice.PONo > 0) { List<tblPurchaseInvoiceDetail> lstExistedItems = (from tbl in objData.tblPurchaseInvoiceDetails where tbl.PINo == invoice.PINo && tbl.IsDelete == false select tbl).ToList(); if (lstExistedItems.Count > lst.Count) { foreach (tblPurchaseInvoiceDetail item in lstExistedItems) { int cnt = (from tbl in lst where tbl.ProductCode == item.ProductCode && tbl.PurchaseInvoiceNo == item.PINo select tbl).Count(); if (cnt == 0) { item.IsDelete = true; } tblPurchaseOrderDetail objOrder = (from tbl in objData.tblPurchaseOrderDetails join tblPurchaseInv in objData.tblPurchaseInvoices on tbl.PO_Id equals tblPurchaseInv.PONo where tblPurchaseInv.PINo == item.PINo && tbl.IsDelete == false && tbl.Product_Id == item.ProductCode select tbl).FirstOrDefault(); if (objOrder != null) { objOrder.InvoiceQuantity = 0; } } objData.SubmitChanges(); } if (invoice.PONo > 0) { #region Update Invoice Details foreach (EntityPurchaseInvoiceDetails item in lst) { tblPurchaseInvoiceDetail invoiceItem = (from tbl in objData.tblPurchaseInvoiceDetails where tbl.PINo == invoice.PINo && tbl.IsDelete == false && tbl.ProductCode == item.ProductCode select tbl).FirstOrDefault(); if (invoiceItem != null) { invoiceItem.Amount = item.Amount; invoiceItem.BatchNo = item.BatchNo; invoiceItem.ExpiryDate = item.ExpiryDate; invoiceItem.InvoicePrice = item.InvoicePrice; invoiceItem.InvoiceQty = item.InvoiceQty; invoiceItem.PINo = item.PurchaseInvoiceNo; } else { invoiceItem = new tblPurchaseInvoiceDetail() { PINo = invoice.PINo, ProductCode = item.ProductCode, InvoiceQty = item.InvoiceQty, InvoicePrice = item.InvoicePrice, Amount = item.Amount, BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, IsDelete = false }; objData.tblPurchaseInvoiceDetails.InsertOnSubmit(invoiceItem); } tblPurchaseOrderDetail orderItem = (from tbl in objData.tblPurchaseOrderDetails where tbl.IsDelete == false && tbl.PO_Id == invoice.PONo && tbl.Product_Id == item.ProductCode select tbl).FirstOrDefault(); if (orderItem != null) { if (orderItem.Quantity == item.InvoiceQty) { flagISPOComplete = true; } else { flagISPOComplete = false; } orderItem.InvoiceQuantity = item.InvoiceQty; } tblStockDetail stockItem = (from tbl in objData.tblStockDetails where tbl.IsDelete == false && tbl.TransactionType.Equals("PInvoice") && Convert.ToInt32(tbl.DocumentNo) == invoice.PINo && tbl.ProductId == Convert.ToInt32(item.ProductCode) select tbl).FirstOrDefault(); if (stockItem != null) { stockItem.ProductId = Convert.ToInt32(item.ProductCode); stockItem.InwardQty = item.InvoiceQty; stockItem.InwardPrice = item.InvoicePrice; stockItem.BatchNo = item.BatchNo; stockItem.ExpiryDate = item.ExpiryDate; stockItem.InwardAmount = item.Amount; } else { stockItem = new tblStockDetail() { BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, InwardPrice = item.InvoicePrice, InwardQty = item.InvoiceQty, DocumentNo = invoice.PINo, IsDelete = false, ProductId = Convert.ToInt32(item.ProductCode), TransactionType = "PInvoice", InwardAmount = item.Amount }; } } #endregion #region Update Status of PO and Transaction Update tblCustomerTransaction transact = (from tbl in objData.tblCustomerTransactions where tbl.SupplierId == invoice.SupplierId && tbl.IsDelete == false && tbl.TransactionDocNo == invoice.PINo && tbl.TransactionType.Equals("PInvoice") select tbl).FirstOrDefault(); if (transact != null) { transact.BillAmount = invoice.Amount; } tblPurchaseOrder orderMain = (from tbl in objData.tblPurchaseOrders where tbl.IsDelete == false && tbl.PO_Id == invoice.PONo select tbl).FirstOrDefault(); if (orderMain != null) { if (GetPOProduct(Convert.ToInt32(invoice.PONo)).Count == lst.Count) { flagISPOComplete = true; } else { flagISPOComplete = false; } orderMain.IsPOComplete = flagISPOComplete; } objExistInvoice.Amount = invoice.Amount; objExistInvoice.Discount = invoice.Discount; objExistInvoice.PIDate = invoice.PIDate; objExistInvoice.Tax1 = invoice.Tax1; objExistInvoice.Tax2 = invoice.Tax2; objData.SubmitChanges(); #endregion } else { ///Specifies that Existing Invoice With PO and Current Not With PO #region Update Invoice Details foreach (EntityPurchaseInvoiceDetails item in lst) { tblPurchaseInvoiceDetail invoiceItem = (from tbl in objData.tblPurchaseInvoiceDetails where tbl.PINo == invoice.PINo && tbl.IsDelete == false && tbl.ProductCode == item.ProductCode select tbl).FirstOrDefault(); if (invoiceItem != null) { invoiceItem.Amount = item.Amount; invoiceItem.BatchNo = item.BatchNo; invoiceItem.ExpiryDate = item.ExpiryDate; invoiceItem.InvoicePrice = item.InvoicePrice; invoiceItem.InvoiceQty = item.InvoiceQty; invoiceItem.PINo = item.PurchaseInvoiceNo; } else { invoiceItem = new tblPurchaseInvoiceDetail() { PINo = invoice.PINo, ProductCode = item.ProductCode, InvoiceQty = item.InvoiceQty, InvoicePrice = item.InvoicePrice, Amount = item.Amount, BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, IsDelete = false }; objData.tblPurchaseInvoiceDetails.InsertOnSubmit(invoiceItem); } tblPurchaseOrderDetail orderItem = (from tbl in objData.tblPurchaseOrderDetails where tbl.IsDelete == false && tbl.PO_Id == objExistInvoice.PONo && tbl.Product_Id == item.ProductCode select tbl).FirstOrDefault(); if (orderItem != null) { orderItem.InvoiceQuantity = 0; } tblStockDetail stockItem = (from tbl in objData.tblStockDetails where tbl.IsDelete == false && tbl.TransactionType.Equals("PInvoice") && Convert.ToInt32(tbl.DocumentNo) == invoice.PINo && tbl.ProductId == Convert.ToInt32(item.ProductCode) select tbl).FirstOrDefault(); if (stockItem != null) { stockItem.ProductId = Convert.ToInt32(item.ProductCode); stockItem.InwardQty = item.InvoiceQty; stockItem.InwardPrice = item.InvoicePrice; stockItem.BatchNo = item.BatchNo; stockItem.ExpiryDate = item.ExpiryDate; stockItem.InwardAmount = item.Amount; } else { stockItem = new tblStockDetail() { BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, InwardPrice = item.InvoicePrice, InwardQty = item.InvoiceQty, DocumentNo = invoice.PINo, IsDelete = false, ProductId = Convert.ToInt32(item.ProductCode), TransactionType = "PInvoice", InwardAmount = item.Amount }; } } #endregion #region Update Status of PO and Transaction Update tblCustomerTransaction transact = (from tbl in objData.tblCustomerTransactions where tbl.SupplierId == invoice.SupplierId && tbl.IsDelete == false && tbl.TransactionDocNo == invoice.PINo && tbl.TransactionType.Equals("PInvoice") select tbl).FirstOrDefault(); if (transact != null) { transact.BillAmount = invoice.Amount; } tblPurchaseOrder orderMain = (from tbl in objData.tblPurchaseOrders where tbl.IsDelete == false && tbl.PO_Id == objExistInvoice.PONo select tbl).FirstOrDefault(); if (orderMain != null) { orderMain.IsPOComplete = false; } objExistInvoice.Amount = invoice.Amount; objExistInvoice.Discount = invoice.Discount; objExistInvoice.PIDate = invoice.PIDate; objExistInvoice.Tax1 = invoice.Tax1; objExistInvoice.Tax2 = invoice.Tax2; objExistInvoice.PONo = invoice.PONo; objData.SubmitChanges(); #endregion } } } i++; } catch (Exception ex) { i = 0; throw ex; } return i; }
public int InsertInvoice(EntityICUInvoice entInvoice, List <EntityICUInvoiceDetail> lstInvoice, bool IsCash) { try { int?ICUInvoiceNo = 0; objData.STP_InserttblICUInvoiceDischarge(Convert.ToDateTime(entInvoice.AllocationDate), Convert.ToInt32(entInvoice.PatientId) , Convert.ToDecimal(entInvoice.NetAmount), Convert.ToDecimal(entInvoice.TotalAmount), Convert.ToInt32(entInvoice.Discount), Convert.ToInt32(entInvoice.Tax1), Convert.ToInt32(entInvoice.Tax2), false, Convert.ToBoolean(entInvoice.Is_ShiftIPD), Convert.ToDateTime(entInvoice.ShiftDate), ref ICUInvoiceNo); foreach (EntityICUInvoiceDetail item in lstInvoice) { tblICUInvoiceDischargeDetail obj = new tblICUInvoiceDischargeDetail() { ICUBedAllocId = entInvoice.ICUBedAllocId, IsDelete = false, ChargesId = item.ChargesId, Amount = item.Amount, NoofDays = item.NoofDays, Charge = item.Charges, Quantity = item.Quantity, ICUInvoiceNo = ICUInvoiceNo, }; objData.tblICUInvoiceDischargeDetails.InsertOnSubmit(obj); } int TransactionId = new PatientInvoiceBLL().GetTransactionId(); if (IsCash) { tblCustomerTransaction objDebit = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = true, TransactionDocNo = ICUInvoiceNo, TransactionType = "ICUInvoice", BillAmount = entInvoice.NetAmount, PayAmount = 0, PatientId = entInvoice.PatientId, IsDelete = false, ReceiptDate = entInvoice.AllocationDate, }; objData.tblCustomerTransactions.InsertOnSubmit(objDebit); //objData.SubmitChanges(); tblCustomerTransaction objCrReceipt = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = true, TransactionDocNo = ICUInvoiceNo, TransactionType = "ICUInvoice", PayAmount = entInvoice.NetAmount, BillAmount = 0, PatientId = entInvoice.PatientId, IsDelete = false, ReceiptDate = entInvoice.AllocationDate, }; objData.tblCustomerTransactions.InsertOnSubmit(objCrReceipt); //objData.SubmitChanges(); } else { tblCustomerTransaction objDebit = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = false, TransactionDocNo = ICUInvoiceNo, TransactionType = "ICUInvoice", BillAmount = entInvoice.NetAmount, PatientId = entInvoice.PatientId, IsDelete = false, ReceiptDate = entInvoice.AllocationDate, }; objData.tblCustomerTransactions.InsertOnSubmit(objDebit); //objData.SubmitChanges(); } objData.SubmitChanges(); return(1); } catch (Exception ex) { throw ex; } }
public int UpdateInvoice(List <EntityICUInvoiceDetail> lstUpdate, EntityICUInvoice entInvoice) { int count = 0; try { tblICUInvoiceDischarge obj = (from tbl in objData.tblICUInvoiceDischarges where tbl.IsDelete == false && tbl.ICUInvoiceNo == entInvoice.InvoiceNo select tbl).FirstOrDefault(); if (obj != null) { obj.Discount = entInvoice.Discount; obj.Vat = Convert.ToInt32(entInvoice.Tax1); obj.ServiceTax = Convert.ToInt32(entInvoice.Tax2); obj.TotalAmount = entInvoice.TotalAmount; obj.NetAmount = entInvoice.NetAmount; } foreach (EntityICUInvoiceDetail item in lstUpdate) { if (item.ICUSRlNo == 0) { tblICUInvoiceDischargeDetail objDetails = new tblICUInvoiceDischargeDetail() { ICUBedAllocId = entInvoice.ICUBedAllocId, IsDelete = false, ChargesId = item.ChargesId, Amount = item.Amount, NoofDays = item.NoofDays, Charge = item.Charges, Quantity = item.Quantity, ICUInvoiceNo = entInvoice.InvoiceNo, }; objData.tblICUInvoiceDischargeDetails.InsertOnSubmit(objDetails); } else { tblICUInvoiceDischargeDetail objDetails = (from tbl in objData.tblICUInvoiceDischargeDetails where tbl.IsDelete == false && tbl.ICUSRlNo == item.ICUSRlNo select tbl).FirstOrDefault(); if (objDetails != null) { objDetails.Amount = item.Amount; objDetails.Charge = item.Charges; objDetails.ChargesId = item.ChargesId; objDetails.NoofDays = item.NoofDays; objDetails.Quantity = item.Quantity; objDetails.IsDelete = item.IsDelete; objDetails.ICUBedAllocId = item.ICUBedAllocId; } } } List <tblCustomerTransaction> objCust = (from tbl in objData.tblCustomerTransactions where tbl.IsDelete == false && tbl.TransactionDocNo == entInvoice.InvoiceNo && tbl.TransactionType == "ICUInvoice" select tbl).ToList(); if (obj != null && objCust != null) { if (objCust.Count == 1) { if (entInvoice.IsCash.Value) { tblCustomerTransaction objC = new tblCustomerTransaction() { PayAmount = entInvoice.NetAmount, ReceiptDate = entInvoice.AllocationDate, IsCash = entInvoice.IsCash, IsDelete = false, TransactionDocNo = entInvoice.ICUBedAllocId, TransactionId = objCust[0].TransactionId, TransactionType = "ICUInvoice", PatientId = entInvoice.PatientId, }; objData.tblCustomerTransactions.InsertOnSubmit(objC); foreach (tblCustomerTransaction item in objCust) { item.BillAmount = entInvoice.NetAmount; item.ReceiptDate = entInvoice.AllocationDate; item.IsCash = entInvoice.IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { item.PayAmount = entInvoice.NetAmount; } } } else { foreach (tblCustomerTransaction item in objCust) { item.BillAmount = entInvoice.NetAmount; item.ReceiptDate = entInvoice.AllocationDate; item.IsCash = entInvoice.IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { item.PayAmount = entInvoice.NetAmount; } } } } else { foreach (tblCustomerTransaction item in objCust) { item.BillAmount = entInvoice.NetAmount; item.ReceiptDate = entInvoice.AllocationDate; item.IsCash = entInvoice.IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { item.PayAmount = entInvoice.NetAmount; } } } } objData.SubmitChanges(); count++; } catch (Exception ex) { count = 0; throw ex; } return(count); }
public int InsertPurchaseInvoice(EntityPurchaseInvoice entPurchaseInvoice, List<EntityPurchaseInvoiceDetails> lstInvoice) { try { int? id = 0; bool flagISPOComplete = false; objData.STP_Insert_PurchaseInvoice(Convert.ToDateTime(entPurchaseInvoice.PIDate), Convert.ToInt32(entPurchaseInvoice.PONo), Convert.ToInt32(entPurchaseInvoice.SupplierId), false, Convert.ToDecimal(entPurchaseInvoice.Amount), Convert.ToInt32(entPurchaseInvoice.Tax1), Convert.ToInt32(entPurchaseInvoice.Tax2), Convert.ToInt32(entPurchaseInvoice.Discount), ref id); foreach (EntityPurchaseInvoiceDetails item in lstInvoice) { tblPurchaseInvoiceDetail obj = new tblPurchaseInvoiceDetail() { PINo = id, ProductCode = item.ProductCode, InvoiceQty = item.InvoiceQty, InvoicePrice = item.InvoicePrice, Amount = item.Amount, BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, IsDelete = false }; tblPurchaseOrderDetail orderItem = (from tbl in objData.tblPurchaseOrderDetails where tbl.IsDelete == false && tbl.PO_Id == entPurchaseInvoice.PONo && tbl.Product_Id == item.ProductCode select tbl).FirstOrDefault(); if (orderItem != null) { if (orderItem.Quantity == item.InvoiceQty) { flagISPOComplete = true; } else { flagISPOComplete = false; } orderItem.InvoiceQuantity = item.InvoiceQty; } tblStockDetail objStock = new tblStockDetail() { BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, InwardPrice = item.InvoicePrice, InwardQty = item.InvoiceQty, DocumentNo = id, IsDelete = false, ProductId = Convert.ToInt32(item.ProductCode), TransactionType = "PInvoice", InwardAmount = item.Amount }; objData.tblStockDetails.InsertOnSubmit(objStock); objData.tblPurchaseInvoiceDetails.InsertOnSubmit(obj); } int TId = new PatientInvoiceBLL().GetTransactionId(); tblPurchaseOrder po = (from tbl in objData.tblPurchaseOrders where tbl.IsDelete == false && tbl.PO_Id == entPurchaseInvoice.PONo select tbl).FirstOrDefault(); if (po != null) { List<EntityProduct> lstProducts = GetPOProduct(Convert.ToInt32(entPurchaseInvoice.PONo)); if (lstProducts.Count == lstInvoice.Count) { flagISPOComplete = true; } else { flagISPOComplete = false; } po.IsPOComplete = flagISPOComplete; } tblCustomerTransaction objCust = new tblCustomerTransaction() { BillAmount = entPurchaseInvoice.Amount, IsCash = false, IsDelete = false, SupplierId = entPurchaseInvoice.SupplierId, ReceiptDate = entPurchaseInvoice.PIDate, TransactionDocNo = id, TransactionId = TId, TransactionType = "PInvoice" }; objData.tblCustomerTransactions.InsertOnSubmit(objCust); objData.SubmitChanges(); } catch (Exception ex) { throw ex; } return 1; }
public int UpdateInvoice(EntityPatientInvoice entInvoice, List <EntityInvoiceDetails> lst) { int i = 0; try { tblPatientInvoice objTest = (from tbl in objData.tblPatientInvoices where tbl.IsDelete == false && tbl.BillNo == entInvoice.BillNo select tbl).FirstOrDefault(); if (objTest != null) { objTest.Amount = entInvoice.Amount; objTest.BillType = entInvoice.BillType; objTest.NetAmount = entInvoice.NetAmount; objTest.TotalAdvance = entInvoice.TotalAdvance; objTest.BalanceAmount = entInvoice.BalanceAmount; objTest.ReceivedAmount = entInvoice.ReceivedAmount; objTest.RefundAmount = entInvoice.RefundAmount; objTest.FixedDiscount = entInvoice.FixedDiscount; objTest.PreparedByName = entInvoice.PreparedByName; //objTest.Service = entInvoice.Service; //objTest.Vat = entInvoice.Vat; if (entInvoice.BillType != "Estimated") { int TransactionId = GetTransactionId(); if (entInvoice.IsCash) { tblCustomerTransaction objDebit = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = true, TransactionDocNo = entInvoice.BillNo, TransactionType = "Invoice", BillAmount = entInvoice.NetAmount, PayAmount = entInvoice.NetAmount, Discount = entInvoice.FixedDiscount, PatientId = entInvoice.PatientId, PreparedByName = entInvoice.PreparedByName, IsDelete = false, ReceiptDate = entInvoice.BillDate, }; objData.tblCustomerTransactions.InsertOnSubmit(objDebit); } else { tblCustomerTransaction objDebit = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = false, TransactionDocNo = entInvoice.BillNo, TransactionType = "Invoice", BillAmount = entInvoice.NetAmount, Discount = entInvoice.FixedDiscount, PatientId = entInvoice.PatientId, PreparedByName = entInvoice.PreparedByName, IsDelete = false, ReceiptDate = entInvoice.BillDate, }; objData.tblCustomerTransactions.InsertOnSubmit(objDebit); //objData.SubmitChanges(); } } else { List <tblCustomerTransaction> objCust = (from tbl in objData.tblCustomerTransactions where tbl.IsDelete == false && tbl.TransactionDocNo == entInvoice.BillNo && tbl.TransactionType == "Invoice" select tbl).ToList(); if (objCust != null) { if (objCust.Count == 1) { if (entInvoice.IsCash) { tblCustomerTransaction objC = new tblCustomerTransaction() { PayAmount = entInvoice.NetAmount, BillAmount = entInvoice.NetAmount, Discount = entInvoice.FixedDiscount, ReceiptDate = entInvoice.BillDate, IsCash = entInvoice.IsCash, IsDelete = false, TransactionDocNo = entInvoice.BillNo, TransactionId = objCust[0].TransactionId, TransactionType = "Invoice", PatientId = entInvoice.PatientId, PreparedByName = entInvoice.PreparedByName, }; objData.tblCustomerTransactions.InsertOnSubmit(objC); foreach (tblCustomerTransaction item in objCust) { item.BillAmount = entInvoice.NetAmount; item.ReceiptDate = entInvoice.BillDate; item.IsCash = entInvoice.IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { item.PayAmount = 0; } } } else { foreach (tblCustomerTransaction item in objCust) { item.BillAmount = entInvoice.NetAmount; item.ReceiptDate = entInvoice.BillDate; item.IsCash = entInvoice.IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { if (item.PayAmount > 0) { item.PayAmount = entInvoice.NetAmount; } else { item.PayAmount = 0; } } } } } else { foreach (tblCustomerTransaction item in objCust) { item.BillAmount = entInvoice.NetAmount; item.ReceiptDate = entInvoice.BillDate; item.IsCash = entInvoice.IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { if (item.PayAmount > 0) { item.PayAmount = entInvoice.NetAmount; } else { item.PayAmount = 0; } } } } } } foreach (EntityInvoiceDetails item in lst) { if (item.BillSRNo > 0) { tblPatientInvoiceDetail cnt = (from tbl in objData.tblPatientInvoiceDetails where tbl.BillNo == item.BillNo && tbl.BillSRNo == item.BillSRNo && tbl.IsDelete == false select tbl).FirstOrDefault(); if (cnt != null) { cnt.BillNo = entInvoice.BillNo; cnt.Quantity = item.Quantity; cnt.NoOfDays = item.NoOfDays; cnt.Remarks = item.Remarks; cnt.Amount = item.Amount; cnt.ChargePerDay = item.PerDayCharge; cnt.OtherChargesId = item.OtherChargesId; cnt.IsDelete = item.IsDelete; } } else { tblPatientInvoiceDetail objNewAdded = new tblPatientInvoiceDetail() { BillNo = entInvoice.BillNo, BedAllocId = item.BedAllocId, OTAllocId = item.OTBedAllocId, DocAllocId = item.DocAllocationId, OtherChargesId = item.OtherChargesId, Amount = item.Amount, ChargePerDay = item.PerDayCharge, NetAmount = item.NetAmount, Remarks = item.Remarks, NoOfDays = item.NoOfDays, Quantity = item.Quantity, IsDelete = false }; objData.tblPatientInvoiceDetails.InsertOnSubmit(objNewAdded); if (entInvoice.BillType == "Original") { if (objNewAdded.BedAllocId > 0) { int p = new BedStatusBLL().DischargePatient(entInvoice.PatientId, entInvoice.BillDate); } } } } tblPatientAdmitDetail admit = (from tbl in objData.tblPatientAdmitDetails where tbl.IsDelete == false && tbl.AdmitId == entInvoice.PatientId select tbl).FirstOrDefault(); if (entInvoice.BillType == "Estimated") { if (admit != null) { admit.IsDischarge = false; } } if (entInvoice.BillType == "Original") { if (admit != null) { admit.IsDischarge = true; } } objData.SubmitChanges(); } i++; } catch (Exception ex) { i = 0; throw ex; } return(i); }
public int UpdateOPDRefund(EntityPatientInvoice entInvoice, List <EntityInvoiceDetails> lst) { int i = 0; try { tblPatientInvoice objTest = (from tbl in objData.tblPatientInvoices where tbl.IsDelete == false && tbl.BillNo == entInvoice.BillNo select tbl).FirstOrDefault(); if (objTest != null) { objTest.Amount = 0; objTest.NetAmount = 0; objTest.ReceivedAmount = 0; objTest.RefundAmount = entInvoice.NetAmount; objTest.TotalAdvance = 0; tblCustomerTransaction objCust = (from tbl in objData.tblCustomerTransactions where tbl.IsDelete == false && tbl.TransactionDocNo == entInvoice.BillNo && tbl.TransactionType == "Invoice" select tbl).FirstOrDefault(); if (objCust != null) { objCust.PayAmount = 0; objCust.BillAmount = 0; } foreach (EntityInvoiceDetails item in lst) { if (item.BillSRNo > 0) { tblPatientInvoiceDetail cnt = (from tbl in objData.tblPatientInvoiceDetails where tbl.BillNo == item.BillNo && tbl.BillSRNo == item.BillSRNo && tbl.IsDelete == false select tbl).FirstOrDefault(); if (cnt != null) { cnt.BillNo = entInvoice.BillNo; cnt.ChargePerDay = 0; cnt.NetAmount = 0; cnt.Amount = 0; cnt.OtherChargesId = item.OtherChargesId; cnt.IsDelete = item.IsDelete; } objData.SubmitChanges(); } } objData.SubmitChanges(); } i++; } catch (Exception ex) { i = 0; throw ex; } return(i); }
public int InsertInvoice(EntityPatientInvoice entInvoice, List <EntityInvoiceDetails> lstInvoice, bool IsCash) { try { int?BillNo = 0; objData.STP_InsertInvoice(Convert.ToDateTime(entInvoice.BillDate), ref BillNo, Convert.ToString(entInvoice.BillType), Convert.ToInt32(entInvoice.PatientId), Convert.ToString(entInvoice.PreparedByName), Convert.ToDecimal(entInvoice.Amount), Convert.ToDecimal(entInvoice.Discount), //Convert.ToDecimal(entInvoice.Vat), Convert.ToDecimal(entInvoice.Service), Convert.ToDecimal(entInvoice.NetAmount), Convert.ToDecimal(entInvoice.TotalAdvance), Convert.ToDecimal(entInvoice.BalanceAmount), Convert.ToDecimal(entInvoice.ReceivedAmount), Convert.ToDecimal(entInvoice.RefundAmount), true, Convert.ToDecimal(entInvoice.FixedDiscount)); foreach (EntityInvoiceDetails entInvoiceDetails in lstInvoice) { tblPatientInvoiceDetail obj = new tblPatientInvoiceDetail() { BillNo = BillNo, BedAllocId = entInvoiceDetails.BedAllocId, OTAllocId = entInvoiceDetails.OTBedAllocId, DocAllocId = entInvoiceDetails.DocAllocationId, OtherChargesId = entInvoiceDetails.OtherChargesId, Amount = entInvoiceDetails.Amount, NetAmount = entInvoice.NetAmount, ChargePerDay = entInvoiceDetails.PerDayCharge, Remarks = entInvoiceDetails.Remarks, NoOfDays = entInvoiceDetails.NoOfDays, Quantity = entInvoiceDetails.Quantity, IsDelete = false }; objData.tblPatientInvoiceDetails.InsertOnSubmit(obj); if (entInvoice.BillType == "Original") { if (entInvoiceDetails.BedAllocId > 0) { int i = new BedStatusBLL().DischargePatient(entInvoice.PatientId, entInvoice.BillDate); } } } //int i = new BedStatusBLL().DischargePatient(entInvoiceDetails.PatientID, entInvoice.BillDate); if (entInvoice.BillType != "Estimated") { int TransactionId = GetTransactionId(); if (IsCash) { tblCustomerTransaction objDebit = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = true, TransactionDocNo = BillNo, TransactionType = "Invoice", BillAmount = entInvoice.NetAmount, PayAmount = entInvoice.NetAmount, Discount = entInvoice.FixedDiscount, PatientId = entInvoice.PatientId, PreparedByName = entInvoice.PreparedByName, IsDelete = false, ReceiptDate = entInvoice.BillDate, }; objData.tblCustomerTransactions.InsertOnSubmit(objDebit); //objData.SubmitChanges(); //tblCustomerTransaction objCrReceipt = new tblCustomerTransaction() //{ // TransactionId = TransactionId, // IsCash = true, // TransactionDocNo = BillNo, // TransactionType = "Invoice", // PayAmount = entInvoice.NetAmount, // BillAmount=0, // PatientId = entInvoice.PatientId, // IsDelete = false, // ReceiptDate = entInvoice.BillDate, //}; //objData.tblCustomerTransactions.InsertOnSubmit(objCrReceipt); //objData.SubmitChanges(); } else { tblCustomerTransaction objDebit = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = false, TransactionDocNo = BillNo, TransactionType = "Invoice", BillAmount = entInvoice.NetAmount, Discount = entInvoice.FixedDiscount, PatientId = entInvoice.PatientId, PreparedByName = entInvoice.PreparedByName, IsDelete = false, ReceiptDate = entInvoice.BillDate, }; objData.tblCustomerTransactions.InsertOnSubmit(objDebit); //objData.SubmitChanges(); } } tblPatientAdmitDetail admit = (from tbl in objData.tblPatientAdmitDetails where tbl.IsDelete == false && tbl.IsDischarge == false && tbl.AdmitId == entInvoice.PatientId select tbl).FirstOrDefault(); if (entInvoice.BillType == "Estimated") { if (admit != null) { admit.IsDischarge = false; } } if (entInvoice.BillType == "Original") { if (admit != null) { admit.IsDischarge = true; } //if (admit != null && entInvoice.PatientType == "OPD") //{ // admit.IsDischarge = false; //} } objData.SubmitChanges(); return(1); } catch (Exception ex) { throw ex; } }
public int UpdateInvoice(List <EntityInvoiceDetails> lstEdited, List <EntityInvoiceDetails> lstUpdate) { try { tblPatientInvoice objTest = (from tbl in objData.tblPatientInvoices where tbl.IsDelete == false && tbl.BillNo == lstEdited[0].BillNo select tbl).FirstOrDefault(); List <EntityInvoiceDetails> lstTemp = new List <EntityInvoiceDetails>(); List <tblCustomerTransaction> objCust = (from tbl in objData.tblCustomerTransactions where tbl.IsDelete == false && tbl.TransactionDocNo == lstEdited[0].BillNo && tbl.TransactionType == "Invoice" select tbl).ToList(); if (objTest != null && objCust != null) { if (objCust.Count == 1) { if (lstEdited[0].IsCash) { tblCustomerTransaction objC = new tblCustomerTransaction() { PayAmount = lstEdited[0].NetAmount, ReceiptDate = lstEdited[0].BillDate, IsCash = lstEdited[0].IsCash, IsDelete = false, TransactionDocNo = lstEdited[0].BillNo, TransactionId = objCust[0].TransactionId, TransactionType = "Invoice", PatientId = lstEdited[0].PatientID, }; objData.tblCustomerTransactions.InsertOnSubmit(objC); foreach (tblCustomerTransaction item in objCust) { item.BillAmount = lstEdited[0].NetAmount; item.ReceiptDate = lstEdited[0].BillDate; item.IsCash = lstEdited[0].IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { item.PayAmount = 0; } } } else { foreach (tblCustomerTransaction item in objCust) { item.BillAmount = lstEdited[0].NetAmount; item.ReceiptDate = lstEdited[0].BillDate; item.IsCash = lstEdited[0].IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { if (item.PayAmount > 0) { item.PayAmount = lstEdited[0].NetAmount; } else { item.PayAmount = 0; } } } } } else { foreach (tblCustomerTransaction item in objCust) { item.BillAmount = lstEdited[0].NetAmount; item.ReceiptDate = lstEdited[0].BillDate; item.IsCash = lstEdited[0].IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { if (item.PayAmount > 0) { item.PayAmount = lstEdited[0].NetAmount; } else { item.PayAmount = 0; } } } } objTest.BillDate = lstEdited[0].BillDate; objTest.Amount = lstEdited[0].Total; objTest.NetAmount = lstEdited[0].NetAmount; //objTest.Vat = lstEdited[0].Vat; objTest.Discount = lstEdited[0].Discount; //objTest.Service = lstEdited[0].Service; } foreach (EntityInvoiceDetails item in lstEdited) { int cnt = (from tbl in objData.tblPatientInvoiceDetails where tbl.BillNo == item.BillNo && tbl.OtherChargesId == item.OtherChargesId && tbl.IsDelete == false select tbl).ToList().Count; if (cnt == 0) { tblPatientInvoiceDetail objNewAdded = new tblPatientInvoiceDetail() { BillNo = lstEdited[0].BillNo, BedAllocId = item.BedAllocId, OTAllocId = item.OTBedAllocId, DocAllocId = item.DocAllocationId, OtherChargesId = item.OtherChargesId, Amount = item.Amount, NetAmount = item.NetAmount, IsDelete = false }; objData.tblPatientInvoiceDetails.InsertOnSubmit(objNewAdded); objData.SubmitChanges(); } else { lstTemp.Add(item); } } foreach (EntityInvoiceDetails item in lstUpdate) { tblPatientInvoiceDetail cnt = (from tbl in objData.tblPatientInvoiceDetails where tbl.BillNo == item.BillNo && tbl.OtherChargesId == item.OtherChargesId select tbl).FirstOrDefault(); if (cnt != null) { int checkExist = (from tbl in lstTemp where tbl.OtherChargesId == item.OtherChargesId select tbl).ToList().Count; if (checkExist == 0) { cnt.IsDelete = true; } } } objData.SubmitChanges(); return(1); } catch (Exception ex) { throw ex; } }
public void InsertData(tblInsuranceClaim tblins, EntityCustomerTransaction objPatient, EntityCustomerTransaction objBank, bool IsCash, bool IsNeft, bool IsCheque) { try { tblInsuranceClaim objcurrent = (from tbl in objData.tblInsuranceClaims where tbl.ClaimId == tblins.ClaimId select tbl).FirstOrDefault(); if (objcurrent != null) { objcurrent.ApprovedAmount = tblins.ApprovedAmount; objcurrent.ApprovedDate = tblins.ApprovedDate; objcurrent.IsApproved = tblins.IsApproved; objcurrent.TDS = tblins.TDS; //objcurrent.Discount = tblins.Discount; int TransactionId = new PatientInvoiceBLL().GetTransactionId(); if (IsCash) { tblCustomerTransaction tblcust = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = true, ISCheque = false, TransactionDocNo = objPatient.TransactionDocNo, TransactionType = "Claim", BillAmount = 0, PayAmount = objPatient.PayAmount, PatientId = objPatient.PatientId, IsDelete = false, ReceiptDate = objPatient.ReceiptDate, }; objData.tblCustomerTransactions.InsertOnSubmit(tblcust); } else if (IsNeft) { tblCustomerTransaction tblcust = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = false, ISCheque = false, TransactionDocNo = objPatient.TransactionDocNo, TransactionType = "Claim", BillAmount = 0, PayAmount = objPatient.PayAmount, PatientId = objPatient.PatientId, IsDelete = false, ReceiptDate = objPatient.ReceiptDate, }; objData.tblCustomerTransactions.InsertOnSubmit(tblcust); tblCustomerTransaction tblcustBank = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = false, ISCheque = false, TransactionDocNo = objBank.TransactionDocNo, TransactionType = "Claim", BillAmount = objBank.BillAmount, PayAmount = 0, PatientId = 0, IsDelete = false, ReceiptDate = objBank.ReceiptDate, BankId = objBank.BankId }; objData.tblCustomerTransactions.InsertOnSubmit(tblcustBank); } else if (IsCheque) { tblCustomerTransaction tblcust = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = false, ISCheque = true, TransactionDocNo = objPatient.TransactionDocNo, TransactionType = "Claim", BillAmount = 0, PayAmount = objPatient.PayAmount, PatientId = objPatient.PatientId, IsDelete = false, ReceiptDate = objPatient.ReceiptDate, }; objData.tblCustomerTransactions.InsertOnSubmit(tblcust); tblCustomerTransaction tblcustnew = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = false, ISCheque = true, TransactionDocNo = objBank.TransactionDocNo, TransactionType = "Claim", BillAmount = objBank.BillAmount, PayAmount = 0, PatientId = 0, IsDelete = false, ReceiptDate = objBank.ReceiptDate, BankName = objBank.BankName, ChequeDate = objBank.ChequeDate, ChequeNo = objBank.ChequeNo }; objData.tblCustomerTransactions.InsertOnSubmit(tblcustnew); } } objData.SubmitChanges(); } catch (Exception) { throw; } }
public int Update(EntityDebitNote lstEdited, List <EntityDebitNoteDetails> lst) { int i = 0; try { tblDebitNote objTest = (from tbl in objData.tblDebitNotes where tbl.IsDelete == false && tbl.DNNo == lstEdited.DNNo select tbl).FirstOrDefault(); if (objTest != null) { objTest.Amount = lstEdited.Amount; objTest.NetAmount = lstEdited.NetAmount; objTest.SupplierId = lstEdited.SupplierId; objTest.DNDate = lstEdited.DNDate; objTest.Discount = lstEdited.Discount; objTest.Tax1 = lstEdited.Tax1; objTest.Tax2 = lstEdited.Tax2; } foreach (EntityDebitNoteDetails item in lst) { if (item.DNSrNo == 0) { tblDebitNoteDetail objNewAdded = new tblDebitNoteDetail() { DNNo = lstEdited.DNNo, ProductCode = item.ProductCode, Quantity = item.Quantity, Price = item.Price, Amount = item.Amount, BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, IsDelete = false }; objData.tblDebitNoteDetails.InsertOnSubmit(objNewAdded); tblStockDetail stock = new tblStockDetail() { ProductId = Convert.ToInt32(item.ProductCode), OpeningQty = 0, InwardQty = 0, InwardPrice = 0, InwardAmount = 0, BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, OutwardQty = item.Quantity, OutwardPrice = item.Price, OutwardAmount = item.Amount, TransactionType = "DebitNote", IsDelete = false, }; objData.tblStockDetails.InsertOnSubmit(stock); } else { tblDebitNoteDetail cnt = (from tbl in objData.tblDebitNoteDetails where tbl.IsDelete == false && tbl.DNSrNo == item.DNSrNo select tbl).FirstOrDefault(); if (cnt != null) { cnt.BatchNo = item.BatchNo; cnt.ExpiryDate = item.ExpiryDate; cnt.ProductCode = Convert.ToInt32(item.ProductCode); cnt.Quantity = item.Quantity; cnt.Price = item.Price; cnt.Amount = Convert.ToDecimal(item.Amount); cnt.IsDelete = item.IsDelete; } tblStockDetail stock = (from tbl in objData.tblStockDetails where tbl.IsDelete == false && tbl.DocumentNo == lstEdited.DNNo && tbl.ProductId == item.ProductCode && tbl.TransactionType.Equals("DebitNote") select tbl).FirstOrDefault(); if (stock != null) { stock.ProductId = Convert.ToInt32(item.ProductCode); stock.OpeningQty = 0; stock.InwardQty = 0; stock.InwardPrice = 0; stock.InwardAmount = 0; stock.BatchNo = item.BatchNo; stock.ExpiryDate = item.ExpiryDate; stock.OutwardQty = item.Quantity; stock.OutwardPrice = item.Price; stock.OutwardAmount = item.Amount; stock.IsDelete = Convert.ToBoolean(item.IsDelete); } } } #region Update Status of Order and Transaction tblCustomerTransaction transact = (from tbl in objData.tblCustomerTransactions where tbl.SupplierId == lstEdited.SupplierId && tbl.IsDelete == false && tbl.TransactionDocNo == lstEdited.DNNo && tbl.TransactionType.Equals("DebitNote") select tbl).FirstOrDefault(); if (transact != null) { transact.PayAmount = lstEdited.NetAmount; transact.ReceiptDate = lstEdited.DNDate; } objData.SubmitChanges(); #endregion i++; } catch (Exception ex) { i = 0; throw ex; } return(i); }
public int Update(List <TestAllocation> lst, tblTestInvoice obj, bool IsCash) { try { tblTestInvoice objTest = (from tbl in objData.tblTestInvoices where tbl.IsDelete == false && tbl.TestInvoiceNo == obj.TestInvoiceNo select tbl).FirstOrDefault(); List <TestAllocation> lstTemp = new List <TestAllocation>(); List <tblTestInvoiceDetail> lstCurrent = (from tbl in objData.tblTestInvoiceDetails where tbl.TestInvoiceId == obj.TestInvoiceNo && tbl.IsDelete == false select tbl).ToList(); List <tblCustomerTransaction> objCust = (from tbl in objData.tblCustomerTransactions where tbl.IsDelete == false && tbl.TransactionDocNo.Equals(Convert.ToString(obj.TestInvoiceNo)) && tbl.TransactionType.Equals("TestInvoice") select tbl).ToList(); if (objTest != null) { objTest.TestInvoiceDate = obj.TestInvoiceDate; objTest.Amount = obj.Amount; objTest.Discount = obj.Discount; objTest.PatientId = obj.PatientId; } if (objCust.Count == 1) { if (IsCash) { tblCustomerTransaction objC = new tblCustomerTransaction() { PayAmount = obj.Amount, ReceiptDate = obj.TestInvoiceDate, IsCash = IsCash, IsDelete = false, TransactionDocNo = obj.TestInvoiceNo, TransactionId = objCust[0].TransactionId, TransactionType = "TestInvoice", PatientId = obj.PatientId, BillAmount = 0 }; objData.tblCustomerTransactions.InsertOnSubmit(objC); foreach (tblCustomerTransaction item in objCust) { item.BillAmount = obj.Amount; item.ReceiptDate = obj.TestInvoiceDate; item.IsCash = IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { if (item.PayAmount > 0) { item.PayAmount = obj.Amount; } else { item.PayAmount = 0; } } } } else { foreach (tblCustomerTransaction item in objCust) { item.BillAmount = obj.Amount; item.ReceiptDate = obj.TestInvoiceDate; item.IsCash = IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { if (item.PayAmount > 0) { item.PayAmount = obj.Amount; } else { item.PayAmount = 0; } } } } } else { foreach (tblCustomerTransaction item in objCust) { item.BillAmount = obj.Amount; item.ReceiptDate = obj.TestInvoiceDate; item.IsCash = IsCash; if (item.IsCash == false) { if (item.PayAmount > 0) { item.IsDelete = true; } } else { if (item.PayAmount > 0) { item.PayAmount = obj.Amount; } else { item.PayAmount = 0; } } } } foreach (TestAllocation item in lst) { int cnt = (from tbl in objData.tblTestInvoiceDetails where tbl.TestInvoiceId == obj.TestInvoiceNo && tbl.TestId == item.TestId && tbl.IsDelete == false select tbl).ToList().Count; if (cnt == 0) { tblTestInvoiceDetail objNewAdded = new tblTestInvoiceDetail() { TestInvoiceId = obj.TestInvoiceNo, TestId = item.TestId, Charges = item.Charges, IsDelete = false, }; objData.tblTestInvoiceDetails.InsertOnSubmit(objNewAdded); objData.SubmitChanges(); } else { lstTemp.Add(item); } } foreach (tblTestInvoiceDetail item in lstCurrent) { int cnt = (from tbl in lst where tbl.TestInvoiceNo == item.TestInvoiceId && tbl.TestId == item.TestId select tbl).ToList().Count; if (cnt == 0) { int checkExist = (from tbl in lstTemp where tbl.TestId == item.TestId select tbl).ToList().Count; if (checkExist == 0) { item.IsDelete = true; } } } objData.SubmitChanges(); return(1); } catch (Exception ex) { throw ex; } }
protected void BtnEdit_Click(object sender, EventArgs e) { try { tblCustomerTransaction entcust = new tblCustomerTransaction(); entcust.PayAmount = Convert.ToDecimal(txtPayAmount.Text); entcust.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text); entcust.ReceiptNo = Convert.ToInt32(Session["ReceiptNo"]); entcust.BillAmount = 0; entcust.IsCash = true; entcust.ReceiptDate = Convert.ToDateTime(txtTransactDate.Text); entcust.PatientId = Convert.ToInt32(ddlPatient.SelectedValue); entcust.PreparedByName = Convert.ToString(Session["AdminName"]); EntityCustomerTransaction transact = null; if (IsCheque.Checked && ddlPatientCategory.SelectedItem.Text == "Self") { entcust.IsCash = false; entcust.ISCheque = true; entcust.IsCard = false; entcust.IsRTGS = false; entcust.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text); entcust.ChequeDate = Convert.ToDateTime(txtChequeDate.Text); entcust.ChequeNo = Convert.ToString(txtChequeNo.Text); entcust.BankName = Convert.ToString(txtBankName.Text); entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text); transact = new EntityCustomerTransaction(); transact.InsuranceId = 0; transact.CompanyId = 0; transact.CompanyName = ""; transact.InsuranceName = ""; transact.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text); transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text); transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text); transact.ISCheque = true; transact.PayAmount = 0; transact.ChequeDate = Convert.ToDateTime(txtChequeDate.Text); transact.ChequeNo = Convert.ToString(txtChequeNo.Text); transact.BankName = Convert.ToString(txtBankName.Text); } else if (IsCheque.Checked && ddlPatientCategory.SelectedItem.Text == "Company") { entcust.IsCash = false; entcust.ISCheque = true; entcust.IsCard = false; entcust.IsRTGS = false; entcust.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text); entcust.ChequeDate = Convert.ToDateTime(txtChequeDate.Text); entcust.ChequeNo = Convert.ToString(txtChequeNo.Text); entcust.BankName = Convert.ToString(txtBankName.Text); entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text); transact = new EntityCustomerTransaction(); transact.InsuranceId = 0; transact.CompanyId = Convert.ToInt32(ddlCompany.SelectedValue); transact.CompanyName = Convert.ToString(ddlCompany.SelectedItem.Text); transact.InsuranceName = ""; transact.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text); transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text); transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text); transact.ISCheque = true; transact.PayAmount = 0; transact.ChequeDate = Convert.ToDateTime(txtChequeDate.Text); transact.ChequeNo = Convert.ToString(txtChequeNo.Text); transact.BankName = Convert.ToString(txtBankName.Text); } else if (IsCheque.Checked && ddlPatientCategory.SelectedItem.Text == "Insurance") { entcust.IsCash = false; entcust.ISCheque = false; entcust.IsCard = false; entcust.IsRTGS = false; entcust.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text); entcust.ChequeDate = Convert.ToDateTime(txtChequeDate.Text); entcust.ChequeNo = Convert.ToString(txtChequeNo.Text); entcust.BankName = Convert.ToString(txtBankName.Text); entcust.PatientCategory = Convert.ToString(ddlPatientCategory.SelectedItem.Text); transact = new EntityCustomerTransaction(); transact.InsuranceId = Convert.ToInt32(ddlCompany.SelectedValue); transact.CompanyId = 0; transact.InsuranceName = Convert.ToString(ddlCompany.SelectedItem.Text); transact.CompanyName = ""; transact.ReceiptDate = Convert.ToDateTime(txtChequeDate.Text); transact.BillAmount = Convert.ToDecimal(txtPayAmount.Text); transact.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text); transact.ISCheque = true; transact.PayAmount = 0; transact.ChequeDate = Convert.ToDateTime(txtChequeDate.Text); transact.ChequeNo = Convert.ToString(txtChequeNo.Text); transact.BankName = Convert.ToString(txtBankName.Text); } int i = new CustomerTransactionBLL().Update(entcust, transact, IsCash.Checked); GetCustTransactionList(); MultiView1.SetActiveView(View2); } catch (Exception ex) { lblMsg.Text = ex.Message; } }
public int Save(List <TestAllocation> lst, tblTestInvoice obj, bool IsCash) { int?Id = 0; objData.STP_Insert_tblTestInvoice(Convert.ToDateTime(DateTime.Now.Date), ref Id, Convert.ToInt32(obj.PatientId), Convert.ToDecimal(obj.Amount), Convert.ToDecimal(obj.Discount)); foreach (TestAllocation item in lst) { tblTestInvoiceDetail objtestDetails = new tblTestInvoiceDetail() { TestInvoiceId = Convert.ToInt32(Id), TestId = item.TestId, IsDelete = false, Charges = Convert.ToDecimal(item.Charges) }; objData.tblTestInvoiceDetails.InsertOnSubmit(objtestDetails); } int TransactionId = new PatientInvoiceBLL().GetTransactionId(); if (IsCash) { tblCustomerTransaction objDebit = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = true, TransactionDocNo = Id, TransactionType = "TestInvoice", BillAmount = obj.Amount, PayAmount = 0, PatientId = obj.PatientId, IsDelete = false, ReceiptDate = obj.TestInvoiceDate, }; objData.tblCustomerTransactions.InsertOnSubmit(objDebit); //objData.SubmitChanges(); tblCustomerTransaction objCrReceipt = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = true, TransactionDocNo = Id, TransactionType = "TestInvoice", PayAmount = obj.Amount, BillAmount = 0, PatientId = obj.PatientId, IsDelete = false, ReceiptDate = obj.TestInvoiceDate, }; objData.tblCustomerTransactions.InsertOnSubmit(objCrReceipt); //objData.SubmitChanges(); } else { tblCustomerTransaction objDebit = new tblCustomerTransaction() { TransactionId = TransactionId, IsCash = false, TransactionDocNo = Id, TransactionType = "TestInvoice", BillAmount = obj.Amount, PatientId = obj.PatientId, IsDelete = false, ReceiptDate = obj.TestInvoiceDate, }; objData.tblCustomerTransactions.InsertOnSubmit(objDebit); //objData.SubmitChanges(); } objData.SubmitChanges(); return(1); }