protected void uiGridViewItems_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteDetail")
{
IStock.BLL.DeliveryOrderDetails objData = new IStock.BLL.DeliveryOrderDetails();
objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()));
decimal price = 0;
if (!CurrentDeliveryOrder.IsColumnNull("Discount") && CurrentDeliveryOrder.Discount != 0)
{
price = objData.ItemPrice * objData.Quantity * (CurrentDeliveryOrder.Discount / 100);
}
else
{
price = objData.ItemPrice * objData.Quantity;
}
/* restore items to stock */
IStock.BLL.Items item = new IStock.BLL.Items();
item.LoadByPrimaryKey(objData.ItemID);
item.Quantity += objData.Quantity;
item.Save();
/* restore items to stock */
IStock.BLL.Clients client = new IStock.BLL.Clients();
client.LoadByPrimaryKey(CurrentDeliveryOrder.ClientID);
client.StartCredit -= price;
client.Save();
objData.MarkAsDeleted();
objData.Save();
BindItems();
}
}
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 uiLinkButtonAddItem_Click(object sender, EventArgs e)
{
/* get items from stock */
IStock.BLL.Items item = new IStock.BLL.Items();
item.LoadByPrimaryKey(Convert.ToInt32(uiHiddenFieldCurrentItem.Value));
if (!item.IsColumnNull("Quantity"))
{
if (item.Quantity == 0 || Convert.ToInt32(uiTextBoxQty.Text) > item.Quantity)
{
ErrorDiv.Visible = true;
uiLabelError.Text = GetLocalResourceObject("ItemQtyError").ToString();
return;
}
item.Quantity -= Convert.ToInt32(uiTextBoxQty.Text);
}
else
{
ErrorDiv.Visible = true;
uiLabelError.Text = GetLocalResourceObject("ItemQtyError").ToString();
return;
}
item.Save();
/* get items from stock */
IStock.BLL.DeliveryOrderDetails detail = new IStock.BLL.DeliveryOrderDetails();
detail.AddNew();
detail.DeliveryOrderID = CurrentDeliveryOrder.DeliveryOrderID;
detail.ItemID = Convert.ToInt32(uiHiddenFieldCurrentItem.Value);
//detail.ItemID = Convert.ToInt32(uiDropDownListItems.SelectedValue);
detail.Quantity = Convert.ToInt32(uiTextBoxQty.Text);
detail.ItemPrice = decimal.Parse(uiTextBoxPrice.Text);
detail.Save();
decimal price = 0;
if (!CurrentDeliveryOrder.IsColumnNull("Discount") && CurrentDeliveryOrder.Discount != 0)
{
price = detail.ItemPrice * detail.Quantity * (CurrentDeliveryOrder.Discount / 100);
}
else
{
price = detail.ItemPrice * detail.Quantity;
}
IStock.BLL.Clients client = new IStock.BLL.Clients();
client.LoadByPrimaryKey(CurrentDeliveryOrder.ClientID);
if (!client.IsColumnNull("StartCredit"))
client.StartCredit += price;
else
client.StartCredit = price;
client.Save();
ErrorDiv.Visible = false;
uiTextBoxItems.Text = "";
uiTextBoxPrice.Text = "";
uiTextBoxQty.Text = "";
BindItems();
}
protected void uiLinkButtonCreateInvoice_Click(object sender, EventArgs e)
{
IStock.BLL.Invoices invoice = new IStock.BLL.Invoices();
string code = invoice.getNewSerial();
invoice.AddNew();
invoice.InvoiceNo = code;
invoice.ClientID = CurrentDeliveryOrder.ClientID;
invoice.InvoiceDate = CurrentDeliveryOrder.DeliveryOrderDate;
invoice.EmployeeID = CurrentDeliveryOrder.EmployeeID;
invoice.DeliveryOrderID = CurrentDeliveryOrder.DeliveryOrderID;
if (!CurrentDeliveryOrder.IsColumnNull("Discount"))
invoice.Discount = CurrentDeliveryOrder.Discount;
else
invoice.Discount = 0;
invoice.Save();
IStock.BLL.DeliveryOrderDetails details = new IStock.BLL.DeliveryOrderDetails();
IStock.BLL.InvoiceDetails invoicedetails = new IStock.BLL.InvoiceDetails();
details.GetDeliveryOrderDetails(CurrentDeliveryOrder.DeliveryOrderID);
for (int i = 0; i < details.RowCount; i++)
{
invoicedetails.AddNew();
invoicedetails.InvoiceID = invoice.InvoiceID;
invoicedetails.ItemID = details.ItemID;
invoicedetails.ItemPrice = details.ItemPrice;
invoicedetails.Quantity = details.Quantity;
details.MoveNext();
}
invoicedetails.Save();
//EnableDisableActions();
}
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;
}
}
}
