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 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; } }