private void PopulateOrdersBySearch(string FieldName, string Value)
{
PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order();
if (FieldName == "ToAndFromDate")
{
string[] ToandFrom = Value.Split('#');
string toDate = "";
string fromDate = "";
for (int i = 0; i < ToandFrom.Length; i++)
{
toDate = ToandFrom[i].ToString();
fromDate = ToandFrom[i + 1].ToString();
break;
}
dtOrderDG = Order.GetAllOrdersByToAndFromDate(toDate.ToString(), fromDate.ToString());
}
if (FieldName == "OrderByMonth")
{
dtOrderDG = Order.GetAllOrdersByMonthAndYear(Value.ToString());
}
dgOrders.DataSource = dtOrderDG;
dgOrders.DataBind();
}
private void PopulateOrders()
{
PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order();
dtOrderDG = Order.GetAllOrders();
dgOrders.DataSource = dtOrderDG;
dgOrders.DataBind();
}
private void PopulateOrders(long OrderMasterID)
{
PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order();
dtOrderDG = Order.GetOrderByID(OrderMasterID);
dgOrders.DataSource = dtOrderDG;
dgOrders.DataBind();
}
private void dgOrders_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if (e.CommandName == "DeleteOrder")
{
string argsID = e.CommandArgument.ToString();
long OrderID = Convert.ToInt32(argsID);
if (OrderID > 0)
{
PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order();
Order.DeleteOrder(OrderID);
lblErrorMessage.Text = "Order Deleted Successfuly.";
PopulateOrders();
}
}
}
private void PopulateOrdersBySearch(string FieldName, string Value)
{
PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order();
if (FieldName == "IsPending")
{
dtOrderDG = Order.GetAllOrdersBySearch(Convert.ToInt16(Value));
}
if (FieldName == "OrderNumber")
{
dtOrderDG = Order.GetAllOrdersByOrderNumber(Convert.ToInt32(Value));
}
if (FieldName == "OrderDate")
{
dtOrderDG = Order.GetAllOrdersByOrderDate(Value);
}
dgOrders.DataSource = dtOrderDG;
dgOrders.DataBind();
}
protected void btnprintOrder_Click(object sender, EventArgs e)
{
PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order();
bool checkBoxChecked = false;
foreach (DataGridItem dg in dgOrders.Items)
{
CheckBox chk = (CheckBox)dg.FindControl("chkSelected");
if (chk.Checked)
{
checkBoxChecked = true;
break;
}
}
if (!checkBoxChecked)
{
lblErrorMessage.Text = "No Order selected.";
return;
}
long OrderID = 0;
foreach (DataGridItem dg in dgOrders.Items)
{
CheckBox chk = (CheckBox)dg.FindControl("chkSelected");
if (chk.Checked)
{
Label lbl = (Label)dg.FindControl("lblHidden");
OrderID = Convert.ToInt32(lbl.Text);
Order.UpdateOrderMasterForPending(OrderID);
}
}
lblErrorMessage.Text = "Pending Info saved successfully.";
PopulateOrders();
}
private void dgOrders_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if (e.CommandName == "DeleteOrder")
{
string argsID = e.CommandArgument.ToString();
string[] idSpliter = argsID.Split('/');
long OrderMasterID = 0;
long OrderDetailID = 0;
for (int i = 0; i < idSpliter.Length; i++)
{
OrderMasterID = Convert.ToInt32(idSpliter[i].ToString());
OrderDetailID = Convert.ToInt32(idSpliter[i + 1].ToString());
break;
}
if (OrderMasterID > 0 && OrderDetailID > 0)
{
PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order();
Order.DeleteOrderItem(OrderMasterID, OrderDetailID);
lblErrorMessage.Text = "Item Deleted Successfuly.";
PopulateOrders(OrderMasterID);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["OrderMasterID"] != null && Request.QueryString["OrderMasterID"].ToString() != "")
{
// This is for Showing Full Invoice
long OrdermasterID = Convert.ToInt32(Request.QueryString["OrderMasterID"].ToString());
//long OrderDetailID = 0;
PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order();
if (Request.QueryString["Title"] == null || Request.QueryString["Title"].ToString() == "")
{
lblMainTitle.Text = "Order Slip";
}
else
{
lblMainTitle.Text = Request.QueryString["Title"].ToString();
}
lblDetailTitle.Text = "Order Details";
dtOrderEdit = Order.GetOrderByID(OrdermasterID);
if (dtOrderEdit.Rows.Count > 0)
{
lblOrderDate.Text = Convert.ToDateTime(dtOrderEdit.Rows[0]["OrderDate"].ToString()).ToShortDateString();
lblOrderNumber.Text = dtOrderEdit.Rows[0]["OrderNumber"].ToString();
try
{
lblDueDate.Text = Convert.ToDateTime(dtOrderEdit.Rows[0]["DueDate"].ToString()).ToShortDateString();
}
catch
{
lblDueDate.Text = "";
}
lblClientName.Text = dtOrderEdit.Rows[0]["ClientName"].ToString() + Environment.NewLine;
lblClientCompanyName.Text = dtOrderEdit.Rows[0]["ClientCompanyName"].ToString() + Environment.NewLine;
lblClientAddress.Text = dtOrderEdit.Rows[0]["ClientCompanyAddress"].ToString() + Environment.NewLine;
PCSN.InvoiceSystem.BusinessLogicLayer.OurCompany ourCompany = new PCSN.InvoiceSystem.BusinessLogicLayer.OurCompany();
DataTable dtOurCompany = new DataTable();
dtOurCompany = ourCompany.GetOurCompanyByID(Convert.ToInt32("1"));
if (dtOurCompany.Rows.Count > 0)
{
//txtOurCompanyID.Text = dtOurCompany.Rows[0]["ID"].ToString();
lblCompanyName.Text = dtOurCompany.Rows[0]["CompanyName"].ToString() + Environment.NewLine;
lblAddress.Text = dtOurCompany.Rows[0]["CompanyAddress"].ToString() + Environment.NewLine;
}
else
{
lblCompanyName.Text = "Power Protection System";
}
for (int a = 0; a < dtOrderEdit.Rows.Count; a++)
{
GenerateHTML += "<tr>" + Environment.NewLine;
GenerateHTML += "<td>" + Environment.NewLine;
//GenerateHTML += dtOrderEdit.Rows[a]["Item"].ToString() + Environment.NewLine;
GenerateHTML += "</td>" + Environment.NewLine;
GenerateHTML += "<td>" + Environment.NewLine;
GenerateHTML += dtOrderEdit.Rows[a]["Item"].ToString() + Environment.NewLine;
GenerateHTML += "</td>" + Environment.NewLine;
GenerateHTML += "<td align=\"justify\">" + Environment.NewLine;
GenerateHTML += dtOrderEdit.Rows[a]["Description"].ToString() + Environment.NewLine;
GenerateHTML += "</td>" + Environment.NewLine;
GenerateHTML += "<td id=\"quantity\">" + Environment.NewLine;
GenerateHTML += dtOrderEdit.Rows[a]["Quantity"].ToString() + Environment.NewLine;
GenerateHTML += "</td>" + Environment.NewLine;
GenerateHTML += "<td id=\"rate\">" + Environment.NewLine;
GenerateHTML += dtOrderEdit.Rows[a]["UnitPrice"].ToString() + Environment.NewLine;
GenerateHTML += "</td>" + Environment.NewLine;
GenerateHTML += "<td id=\"amount\">" + Environment.NewLine;
GenerateHTML += dtOrderEdit.Rows[a]["ItemAmount"].ToString() + Environment.NewLine;
GenerateHTML += "</td>" + Environment.NewLine;
GenerateHTML += "</tr>" + Environment.NewLine;
}
lblGrandTotdal.Text = dtOrderEdit.Rows[0]["TotalAmount"].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["OrderMasterID"] != null && Request.QueryString["OrderMasterID"].ToString() != "" && Request.QueryString["OrderDetailID"] != null && Request.QueryString["OrderDetailID"].ToString() != "" && !Page.IsPostBack)
{
// This is for Updating and ITEM in Order
long OrdermasterID = Convert.ToInt32(Request.QueryString["OrderMasterID"].ToString());
PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order();
txtOrderMasterID.Text = Request.QueryString["OrderMasterID"].ToString();
lblTotalAmount.Text = "0";
dtOrderEdit = Order.GetOrderByID(OrdermasterID);
for (int a = 0; a < dtOrderEdit.Rows.Count; a++)
{
if (dtOrderEdit.Rows[a]["OrderDetailID"].ToString() == Request.QueryString["OrderDetailID"].ToString())
{
lblDetailDate.Text = Convert.ToDateTime(dtOrderEdit.Rows[a]["OrderDate"].ToString()).ToShortDateString();
txtItem.Text = dtOrderEdit.Rows[a]["Item"].ToString();
txtItemID.Text = dtOrderEdit.Rows[a]["OrderDetailID"].ToString();
txtDescription.Text = dtOrderEdit.Rows[a]["Description"].ToString();
txtQuantity.Text = dtOrderEdit.Rows[a]["Quantity"].ToString();
txtUnitPrice.Text = dtOrderEdit.Rows[a]["UnitPrice"].ToString();
txtItemAmount.Text = dtOrderEdit.Rows[a]["ItemAmount"].ToString();
cboClientList.SelectedValue = dtOrderEdit.Rows[a]["ClientID"].ToString();
txtDueDate.Text = Convert.ToDateTime(dtOrderEdit.Rows[a]["DueDate"].ToString()).ToShortDateString();
//lblTotalAmount.Text = dtOrderEdit.Rows[a]["TotalAmount"].ToString();
if (dtOrderEdit.Rows[a]["ID"].ToString() != "")
{
PopulateOrders(Convert.ToInt32(dtOrderEdit.Rows[a]["ID"].ToString()));
}
}
lblTotalAmount.Text = Convert.ToString(Convert.ToInt32(lblTotalAmount.Text) + Convert.ToInt32(dtOrderEdit.Rows[a]["ItemAmount"].ToString()));
}
}
if (!Page.IsPostBack)
{
if (Request.QueryString["OrderMasterIDEdit"] != null && Request.QueryString["OrderMasterIDEdit"].ToString() != "")
{
txtOrderMasterID.Text = Request.QueryString["OrderMasterIDEdit"].ToString();
}
// txtOrderMasterID.Text = "16";
if (txtOrderMasterID.Text == "")
{
// This is when a Fresh Order is About to GeneUnitPrice
txtClient.Text = "Please Select a Client from Above List";
PCSN.InvoiceSystem.BusinessLogicLayer.OurCompany ourCompany = new PCSN.InvoiceSystem.BusinessLogicLayer.OurCompany();
dtOurCompany = ourCompany.GetOurCompanyByID(Convert.ToInt32("1"));
if (dtOurCompany.Rows.Count <= 0)
{
txtOurCompany.Text = "PC.Solutions.NET";
}
else
{
txtOurCompanyID.Text = dtOurCompany.Rows[0]["ID"].ToString();
txtOurCompany.Text = dtOurCompany.Rows[0]["CompanyName"].ToString() + Environment.NewLine;
txtOurCompany.Text = txtOurCompany.Text + dtOurCompany.Rows[0]["CompanyAddress"].ToString() + Environment.NewLine;
}
lblHeaderDate.Text = Convert.ToString(DateTime.Now.ToShortDateString());
lblDetailDate.Text = Convert.ToString(DateTime.Now.ToShortDateString());
PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order();
dtOrder = Order.GetAllOrderMAX();
if (dtOrder.Rows.Count == 0 || dtOrder.Rows[0]["ID"].ToString() == "")
{
lblOrderNumber.Text = "1";
}
else
{
lblOrderNumber.Text = Convert.ToInt32(Convert.ToInt32(dtOrder.Rows[0]["ID"].ToString()) + 1).ToString();
}
if (txtOrderMasterID.Text != "")
{
PopulateOrders(Convert.ToInt32(txtOrderMasterID.Text));
}
PopulateClients();
}
else
{
// This is when the Order ID is getting from somewhere
// Like from Query Strings
long OrdermasterID = Convert.ToInt32(txtOrderMasterID.Text.ToString());
lblOrderNumber.Text = OrdermasterID.ToString();
PopulateClients();
PopulateOrders(OrdermasterID);
PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order();
lblTotalAmount.Text = "0";
dtOrderEdit = Order.GetOrderByID(OrdermasterID);
for (int a = 0; a < dtOrderEdit.Rows.Count; a++)
{
if (dtOrderEdit.Rows[a]["ItemAmount"].ToString() == null || dtOrderEdit.Rows[a]["ItemAmount"].ToString() == "")
{
}
else
{
lblTotalAmount.Text = Convert.ToString(Convert.ToInt32(lblTotalAmount.Text) + Convert.ToInt32(dtOrderEdit.Rows[a]["ItemAmount"].ToString()));
}
}
if (dtOrderEdit.Rows.Count > 0)
{
//PopulateOrders(Convert.ToInt32(dtOrderEdit.Rows[0]["ID"].ToString()));
PCSN.InvoiceSystem.BusinessLogicLayer.Client client = new PCSN.InvoiceSystem.BusinessLogicLayer.Client();
dtClient = client.GetClientByID(Convert.ToInt32(dtOrderEdit.Rows[0]["ClientID"].ToString()));
if (dtClient.Rows.Count <= 0)
{
txtClient.Text = "Our Client";
}
else
{
cboClientList.SelectedValue = dtClient.Rows[0]["ID"].ToString();
txtClientID.Text = dtClient.Rows[0]["ID"].ToString();
txtClient.Text = dtClient.Rows[0]["ClientName"].ToString() + Environment.NewLine;
txtClient.Text = txtClient.Text + dtClient.Rows[0]["CompanyName"].ToString() + Environment.NewLine;
txtClient.Text = txtClient.Text + dtClient.Rows[0]["Address"].ToString() + Environment.NewLine;
}
txtOurCompanyID.Text = "1";
txtOurCompany.Text = "Power Protection Services" + Environment.NewLine;
txtOurCompany.Text = txtOurCompany.Text + "XYZ Address" + Environment.NewLine;
lblHeaderDate.Text = Convert.ToString(Convert.ToDateTime(dtOrderEdit.Rows[0]["OrderDate"].ToString()).ToShortDateString());
txtDueDate.Text = Convert.ToString(Convert.ToDateTime(dtOrderEdit.Rows[0]["DueDate"].ToString()).ToShortDateString());
lblDetailDate.Text = Convert.ToString(Convert.ToDateTime(dtOrderEdit.Rows[0]["OrderDate"].ToString()).ToShortDateString());
}
}
}
}
protected void btnSaveOrder_Click(object sender, EventArgs e)
{
PCSN.InvoiceSystem.BusinessLogicLayer.Order Order = new PCSN.InvoiceSystem.BusinessLogicLayer.Order();
long OrderMasterID = 0;
long OrderDetailID = 0;
if (txtItemID.Text == "")
{
// This runs When a new Order is Created or New Item Add in a Order
if (txtOrderMasterID.Text != "")
{
OrderMasterID = Convert.ToInt32(txtOrderMasterID.Text);
}
if (ValidateClientSide())
{
if (txtOrderMasterID.Text == "")
{
OrderMasterID = Order.InsertOrderMaster(Convert.ToInt32(lblOrderNumber.Text), lblHeaderDate.Text.ToString(), txtDueDate.Text.ToString(), Convert.ToInt32(txtClientID.Text), lblTotalAmount.Text.ToString());
txtOrderMasterID.Text = OrderMasterID.ToString();
}
else
{
OrderMasterID = Convert.ToInt32(txtOrderMasterID.Text);
}
if (OrderMasterID > 0)
{
txtOrderMasterID.Text = OrderMasterID.ToString();
OrderDetailID = Order.InsertOrderDetail(OrderMasterID, txtItem.Text.ToString(), txtDescription.Text.ToString(), Convert.ToInt32(txtQuantity.Text), Convert.ToInt32(txtUnitPrice.Text), Convert.ToInt32(txtItemAmount.Text));
dtOrderEdit = Order.GetOrderByID(OrderMasterID);
lblTotalAmount.Text = "0";
for (int a = 0; a < dtOrderEdit.Rows.Count; a++)
{
if (dtOrderEdit.Rows[a]["ItemAmount"].ToString() == null || dtOrderEdit.Rows[a]["ItemAmount"].ToString() == "")
{
}
else
{
lblTotalAmount.Text = Convert.ToString(Convert.ToInt32(lblTotalAmount.Text) + Convert.ToInt32(dtOrderEdit.Rows[a]["ItemAmount"].ToString()));
}
}
Order.UpdateOrderMaster(Convert.ToInt32(txtOrderMasterID.Text.ToString()), Convert.ToInt32(lblOrderNumber.Text.ToString()), lblHeaderDate.Text.ToString(), txtDueDate.Text.ToString(), Convert.ToInt32(txtClientID.Text.ToString()), lblTotalAmount.Text.ToString());
}
if (OrderMasterID > 0)
{
lblErrorMessage.Text = "This Item has been saved.";
if (lblTotalAmount.Text == "")
{
lblTotalAmount.Text = "0";
}
lblTotalAmount.Text = Convert.ToString(Convert.ToInt32(lblTotalAmount.Text) + Convert.ToInt32(txtItemAmount.Text));
ClearControlDetail();
}
}
}
else
{
// This runs when an Item is being Edited
if (ValidateClientSide())
{
if (txtOrderMasterID.Text != "")
{
OrderMasterID = Convert.ToInt32(txtOrderMasterID.Text);
Order.UpdateOrderDetail(Convert.ToInt32(txtItemID.Text), Convert.ToInt32(txtOrderMasterID.Text), txtItem.Text.ToString(), txtDescription.Text.ToString(), Convert.ToInt32(txtQuantity.Text), Convert.ToInt32(txtUnitPrice.Text), Convert.ToInt32(txtItemAmount.Text));
dtOrderEdit = Order.GetOrderByID(OrderMasterID);
lblTotalAmount.Text = "0";
for (int a = 0; a < dtOrderEdit.Rows.Count; a++)
{
if (dtOrderEdit.Rows[a]["ItemAmount"].ToString() == null || dtOrderEdit.Rows[a]["ItemAmount"].ToString() == "")
{
}
else
{
lblTotalAmount.Text = Convert.ToString(Convert.ToInt32(lblTotalAmount.Text) + Convert.ToInt32(dtOrderEdit.Rows[a]["ItemAmount"].ToString()));
}
}
Order.UpdateOrderMaster(Convert.ToInt32(txtOrderMasterID.Text.ToString()), Convert.ToInt32(lblOrderNumber.Text.ToString()), lblHeaderDate.Text.ToString(), txtDueDate.Text.ToString(), Convert.ToInt32(txtClientID.Text.ToString()), lblTotalAmount.Text.ToString());
}
lblErrorMessage.Text = "This Item has been Updated.";
ClearControlDetail();
}
}
if (OrderMasterID != 0)
{
PopulateOrders(OrderMasterID);
lblTotalAmount.Text = "0";
dtOrderEdit = Order.GetOrderByID(OrderMasterID);
for (int a = 0; a < dtOrderEdit.Rows.Count; a++)
{
if (dtOrderEdit.Rows[a]["ItemAmount"].ToString() == null || dtOrderEdit.Rows[a]["ItemAmount"].ToString() == "")
{
}
else
{
lblTotalAmount.Text = Convert.ToString(Convert.ToInt32(lblTotalAmount.Text) + Convert.ToInt32(dtOrderEdit.Rows[a]["ItemAmount"].ToString()));
}
}
}
}
