private void BindItems()
{
IStock.BLL.DeliveryOrderDetails details = new IStock.BLL.DeliveryOrderDetails();
details.GetDeliveryOrderDetails(CurrentDeliveryOrder.DeliveryOrderID);
uiGridViewItems.DataSource = details.DefaultView;
uiGridViewItems.DataBind();
IStock.BLL.ClientReturns cr = new IStock.BLL.ClientReturns();
cr.GetClientReturnByDeliveryOrderID(CurrentDeliveryOrder.DeliveryOrderID);
if (cr.RowCount > 0)
{
uiTextBoxTotal.Text = (CurrentDeliveryOrder.GetDeliveryOrderTotals(CurrentDeliveryOrder.DeliveryOrderID) - cr.GetClientReturnTotals(cr.ClientReturnID)).ToString();
uiLabelClientReturn.Text = cr.ReturnNo;
uiTextBoxTotalReturn.Text = cr.GetClientReturnTotals(cr.ClientReturnID).ToString();
}
else
uiTextBoxTotal.Text = CurrentDeliveryOrder.GetDeliveryOrderTotals(CurrentDeliveryOrder.DeliveryOrderID).ToString();
}
protected void uiGridViewOrders_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditOrder")
{
IStock.BLL.DeliveryOrder objData = new IStock.BLL.DeliveryOrder();
objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()));
uiTextBoxCode.Text = objData.DeliveryOrderNo;
uiTextBoxDate.Text = objData.DeliveryOrderDate.ToString("dd/MM/yyy");
uiDropDownListClients.SelectedValue = objData.ClientID.ToString();
uiDropDownListEmployee.SelectedValue = objData.EmployeeID.ToString();
if(!objData.IsColumnNull("Discount"))
uiTextBoxDiscount.Text = objData.Discount.ToString();
uiPanelAllOrders.Visible = false;
uiPanelEditDeliveryOrder.Visible = true;
uiPanelItems.Visible = true;
CurrentDeliveryOrder = objData;
//EnableDisableActions();
BindItems();
}
else if (e.CommandName == "DeleteOrder")
{
try
{
IStock.BLL.DeliveryOrder objData = new IStock.BLL.DeliveryOrder();
objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()));
IStock.BLL.DeliveryOrderDetails details = new IStock.BLL.DeliveryOrderDetails();
details.GetDeliveryOrderDetails(objData.DeliveryOrderID);
decimal total = objData.GetDeliveryOrderTotals(objData.DeliveryOrderID);
/* restore items to stock */
for (int i = 0; i < details.RowCount; i++)
{
IStock.BLL.Items item = new IStock.BLL.Items();
item.LoadByPrimaryKey(details.ItemID);
item.Quantity += details.Quantity;
details.MoveNext();
item.Save();
}
/* restore items to stock */
details.MarkAsDeleted();
details.Save();
/* update client credit */
IStock.BLL.Clients client = new IStock.BLL.Clients();
client.LoadByPrimaryKey(objData.ClientID);
client.StartCredit -= total;
client.Save();
/* update client credit */
IStock.BLL.ClientReturns cr = new IStock.BLL.ClientReturns ();
cr.GetClientReturnByDeliveryOrderID(objData.DeliveryOrderID);
if (cr.RowCount > 0)
{
cr.SetColumnNull("DeliveryOrderID");
cr.Save();
}
objData.MarkAsDeleted();
objData.Save();
CurrentDeliveryOrder = null;
BindOrders();
}
catch (Exception ex)
{
uipanelError.Visible = true;
}
}
}