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