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); }
protected void btnSearch_Click(object sender, EventArgs e) { try { lbl.Text = "STOCK DETAIL REPORT"; lblFrom.Text = ddlProduct.SelectedItem.Text; lblTo.Text = string.Format("{0:dd-MMM-yyyy}", DateTime.Now); lblMessage.Text = string.Empty; EntityProduct entPro = new CustomerTransactionBLL().GetUnitOfMeasurement(ddlProduct.SelectedValue); lblUoM.Text = "U.O.M" + "-" + entPro.UOM; List <tblStockDetail> lst = new CustomerTransactionBLL().GetProductTransByProductId(Convert.ToInt32(ddlProduct.SelectedValue)); tblStockDetail obj = new tblStockDetail() { }; lst.Add(obj); tblStockDetail objReceived = new tblStockDetail() { TransactionType = "Total Inward Amount", InwardAmount = Convert.ToDecimal(lst.Sum(p => p.InwardAmount)) }; lst.Add(objReceived); tblStockDetail objBills = new tblStockDetail() { TransactionType = "Total Outward Amount", OutwardAmount = Convert.ToDecimal(lst.Sum(p => p.OutwardAmount)) }; lst.Add(objBills); tblStockDetail objIqty = new tblStockDetail() { TransactionType = "Total Inward Quntity", InwardQty = Convert.ToInt32(lst.Sum(p => p.InwardQty)) }; lst.Add(objIqty); tblStockDetail objOqty = new tblStockDetail() { TransactionType = "Total Outward Quntity", OutwardQty = Convert.ToInt32(lst.Sum(p => p.OutwardQty)) }; lst.Add(objOqty); tblStockDetail objFinal = new tblStockDetail() { TransactionType = "Balance Quntity", InwardQty = objIqty.InwardQty - objOqty.OutwardQty }; lst.Add(objFinal); dgvTestParameter.DataSource = lst; dgvTestParameter.DataBind(); Session["StockDetailsRep"] = ListConverter.ToDataTable(lst); } catch (Exception ex) { lblMessage.Text = ex.Message; } }
public int InsertPurchaseOrder(EntityIssueMaterial entInvoice, List <EntityIssueMaterialDetails> lstInvoice) { try { int?PO_ID = 0; objData.STP_InsertIssueMaterial(Convert.ToDateTime(entInvoice.IssueDate), ref PO_ID, Convert.ToInt32(entInvoice.PatientId), Convert.ToDecimal(entInvoice.TotalAmount), Convert.ToInt32(entInvoice.EmpId)); foreach (EntityIssueMaterialDetails entPurchaseDetails in lstInvoice) { tblIssueDetail obj = new tblIssueDetail() { IssueId = PO_ID, ProductId = Convert.ToInt32(entPurchaseDetails.ProductId), Quantity = entPurchaseDetails.Quantity, Rate = entPurchaseDetails.Rate, Total = Convert.ToDecimal(entPurchaseDetails.Total), IsDelete = false, BatchNo = entPurchaseDetails.BatchNo, ExpiryDate = entPurchaseDetails.ExpiryDate }; objData.tblIssueDetails.InsertOnSubmit(obj); tblStockDetail stock = new tblStockDetail() { ProductId = Convert.ToInt32(entPurchaseDetails.ProductId), OpeningQty = 0, InwardQty = 0, InwardPrice = 0, InwardAmount = 0, BatchNo = entPurchaseDetails.BatchNo, ExpiryDate = entPurchaseDetails.ExpiryDate, OutwardQty = entPurchaseDetails.Quantity, OutwardPrice = entPurchaseDetails.Rate, OutwardAmount = entPurchaseDetails.Total, TransactionType = "Issue", DocumentNo = PO_ID, }; objData.tblStockDetails.InsertOnSubmit(stock); } objData.SubmitChanges(); return(1); } catch (Exception ex) { throw ex; } }
public int?Save(tblPrescription tblins, List <EntityPrescriptionDetails> lst) { int?PrescriptionId = 0; try { objData.STP_Insert_tblPrescription(Convert.ToInt32(tblins.AdmitId), Convert.ToInt32(tblins.DeptCategory), tblins.DeptDoctor, Convert.ToDateTime(tblins.Prescription_Date), tblins.IsDressing, tblins.IsInjection, tblins.InjectionName, tblins.Investigation, tblins.Impression, tblins.AdviceNote, tblins.Remarks, ref PrescriptionId); foreach (EntityPrescriptionDetails item in lst) { tblPrescriptionDetail tbl = new tblPrescriptionDetail() { ProductId = Convert.ToInt32(item.ProductId), Morning = item.Morning, Afternoon = item.Afternoon, Night = item.Night, NoOfDays = item.NoOfDays, Quantity = item.Quantity, Prescription_Id = Convert.ToInt32(PrescriptionId), IsDelete = false }; objData.tblPrescriptionDetails.InsertOnSubmit(tbl); tblStockDetail stock = new tblStockDetail() { ProductId = Convert.ToInt32(item.ProductId), OpeningQty = 0, InwardQty = 0, InwardPrice = 0, InwardAmount = 0, OutwardQty = Convert.ToInt32(item.Quantity), TransactionType = "Issue", DocumentNo = PrescriptionId, }; objData.tblStockDetails.InsertOnSubmit(stock); } objData.SubmitChanges(); } catch (Exception ex) { throw ex; } return(PrescriptionId); }
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 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 UpdateMaterialIssueDetails(EntityIssueMaterial lstEdited, List <EntityIssueMaterialDetails> lstUpdate) { try { tblIssueMaster objTest = (from tbl in objData.tblIssueMasters where tbl.IsDelete == false && tbl.IssueId == lstEdited.IssueId select tbl).FirstOrDefault(); if (objTest != null) { objTest.IssueId = Convert.ToInt32(lstEdited.IssueId); objTest.TotalAmount = lstEdited.TotalAmount; objTest.PatientId = lstEdited.PatientId; objTest.EmpId = lstEdited.EmpId; objTest.IssueDate = lstEdited.IssueDate; } foreach (EntityIssueMaterialDetails item in lstUpdate) { if (item.SR_No == 0) { tblIssueDetail objNewAdded = new tblIssueDetail() { IssueId = Convert.ToInt32(lstEdited.IssueId), ProductId = Convert.ToInt32(item.ProductId), Quantity = item.Quantity, Rate = item.Rate, Total = Convert.ToDecimal(item.Total), IsDelete = false, BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, }; objData.tblIssueDetails.InsertOnSubmit(objNewAdded); tblStockDetail stock = new tblStockDetail() { ProductId = Convert.ToInt32(item.ProductId), OpeningQty = 0, InwardQty = 0, InwardPrice = 0, InwardAmount = 0, BatchNo = item.BatchNo, ExpiryDate = item.ExpiryDate, OutwardQty = item.Quantity, OutwardPrice = item.Rate, OutwardAmount = item.Total, TransactionType = "Issue", IsDelete = false, }; objData.tblStockDetails.InsertOnSubmit(stock); } else { tblIssueDetail cnt = (from tbl in objData.tblIssueDetails where tbl.IsDelete == false && tbl.SR_No == item.SR_No select tbl).FirstOrDefault(); if (cnt != null) { cnt.IssueId = Convert.ToInt32(item.IssueId); cnt.BatchNo = item.BatchNo; cnt.ExpiryDate = item.ExpiryDate; cnt.ProductId = Convert.ToInt32(item.ProductId); cnt.Quantity = item.Quantity; cnt.Rate = item.Rate; cnt.Total = Convert.ToDecimal(item.Total); cnt.IsDelete = item.IsDelete; } tblStockDetail stock = (from tbl in objData.tblStockDetails where tbl.IsDelete == false && tbl.DocumentNo == lstEdited.IssueId && tbl.ProductId == item.ProductId && tbl.TransactionType.Equals("Issue") select tbl).FirstOrDefault(); if (stock != null) { stock.ProductId = Convert.ToInt32(item.ProductId); 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.Rate; stock.OutwardAmount = item.Total; stock.IsDelete = item.IsDelete; } } } objData.SubmitChanges(); return(1); } catch (Exception ex) { throw ex; } }
public void Update(tblPrescription obj, List <EntityPrescriptionDetails> lst) { try { tblPrescription objcurrent = (from tbl in objData.tblPrescriptions where tbl.Prescription_Id == obj.Prescription_Id select tbl).FirstOrDefault(); if (objcurrent != null) { objcurrent.AdmitId = obj.AdmitId; objcurrent.DeptCategory = obj.DeptCategory; objcurrent.DeptDoctor = obj.DeptDoctor; objcurrent.Prescription_Date = obj.Prescription_Date; objcurrent.InjectionName = obj.InjectionName; objcurrent.IsDressing = obj.IsDressing; objcurrent.IsInjection = obj.IsInjection; objcurrent.Investigation = obj.Investigation; objcurrent.Impression = obj.Impression; objcurrent.AdviceNote = obj.AdviceNote; objcurrent.Remarks = obj.Remarks; } foreach (EntityPrescriptionDetails item in lst) { tblPrescriptionDetail objsal = new tblPrescriptionDetail(); objsal = (from tbl in objData.tblPrescriptionDetails where tbl.PrescriptionDetailId == item.PrescriptionDetailId && tbl.Prescription_Id == item.Prescription_Id && tbl.ProductId == item.ProductId && tbl.IsDelete == false select tbl).FirstOrDefault(); if (objsal != null) { objsal.ProductId = Convert.ToInt32(item.ProductId); objsal.Morning = item.Morning; objsal.Afternoon = item.Afternoon; objsal.Night = item.Night; objsal.NoOfDays = item.NoOfDays; objsal.Quantity = item.Quantity; objsal.IsDelete = item.IsDelete; } else { objsal = new tblPrescriptionDetail() { ProductId = item.ProductId, Morning = item.Morning, Afternoon = item.Afternoon, Night = item.Night, NoOfDays = item.NoOfDays, Quantity = item.Quantity, Prescription_Id = Convert.ToInt32(obj.Prescription_Id), IsDelete = false }; objData.tblPrescriptionDetails.InsertOnSubmit(objsal); } tblStockDetail stock = (from tbl in objData.tblStockDetails where tbl.IsDelete == false && tbl.DocumentNo == item.Prescription_Id && tbl.ProductId == item.ProductId && tbl.TransactionType.Equals("Issue") select tbl).FirstOrDefault(); if (stock != null) { stock.ProductId = Convert.ToInt32(item.ProductId); stock.OpeningQty = 0; stock.InwardQty = 0; stock.InwardPrice = 0; stock.InwardAmount = 0; stock.OutwardQty = Convert.ToInt32(item.Quantity); stock.IsDelete = item.IsDelete; } else { tblStockDetail stock1 = new tblStockDetail() { ProductId = Convert.ToInt32(item.ProductId), OpeningQty = 0, InwardQty = 0, InwardPrice = 0, InwardAmount = 0, OutwardQty = Convert.ToInt32(item.Quantity), TransactionType = "Issue", IsDelete = false, }; objData.tblStockDetails.InsertOnSubmit(stock1); } } objData.SubmitChanges(); } catch (Exception ex) { throw ex; } }
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); }