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();
}
private void DeliveryOrderDetailsBind()
{
BLL.DeliveryOrderDetails DOD = new DeliveryOrderDetails();
//DOD.LoadAll();
//DOD.Where.DeliveryOrderID.Value = getQueryString_DeliveryOrder;
//DOD.Where.DeliveryOrderID.Operator = WhereParameter.Operand.Equal;
//DOD.Query.Load();
DOD.getAllDeliveryOrderDetails(getQueryString_DeliveryOrder);
grdDeliveryOrderDetails.DataSource = DOD.DefaultView;
grdDeliveryOrderDetails.DataBind();
}
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 Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Master.PageTitle = "اوامر تشغيل السيارات";
DeliveryOrderBind();
if (getQueryString_DeliveryOrder > 0)
{
BLL.DeliveryOrder EditDO = new BLL.DeliveryOrder();
EditDO.LoadByPrimaryKey(getQueryString_DeliveryOrder);
txtCarNumber.Text = EditDO.CarNumber;
txtClientCode.Text = (EditDO.ClientCode).ToString();
txtkiloMeterAfter.Text = EditDO.KilometerCounterAfter.ToString();
txtKiloMeterBefore.Text = EditDO.KilometerCounterBefore.ToString();
txtTotalPrice.Text = EditDO.TotalPrice.ToString();
txtGeneralDeliveryCode.Text = EditDO.GeneralDeliveryCode;
drpTransformationSupplier.Text = EditDO.TransformationSupplier;
txtDriverName.Text = EditDO.DriverName;
txtDriverNationID.Text = EditDO.DriverNationID.ToString();
txtDriverTelephone.Text = EditDO.DriverTelephone;
txtCarType.Text = EditDO.CarType;
txtDepartmentResponsable.Text = EditDO.DepartmentResponsableName;
txtDeliveryOrderDate.Text = EditDO.DeliveryOrderDate.ToString("dd/MM/yyyy");
txtPermission.Text = EditDO.PermationNumber.ToString();
drpDepartment.Text = EditDO.Department;
txtDeliveryOrderName.Text = EditDO.DeliveryOrderName;
drpStatusGeneral.SelectedValue = EditDO.DeliveryOrderStatusID.ToString();
drpDepartment.SelectedValue = EditDO.DepartmentID.ToString();
DeliveryOrderDetailsBind();
WidGrdGeneralDeliveryOrder.Visible = false;
WidEditDeliveryOrder.Visible = true;
PanelDeliveryOrderDetails.Visible = true;
createNewDeliveryOrder.Visible = false;
}
if (getQueryString_DeliveryOrderDetails > 0)
{
DeliveryOrderDetails DODEdit = new DeliveryOrderDetails();
DODEdit.LoadByPrimaryKey(getQueryString_DeliveryOrderDetails);
txtDeliveryFrom.Text = DODEdit.DeliveryFrom;
txtDeliveryTo.Text = DODEdit.DeliveryTo;
txtDateFrom.Text = DODEdit.DateFrom.ToString("HH:mm");
txtDateTo.Text = DODEdit.DateTo.ToString("HH:mm");
txtRecivableName.Text = DODEdit.ReceivableName;
txtRecivableTelephone.Text = DODEdit.ReceivableTelephone;
if (!DODEdit.IsColumnNull("Price"))
txtPrice.Text = DODEdit.Price.ToString();
else
txtPrice.Text = "0.0";
txtDeliveryOrderCode.Text = DODEdit.DeliveryOrderCode;
drpStatusDetails.Text = DODEdit.DeliveryOrderStatusID.ToString();
if (!DODEdit.IsColumnNull("WatingHours"))
txtWatingHours.Text = DODEdit.WatingHours.ToString();
else
txtWatingHours.Text = "0";
}
BLL.DeliveryOrderStatus DOS = new DeliveryOrderStatus();
DOS.LoadAll();
drpStatusDetails.DataSource = DOS.DefaultView;
drpStatusDetails.DataValueField = DeliveryOrderStatus.ColumnNames.DeliveryOrderStatusID;
drpStatusDetails.DataTextField = DeliveryOrderStatus.ColumnNames.DeliveryOrderStatusNameAr;
drpStatusDetails.DataBind();
drpStatusGeneral.DataSource = DOS.DefaultView;
drpStatusGeneral.DataValueField = DeliveryOrderStatus.ColumnNames.DeliveryOrderStatusID;
drpStatusGeneral.DataTextField = DeliveryOrderStatus.ColumnNames.DeliveryOrderStatusNameAr;
drpStatusGeneral.DataBind();
BLL.TransformationSupplier DOO = new BLL.TransformationSupplier();
DOO.LoadAll();
drpTransformationSupplier.DataSource = DOO.DefaultView;
drpTransformationSupplier.DataValueField = TransformationSupplier.ColumnNames.TransformationSupplierID;
drpTransformationSupplier.DataTextField = TransformationSupplier.ColumnNames.TransformationSupplierName;
drpTransformationSupplier.DataBind();
Department dep = new Department();
dep.LoadAll();
drpDepartment.DataSource = dep.DefaultView;
drpDepartment.DataValueField = Department.ColumnNames.DepartmentID;
drpDepartment.DataTextField = Department.ColumnNames.DepartmentName;
drpDepartment.DataBind();
}
}
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();
}
