List <PurchasesDetail> CurrentgvProducts(GridView gv) { List <PurchasesDetail> list = new List <PurchasesDetail>(); foreach (GridViewRow gvrow in gv.Rows) { PurchasesDetail objPurchasesDetail = new PurchasesDetail(); string value = ""; value = (gvrow.FindControl("lblPurchasesDetailID") as Label).Text; objPurchasesDetail.PurchasesDetailID = Convert.ToInt32(((string.IsNullOrEmpty(value)) ? "0" : value)); value = (gvrow.FindControl("lblPurchaseID") as Label).Text; objPurchasesDetail.PurchaseID = Convert.ToInt32(((string.IsNullOrEmpty(value)) ? "0" : value)); value = (gvrow.FindControl("ddlProduct") as DropDownList).SelectedValue; objPurchasesDetail.ProductID = Convert.ToInt32(((string.IsNullOrEmpty(value)) ? "0" : value)); value = (gvrow.FindControl("ddlUnits") as DropDownList).SelectedValue; objPurchasesDetail.UnitID = Convert.ToInt32(((string.IsNullOrEmpty(value)) ? "0" : value)); objPurchasesDetail.PQTY = Convert.ToDouble((gvrow.FindControl("txtPQTY") as TextBox).Text); objPurchasesDetail.PUnitPrice = Convert.ToDouble((gvrow.FindControl("txtPUnitPrice") as TextBox).Text); objPurchasesDetail.TotalPrice = Convert.ToDouble((gvrow.FindControl("txtTotalPrice") as TextBox).Text); value = (gvrow.FindControl("hfoldQty") as HiddenField).Value; objPurchasesDetail.oldQty = (string.IsNullOrEmpty(value)) ? 0.0 : Convert.ToDouble(value);; //hfQuantity list.Add(objPurchasesDetail); } return(list); }
bool deletePurchasesDetail(int PurchasesDetailID) { objPurchasesDetail.BeginTransaction(); objPurchasesDetail = objPurchasesDetail.Single(p => p.PurchasesDetailID == PurchasesDetailID); //var payment = objPurchasesDetail.PurchasesMaster.PaymentsForSupplier; //payment.Delete(p => p.SupplierPaymentID == payment.SupplierPaymentID); objPurchasesMaster = objPurchasesDetail.PurchasesMaster; objPurchasesMaster.TotalPurchase -= objPurchasesDetail.TotalPrice; objPurchasesMaster.Rest -= objPurchasesDetail.TotalPrice; objPurchasesMaster.Update(p => p.PurchaseID == objPurchasesMaster.PurchaseID); hfOldRest.Value = objPurchasesMaster.Rest.ToString(); // update balance objSupplier = objSupplier.Single(p => p.SupplierID == objPurchasesDetail.PurchasesMaster.SupplierID); objSupplier.Balance = (objSupplier.Balance) - (objPurchasesDetail.TotalPrice); objSupplier.Update(p => p.SupplierID == objSupplier.SupplierID); //update qty SalesManager.UpdateproductQTY(QTYOperation.Decrement, objPurchasesDetail.ProductID, objPurchasesDetail.Quantity); bool status = objPurchasesDetail.Delete(p => p.PurchasesDetailID == PurchasesDetailID); objPurchasesDetail.EndTransaction(); return(status); }
List <PurchasesDetail> IntialgvProducts() { List <PurchasesDetail> list = new List <PurchasesDetail>(); PurchasesDetail objPurchasesDetail = new PurchasesDetail(); list.Add(objPurchasesDetail); return(list); }
List <PurchasesDetail> AddRow(GridView gv) { List <PurchasesDetail> list = CurrentgvProducts(gv); //var q = list.Select(p => new { PurchaseID = p.PurchaseID, ProductID = p.ProductID }).GroupBy(p => p.ProductID) //.Select(e => new { ProductID = e.Key, Count = e.Count() }).Where(p => p.Count > 1); //if (q.Count() > 0) //{ // MessageBox.Show(this.Page, "Cant Insert same Product more than once in Purchases."); // return list; //} PurchasesDetail objPurchasesDetail = new PurchasesDetail(); list.Add(objPurchasesDetail); return(list); }