protected void uiGridViewItems_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteDetail")
{
IStock.BLL.ClientReturnDetails objData = new IStock.BLL.ClientReturnDetails();
objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()));
decimal price = 0;
if (!objData.IsColumnNull("Discount") && objData.Discount != 0)
{
price = objData.ItemPrice * objData.Quantity * (objData.Discount / 100);
}
else
{
price = objData.ItemPrice * objData.Quantity;
}
IStock.BLL.Clients client = new IStock.BLL.Clients();
IStock.BLL.ClientReturns returns = new IStock.BLL.ClientReturns ();
returns.LoadByPrimaryKey(objData.ClientReturnID);
client.LoadByPrimaryKey(returns.ClientID);
client.StartCredit += price;
client.Save();
IStock.BLL.Items item = new IStock.BLL.Items();
item.LoadByPrimaryKey(objData.ItemID);
if(!objData.IsColumnNull("Valid"))
item.Quantity -= objData.Valid;
item.Save();
objData.MarkAsDeleted();
objData.Save();
BindItems();
}
}
protected void uiLinkButtonAddItem_Click(object sender, EventArgs e)
{
IStock.BLL.ClientReturnDetails detail = new IStock.BLL.ClientReturnDetails();
detail.AddNew();
detail.ClientReturnID = CurrentReturn.ClientReturnID;
//if (uiDropDownListItems.SelectedIndex != -1)
if (!string.IsNullOrEmpty(uiHiddenFieldCurrentItem.Value))
{
//detail.ItemID = Convert.ToInt32(uiDropDownListItems.SelectedValue);
detail.ItemID = Convert.ToInt32(uiHiddenFieldCurrentItem.Value);
}
else
{
uiPanelErrorItems.Visible = true;
return;
}
try
{
detail.Quantity = Convert.ToInt32(uiTextBoxQty.Text);
}
catch (Exception ex)
{
return;
}
try
{
detail.Valid = Convert.ToInt32(uiTextBoxValid.Text);
}
catch (Exception ex)
{
return;
}
try
{
detail.ItemPrice = decimal.Parse(uiTextBoxPrice.Text);
}
catch (Exception ex)
{
return;
}
detail.Save();
uiPanelErrorItems.Visible = false;
decimal price = 0;
if (!CurrentReturn.IsColumnNull("Discount") && CurrentReturn.Discount != 0)
{
price = detail.ItemPrice * detail.Quantity * (CurrentReturn.Discount / 100);
}
else
{
price = detail.ItemPrice * detail.Quantity;
}
IStock.BLL.Clients client = new IStock.BLL.Clients();
client.LoadByPrimaryKey(CurrentReturn.ClientID);
if (!client.IsColumnNull("StartCredit"))
client.StartCredit -= price;
else
client.StartCredit = -price;
client.Save();
IStock.BLL.Items item = new IStock.BLL.Items();
item.LoadByPrimaryKey(detail.ItemID);
item.Quantity += detail.Valid;
item.Save();
BindItems();
}
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();
}
}
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 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;
}
}
}
protected void uiLinkButtonConfirm_Click(object sender, EventArgs e)
{
CurrentPurchaseOrder.Confirmed = true;
CurrentPurchaseOrder.Save();
uiLinkButtonConfirm.Enabled = false;
IStock.BLL.PurchaseOrderDetails details = new IStock.BLL.PurchaseOrderDetails();
details.GetPurchaseOrderDetails(CurrentPurchaseOrder.PurchaseOrderID);
for (int i = 0; i < details.RowCount; i++)
{
IStock.BLL.Items item = new IStock.BLL.Items();
item.LoadByPrimaryKey(details.ItemID);
if (item.IsColumnNull("Quantity"))
item.SetColumn("Quantity", details.NoOfPackages * details.ItemOnPackages);
else
item.Quantity += details.NoOfPackages * details.ItemOnPackages;
item.Save();
details.MoveNext();
}
EnableDisableControls();
BindItems();
}