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