protected void btnStatus_Click(object sender, EventArgs e)
{
HtmlButton btnStatus = (HtmlButton)sender;
string receiptID = btnStatus.Attributes["value"];
DataRow sale = dsSales.Receipt.Select("id = " + receiptID)[0];
if (!(bool)sale.ItemArray[3]) //if not paid
{
sale["ordPaid"] = true;
daReceipt.Update(dsSales.Receipt);
dsSales.AcceptChanges();
}
else if (User.IsInRole("Admin"))
{
sale["ordPaid"] = false;
daReceipt.Update(dsSales.Receipt);
dsSales.AcceptChanges();
}
btnStatus.InnerText = "Paid";
if (!User.IsInRole("Admin")) //if not admin
{
btnStatus.Attributes.Add("disabled", "disabled");
}
}
protected void btnDeleteConfirm_Click(object sender, EventArgs e)
{
DataRow[] orders = sale.GetChildRows("fk_orderline_receipt");
DataRow[] repairs = sale.GetChildRows("fk_serord_receipt");
foreach (DataRow o in orders)
{
o.Delete();
}
foreach (DataRow r in repairs)
{
r.Delete();
}
daOL.Update(dsSales.OrderLine);
daServiceOrder.Update(dsSales.ServiceOrder);
sale.Delete();
daReceipt.Update(dsSales.Receipt);
dsSales.AcceptChanges();
Response.Redirect("~/Sales/");
}
protected void btnModify_Click(object sender, EventArgs e)
{
if (ddlCustomer.SelectedValue == "" || ddlPayment.SelectedValue == "")
{
return;
}
Dictionary <int, Order> orders = (Dictionary <int, Order>)Session["newOrders"]; //get saved orders
DataRow sale;
if (Request.QueryString["Mode"] != "Edit")
{
DateTime now = DateTime.Now;
sale = dsSales.Receipt.NewRow();
sale["ordNumber"] = now.ToString("MMddHHmm");
sale["ordPaid"] = false;
sale["empID"] = ddlEmployee.SelectedValue;
}
else
{
sale = dsSales.Receipt.FindByid(Convert.ToInt32(Request.QueryString["ID"]));
}
sale["ordDate"] = txtDate.Text;
sale["paymentID"] = ddlPayment.SelectedValue;
sale["custID"] = ddlCustomer.SelectedValue;
if (Request.QueryString["Mode"] != "Edit")
{
dsSales.Receipt.Rows.Add(sale);
}
daReceipts.Update(dsSales.Receipt);
if (lsbOrders.Items.Count > 0)
{
foreach (Order order in orders.Values)
{
DataRow nrOrder = dsSales.OrderLine.NewRow();
DataRow inv = dsSales.Inventory.Select("productID = " + order.productID)[0];
int stock = Convert.ToInt32(inv.ItemArray[1]);
double invPrice = Convert.ToDouble(inv.ItemArray[4]);
int inventoryID = Convert.ToInt32(inv.ItemArray[0]);
if (order.qty <= stock)
{
nrOrder["orlPrice"] = invPrice * order.qty * 1.11; //price +10% +1%
nrOrder["orlQuantity"] = order.qty; //quantity
nrOrder["orlOrderReq"] = false; //not new order
nrOrder["orlNote"] = order.note; //note
nrOrder["inventoryID"] = inventoryID; //inventoryID
nrOrder["receiptID"] = sale.ItemArray[0]; //receiptID
//update orderline
dsSales.OrderLine.Rows.Add(nrOrder);
//update inventory
inv["invQuantity"] = stock - order.qty;
}
else
{
//in stock part
nrOrder["orlPrice"] = invPrice * stock * 1.11; //price (in stock part) +10% +1%
nrOrder["orlQuantity"] = stock; //quantity (in stock part)
nrOrder["orlOrderReq"] = false; //in stock part
nrOrder["orlNote"] = order.note + " (In Stock)"; //note
nrOrder["inventoryID"] = inventoryID; //inventoryID
nrOrder["receiptID"] = sale.ItemArray[0]; //receiptID
//update db
dsSales.OrderLine.Rows.Add(nrOrder);
//Order New part
DataRow orderNew = dsSales.OrderLine.NewRow();
orderNew["orlPrice"] = invPrice * (order.qty - stock) * 1.01; //price (Order New part) +1%
orderNew["orlQuantity"] = order.qty - stock; //quantity (Order New part)
orderNew["orlOrderReq"] = true; //Order New part
orderNew["orlNote"] = order.note + " (Order New)"; //note
orderNew["inventoryID"] = inventoryID; //inventoryID
orderNew["receiptID"] = sale.ItemArray[0]; //receiptID
//update orderline
dsSales.OrderLine.Rows.Add(orderNew);
//update inventory
inv["invQuantity"] = 0;
}
}
}
daOL.Update(dsSales.OrderLine);
daInventory.Update(dsSales.Inventory);
dsSales.AcceptChanges();
Response.Redirect("SaleRecord.aspx?ID=" + sale.ItemArray[0].ToString());
}
