protected void GrdDeliveryOrder_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "DeleteGrdDO")
            {
                BLL.DeliveryOrder DelDO = new BLL.DeliveryOrder();
                DeliveryOrderDetails DelDetails = new DeliveryOrderDetails();
                DelDO.LoadByPrimaryKey(int.Parse(e.CommandArgument.ToString()));
                DelDetails.getDetails(int.Parse(e.CommandArgument.ToString()));
                DelDetails.DeleteAll();
                DelDetails.Save();
                DelDO.MarkAsDeleted();
                DelDO.Save();

            }
            else if (e.CommandName == "EditGrdDO")
            {
                int ID = int.Parse(e.CommandArgument.ToString());

                Response.Redirect("DeliveryOrder.aspx?DeliveryOrderID=" + ID.ToString());

            }
            DeliveryOrderBind();
        }
        protected void addDeliveryOrderDetailsGrd_Click(object sender, EventArgs e)
        {
            BLL.DeliveryOrderDetails Dodd = new DeliveryOrderDetails();
            if (getQueryString_DeliveryOrderDetails > 0)
            {
                Dodd.LoadByPrimaryKey(getQueryString_DeliveryOrderDetails);
            }
            else
            {
                Dodd.AddNew();
                Dodd.CreatedBy = new Guid(Membership.GetUser().ProviderUserKey.ToString());
                Dodd.CreatedDate = DateTime.Now;
            }

            Dodd.DeliveryFrom = txtDeliveryFrom.Text;
            Dodd.DeliveryTo = txtDeliveryTo.Text;
            Dodd.DateFrom = Convert.ToDateTime(txtDateFrom.Text);
            Dodd.DateTo = Convert.ToDateTime(txtDateTo.Text);
            Dodd.ReceivableName = txtRecivableName.Text;
            Dodd.ReceivableTelephone = txtRecivableTelephone.Text;
            Dodd.DeliveryOrderCode = txtDeliveryOrderCode.Text;
            if (txtWatingHours.Text != "")
            {
                Dodd.WatingHours = float.Parse(txtWatingHours.Text);
            }
            else
                txtWatingHours.Text = "0.0";
            if (txtPrice.Text != "")
            {
                Dodd.Price = float.Parse(txtPrice.Text);
            }
            else
                txtPrice.Text = "0.0";
            Dodd.DeliveryOrderStatusID = int.Parse(drpStatusDetails.SelectedItem.Value);
            Dodd.UpdatedBy = new Guid(Membership.GetUser().ProviderUserKey.ToString());
            Dodd.LastUpdatedDate = DateTime.Now;
            Dodd.DeliveryOrderID = getQueryString_DeliveryOrder;
            Dodd.Save();
            DeliveryOrderDetailsBind();
            grdDeliveryOrderDetails.Visible = true;
            ClearGrdDetails();
        }
        protected void grdDeliveryOrderDetails_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "DeleteGrdDetailsDO")
            {
                DeliveryOrderDetails DelDODetails = new DeliveryOrderDetails();
                DelDODetails.LoadByPrimaryKey(int.Parse(e.CommandArgument.ToString()));
                DelDODetails.MarkAsDeleted();
                DelDODetails.Save();

            }
            else if (e.CommandName == "EditGrdDetailsDO")
            {
                int ID = int.Parse(e.CommandArgument.ToString());
                Response.Redirect(Request.Url.AbsolutePath.ToString() + "?DeliveryOrderID=" + Request.QueryString["DeliveryOrderID"].ToString() + "&DeliveryOrderDetailsID=" + ID.ToString());

            }
            DeliveryOrderDetailsBind();
        }