public List<Purchase_Order_Detail> getPurchaseOrderDetail(Purchase_Order_Detail para)
{
var q = from p in ContextDB.Purchase_Order_Detail
where (p.Item_Code == para.Item_Code || para.Item_Code == null)
&& (p.Description == para.Description || para.Description == null)
&& (p.Qty == para.Qty || para.Qty == null)
&& (p.Price == para.Price || para.Price == null)
&& (p.Amount == para.Amount || para.Amount == null)
select p;
return q.ToList<Purchase_Order_Detail>();
}
public bool deletePurchaseOrderDetail(Purchase_Order_Detail del)
{
try
{
ContextDB.Purchase_Order_Detail.DeleteObject(del);
ContextDB.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
public bool updatePurchaseOrderDetail(Purchase_Order_Detail upd)
{
try
{
Purchase_Order_Detail p = new Purchase_Order_Detail();
p.Item_Code = upd.Item_Code == null ? p.Item_Code : upd.Item_Code;
p.Description = upd.Description == null ? p.Description : upd.Description;
p.Qty = upd.Qty == null ? p.Qty : upd.Qty;
p.Price = upd.Price == null ? p.Price : upd.Price;
p.Amount = upd.Amount == null ? p.Amount : upd.Amount;
ContextDB.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
try
{
int currentPO = (Convert.ToInt32(lblPONumber.Text));
int maxPO = Convert.ToInt32(purchaseOrderController.checkMaxPO());
if (lblDate.Text == "")
{
if (currentPO == maxPO)
{
lblError.Text = "PO has already been generated";
}
}
else
{
Purchase_Order po = new Purchase_Order();
po.Supplier_ID = supplier.Supplier_ID;
po.Purchase_Order_No = lblPONumber.Text;
po.Deliver_To = txtAttn.Text;
lblDate.Text = Calendar1.SelectedDate.ToShortDateString();
DateTime dt = DateTime.Parse(lblDate.Text);
po.Expected_Date = dt;
po.Order_By = null;
po.Approve_By = null;
po.Approve_Date = DateTime.Now;
po.Receive_Flag = false;
purchaseOrderController.createPurchaseOrder(po);
List<Purchase_Order_Detail> pod = new List<Purchase_Order_Detail>();
foreach (GridViewRow row in PurOrderGridView.Rows)
{
Purchase_Order_Detail poDetail = new Purchase_Order_Detail(); //have to keep this initialising here for
poDetail.Purchase_Order_No = lblPONumber.Text;
poDetail.Item_Code = row.Cells[0].Text;
System.Diagnostics.Debug.WriteLine("foreach poDetail.Item_Code = " + poDetail.Item_Code);
poDetail.Description = row.Cells[1].Text;
poDetail.Qty = Convert.ToInt32(row.Cells[2].Text);
poDetail.Price = Convert.ToDecimal(row.Cells[3].Text);
poDetail.Amount = Convert.ToDecimal(row.Cells[4].Text);
pod.Add(poDetail);
}
purchaseOrderController.createPruchaseOrderDetail(pod);
lblError.Text = "Succcessfully generate the PO";
purchaseOrderController.update_GenID(Purchase_Order);
if (emailSupplier(supplier.Email))
{
lblEmailStatus.Text = "Email sent to supplier";
}
else
{
lblEmailStatus.Text = "Incorrect Email address, email not sent";
}
}
}
catch (Exception error)
{
lblError.Text = error.ToString();
}
}
/// <summary>
/// Deprecated Method for adding a new object to the Purchase_Order_Detail EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToPurchase_Order_Detail(Purchase_Order_Detail purchase_Order_Detail)
{
base.AddObject("Purchase_Order_Detail", purchase_Order_Detail);
}
/// <summary>
/// Create a new Purchase_Order_Detail object.
/// </summary>
/// <param name="purchase_Order_No">Initial value of the Purchase_Order_No property.</param>
/// <param name="item_Code">Initial value of the Item_Code property.</param>
public static Purchase_Order_Detail CreatePurchase_Order_Detail(global::System.String purchase_Order_No, global::System.String item_Code)
{
Purchase_Order_Detail purchase_Order_Detail = new Purchase_Order_Detail();
purchase_Order_Detail.Purchase_Order_No = purchase_Order_No;
purchase_Order_Detail.Item_Code = item_Code;
return purchase_Order_Detail;
}
