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 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)
{
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 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();
}
protected void uiLinkButtonItemTranHiostory_Click(object sender, EventArgs e)
{
uiReportViewerMain.Reset();
uiReportViewerMain.LocalReport.ReportPath = BaseReportPath + "Report_GetItemTranHistory.rdlc";
IStock.BLL.Items items = new IStock.BLL.Items();
DateTime? From = null, To= null;
if(!string.IsNullOrEmpty(uiTextBoxFrom.Text))
From = DateTime.ParseExact(uiTextBoxFrom.Text, "dd/MM/yyyy", null);
if(!string.IsNullOrEmpty(uiTextBoxTo.Text))
To = DateTime.ParseExact(uiTextBoxTo.Text, "dd/MM/yyyy", null);
if (!string.IsNullOrEmpty(uiHiddenFieldCurrentItem.Value))
items.Report_GetItemTranHistory(Convert.ToInt32(uiHiddenFieldCurrentItem.Value), From, To);
else
items.Report_GetItemTranHistory(0, From, To);
uiReportViewerMain.LocalReport.DataSources.Clear();
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource("Report_GetItemTranHistoryDataSet", items.DefaultView));
uiReportViewerMain.LocalReport.SetParameters(new ReportParameter("ItemID", uiHiddenFieldCurrentItem.Value));
uiReportViewerMain.LocalReport.SetParameters(new ReportParameter("From", uiTextBoxFrom.Text));
uiReportViewerMain.LocalReport.SetParameters(new ReportParameter("To", uiTextBoxTo.Text));
uiReportViewerMain.LocalReport.Refresh();
}
protected void uiLinkButtonItemPrices_Click(object sender, EventArgs e)
{
if (uiDropDownListClientTypes.SelectedIndex == -1 || uiDropDownListClientTypes.SelectedValue == "0")
{
ClientScript.RegisterStartupScript( this.GetType(), "Error", "alert('من فضلك أختر نوع العميل');", true);
return;
}
uiReportViewerMain.Reset();
uiReportViewerMain.LocalReport.ReportPath = BaseReportPath + "Report_ItemPrices.rdlc";
IStock.BLL.Items items = new IStock.BLL.Items();
if(!string.IsNullOrEmpty(uiHiddenFieldCurrentItem.Value))
items.Report_ItemPrices(Convert.ToInt32(uiHiddenFieldCurrentItem.Value), Convert.ToInt32(uiDropDownListClientTypes.SelectedValue));
else
items.Report_ItemPrices(0, Convert.ToInt32(uiDropDownListClientTypes.SelectedValue));
uiReportViewerMain.LocalReport.DataSources.Clear();
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource("Report_ItemPricesDataSet", items.DefaultView));
uiReportViewerMain.LocalReport.SetParameters(new ReportParameter("ItemID", uiHiddenFieldCurrentItem.Value));
uiReportViewerMain.LocalReport.SetParameters(new ReportParameter("ClientTypeID", uiDropDownListClientTypes.SelectedValue));
uiReportViewerMain.LocalReport.Refresh();
}
