public static string[] GetCompletionList(string prefixText) { string[] list = default(string[]); string[] noData = { "No Data!" }; // stored procedures can't be used PurchaseDiscardsMaster objPurchaseDiscardsMaster = new PurchaseDiscardsMaster(); if (index == 1) { list = objPurchaseDiscardsMaster.Get(p => p.PurchaseDiscardsID.ToString().ToLower().StartsWith(prefixText.ToLower()), p => p.PurchaseDiscardsID.ToString()).ToArray(); return(list); } else if (index == 2) { list = objPurchaseDiscardsMaster.Get(p => p.PurchaseID.ToString().ToLower().StartsWith(prefixText.ToLower()), p => p.PurchaseID.ToString()).ToArray(); return(list); } else if (index == 3) { list = objPurchaseDiscardsMaster.Get(p => p.PurchasesMaster.Supplier.SupplierName.ToLower().StartsWith(prefixText.ToLower()), p => p.PurchasesMaster.Supplier.SupplierName).ToArray(); return(list); } else { return(noData); } }
bool Delete(int discardsID) { objPurchaseDiscardsMaster = objPurchaseDiscardsMaster.Single(p => p.PurchaseDiscardsID == discardsID); List <PurchaseDiscardsDetail> itemsList = objPurchaseDiscardsMaster.PurchaseDiscardsDetails.ToList(); objSupplier = objPurchaseDiscardsMaster.PurchasesMaster.Supplier; try { objPurchaseDiscardsMaster.BeginTransaction(); //update Supplier balance // هيزيد objSupplier.Balance += objPurchaseDiscardsMaster.TotalReturn; objSupplier.Update(p => p.SupplierID == objSupplier.SupplierID); //update products (store) itemsList.ForEach(p => { //update qty //هيزيد SalesManager.UpdateproductQTY(QTYOperation.Increment, p.ProductID, p.Quantity); } ); // delete purchaseitems(PurchasesDetails) itemsList.DeleteAll(); //delete masetr(PurchasesMaster) objPurchaseDiscardsMaster.Delete(p => p.PurchaseDiscardsID == discardsID); objPurchaseDiscardsMaster.EndTransaction(); } catch (Exception ex) { ExtenssionClass.Rollback(); Page.Show(ex.Message); return(false); } return(true); }
void Dir(PurchaseDiscardsMaster entity) { txtID.Text = entity.PurchaseDiscardsID.ToString(); txtPurchaseNo.Text = entity.PurchaseID.ToString(); txtSupplierName.Text = entity.PurchasesMaster.Supplier.SupplierName; txtNotes.Text = entity.Notes; txtPurchaseDiscardDateM.Text = entity.PurchaseDiscardsDateM.ToString("MM/dd/yyyy", culture); txtPurchaseDiscardDateH.Text = entity.PurchaseDiscardsDateH; FillgvProductsDiscarded(entity.PurchaseDiscardsID); EditgvProducts(entity.PurchaseID); lblTotalPurchaseDiscardsPrice.Text = entity.TotalReturn.ToString(); // ??? lblSupplierBalance.Text = lblNewSupplierBalance.Text = (entity.PurchasesMaster.Supplier.Balance).ToString(); //lblSupplierBalance.Text = lblNewSupplierBalance.Text = "0.0"; txtPurchaseNo.ReadOnly = txtNotes.ReadOnly = true; imgbtnSave.Enabled = txtPurchaseDiscardDateM.Enabled = false; }
bool Insert() { objPurchaseDiscardsMaster = new PurchaseDiscardsMaster(); objPurchaseDiscardsMaster.PurchaseID = Convert.ToInt32(hfPID.Value); objPurchaseDiscardsMaster.PurchaseDiscardsDateM = Convert.ToDateTime(txtPurchaseDiscardDateM.Text.Trim(), culture); objPurchaseDiscardsMaster.PurchaseDiscardsDateH = txtPurchaseDiscardDateH.Text.Trim(); objPurchaseDiscardsMaster.Notes = txtNotes.Text.Trim(); objPurchaseDiscardsMaster.TotalReturn = Convert.ToDouble(lblTotalPurchaseDiscardsPrice.Text); List <PurchaseDiscardsDetail> discardsList = new List <PurchaseDiscardsDetail>(); discardsList = CurrentgvProducts(gvProducts); discardsList.ForEach(p => { p.Quantity = SalesManager.UnitConvert(p.UnitID, p.PDQTY); p.UnitPrice = SalesManager.UnitPriceConvert(p.UnitID, p.PUnitPrice); p.BasicUnitID = SalesManager.getBasicUnitID; }); objPurchaseDiscardsMaster.PurchaseDiscardsDetails.AddRange(discardsList); objPurchaseDiscardsMaster.BeginTransaction(); objPurchaseDiscardsMaster.Insert(); // update product qty in store ( table product ) discardsList.ForEach(p => SalesManager.UpdateproductQTY(QTYOperation.Decrement, p.ProductID, p.Quantity)); // update supplier balance objSupplier = objSupplier.Single(p => p.SupplierID == int.Parse(hfSID.Value)); objSupplier.Balance = Convert.ToDouble(lblNewSupplierBalance.Text); objSupplier.Update(p => p.SupplierID == objSupplier.SupplierID); objPurchaseDiscardsMaster.EndTransaction(); return(true); }