private void GetPurchaseOrderDetails(int PurchaseOrderID)
        {
            try
            {
                PurchaseOrderDL _currentPurchaseOrder = new PurchaseOrderDL();
                _currentPurchaseOrder.GetPurchaseOrderByPurchaseOrderID(Convert.ToInt32(hfPurchaseOrderID.Value.ToString()));

                ddlContact.SelectedValue  = _currentPurchaseOrder.BuyerID.ToString();
                txtPONO.Text              = _currentPurchaseOrder.PurchaseOrderNo;
                txtPODate.Text            = _currentPurchaseOrder.PurchaseOrderDate.ToString();
                ddlCurrency.SelectedValue = _currentPurchaseOrder.Currency;
                ddlShipment.SelectedValue = _currentPurchaseOrder.Shipment;
                txtTel.Text       = _currentPurchaseOrder.TelNo;
                lblTotalCost.Text = _currentPurchaseOrder.GrandTotal.ToString();

                if (hfPurchaseOrderID.Value.ToString() != "0")
                {
                    trEnablePurchaseWorkOrder.Visible = true;
                }

                _currentPurchaseWorkOrder = new PurchaseWorkOrderDL();

                gvPurchaseWorkOrder.DataSource = _currentPurchaseWorkOrder.GetPurchaseWorkOrderByPurchaseOrderID(Convert.ToInt32(hfPurchaseOrderID.Value.ToString())).Tables[0];
                gvPurchaseWorkOrder.DataBind();
            }
            catch (Exception ex)
            {
                ErrorLog.LogErrorMessageToDB("AddEditPurchaseOrder.aspx", "", "GetPurchaseOrderDetails(int PurchaseOrderID)", ex.Message, new ACEConnection());
            }
        }
        protected void btnPurchaseWorkOrderAdd_Click(object sender, ImageClickEventArgs e)
        {
            try
            {
                _currentPurchaseWorkOrder = new PurchaseWorkOrderDL();
                bool bl = hfPurchaseWorkOrderID.Value.ToString() == "0";
                _currentPurchaseWorkOrder.AddEditOption = !bl ? 1 : 0;

                _currentPurchaseWorkOrder.PurchaseOrderID = Convert.ToInt32(hfPurchaseOrderID.Value.ToString());

                _currentPurchaseWorkOrder.PurchaseWorkOrderID = Convert.ToInt32(hfPurchaseWorkOrderID.Value.ToString());
                string   dtFormat = _dateFormat;
                DateTime dTime;

                _currentPurchaseWorkOrder.WorkerNo    = txtPurchaseWorkOrder.Text;
                _currentPurchaseWorkOrder.ItemNo      = txtItemNo.Text;
                _currentPurchaseWorkOrder.PartNo      = txtPartNo.Text;
                _currentPurchaseWorkOrder.Description = txtDescription.Text;
                _currentPurchaseWorkOrder.Qty         = Convert.ToInt32(txtQty.Text);
                _currentPurchaseWorkOrder.UnitPrice   = Convert.ToDecimal(txtUnitPrice.Text);
                _currentPurchaseWorkOrder.TotalPrice  = Convert.ToDecimal(txtTotalPrice.Text);

                dTime = DateTime.ParseExact(txtReqatSpore.Text, dtFormat, null);
                _currentPurchaseWorkOrder.ReqatSpore = Convert.ToDateTime(dTime);
                dTime = DateTime.ParseExact(txtDTofStock.Text, dtFormat, null);
                _currentPurchaseWorkOrder.DTofStock = Convert.ToDateTime(dTime);
                dTime = DateTime.ParseExact(txtDTofDispatch.Text, dtFormat, null);
                _currentPurchaseWorkOrder.DTofDispatch = Convert.ToDateTime(dTime);

                _currentPurchaseWorkOrder.Remarks = txtRemarks.Text;
                _currentPurchaseWorkOrder.AuthorisedSignatureID = Convert.ToInt32(ddlReviewedBy.SelectedValue);
                _currentPurchaseWorkOrder.AuditID = Convert.ToInt32(hfUserID.Value);

                _currentPurchaseWorkOrder.ScreenMode = ScreenMode.Add;
                TransactionResult transactionResult = _currentPurchaseWorkOrder.Commit();
                StringBuilder     stringBuilder     = new StringBuilder();
                stringBuilder.Append(string.Concat("<script>alert(\'", transactionResult.Message.ToString(), ".\');"));
                stringBuilder.Append("</script>");
                ScriptManager.RegisterStartupScript(base.Page, typeof(string), "MyScript", stringBuilder.ToString(), false);
                bl = transactionResult.Status != TransactionStatus.Success;
                if (!bl)
                {
                    GetPurchaseOrderDetails(Convert.ToInt32(hfPurchaseOrderID.Value));
                    txtPurchaseWorkOrder.Text   = "";
                    hfPurchaseWorkOrderID.Value = "0";
                }
                else
                {
                    txtPurchaseWorkOrder.Text   = "";
                    hfPurchaseWorkOrderID.Value = "0";
                }
            }
            catch (Exception exception1)
            {
                ErrorLog.LogErrorMessageToDB("ManagePurchaseWorkOrder.aspx", "", "btnPurchaseWorkOrderAdd_Click", exception1.Message.ToString(), new ACEConnection());
                throw;
            }
        }