//save change to database
private bool Save()
{
equipmentModifyTableAdapter equipmentModifyTableAdapter = new equipmentModifyTableAdapter();
order_lineTableAdapter order_LineTableAdapter = new order_lineTableAdapter();
service_orderTableAdapter service_OrderTableAdapter = new service_orderTableAdapter();
receiptModifyTableAdapter receiptModifyTableAdapter = new receiptModifyTableAdapter();
customerModifyTableAdapter customerModifyTableAdapter = new customerModifyTableAdapter();
try
{
order_LineTableAdapter.Update(dsSales.order_line);
service_OrderTableAdapter.Update(dsSales.service_order);
receiptModifyTableAdapter.Update(dsSales.receiptModify);
equipmentModifyTableAdapter.Update(dsSales.equipmentModify);
customerModifyTableAdapter.Update(dsSales.customerModify);
dsSales.AcceptChanges();
dsSales.customerModify.Clear();
dsSales.receiptModify.Clear();
dsSales.order_line.Clear();
dsSales.service_order.Clear();
dsSales.equipmentModify.Clear();
customerModifyTableAdapter.Fill(dsSales.customerModify);
receiptModifyTableAdapter.Fill(dsSales.receiptModify);
order_LineTableAdapter.Fill(dsSales.order_line);
service_OrderTableAdapter.Fill(dsSales.service_order);
equipmentModifyTableAdapter.Fill(dsSales.equipmentModify);
return(true);
}
catch
{
dsSales.RejectChanges();
return(false);
}
}
static SalesReceipt()
{
ProductsTableAdapter productsTableAdapter = new ProductsTableAdapter();
servicesTableAdapter servicesTableAdapter = new servicesTableAdapter();
receiptModifyTableAdapter receiptModifyTableAdapter = new receiptModifyTableAdapter();
order_lineTableAdapter order_LineTableAdapter = new order_lineTableAdapter();
try
{
receiptModifyTableAdapter.Fill(dsSales.receiptModify);
productsTableAdapter.Fill(dsSales.Products);
servicesTableAdapter.Fill(dsSales.services);
order_LineTableAdapter.Fill(dsSales.order_line);
}
catch (Exception) { }
}
//method to save changes back to the order_line table
private bool SaveOrder()
{
order_lineTableAdapter order_LineTableAdapter = new order_lineTableAdapter();
try
{
order_LineTableAdapter.Update(dsSales.order_line);
dsSales.AcceptChanges();
dsSales.order_line.Clear();
order_LineTableAdapter.Fill(dsSales.order_line);
return(true);
}
catch
{
dsSales.RejectChanges();
return(false);
}
}
static SalesSearch()
{
dsSales = new dsSales();
customerModifyTableAdapter customerModifyTableAdapter = new customerModifyTableAdapter();
equipmentModifyTableAdapter equipmentModifyTableAdapter = new equipmentModifyTableAdapter();
receiptModifyTableAdapter receiptModifyTableAdapter = new receiptModifyTableAdapter();
order_lineTableAdapter order_LineTableAdapter = new order_lineTableAdapter();
service_orderTableAdapter service_OrderTableAdapter = new service_orderTableAdapter();
try
{
customerModifyTableAdapter.Fill(dsSales.customerModify);
equipmentModifyTableAdapter.Fill(dsSales.equipmentModify);
receiptModifyTableAdapter.Fill(dsSales.receiptModify);
order_LineTableAdapter.Fill(dsSales.order_line);
service_OrderTableAdapter.Fill(dsSales.service_order);
}
catch (Exception) { }
}
static Purchase()
{
receiptTableAdapter daReceipt = new receiptTableAdapter();
daReceipt.Fill(dsReceipt.receipt);
employeeTableAdapter daEmployee = new employeeTableAdapter();
daEmployee.Fill(dsReceipt.employee);
productTableAdapter daProducts = new productTableAdapter();
productTable = daProducts.GetData();
order_lineTableAdapter daLine = new order_lineTableAdapter();
daLine.Fill(dsReceipt.order_line);
service_orderTableAdapter daService = new service_orderTableAdapter();
daService.Fill(dsReceipt.service_order);
equipmentTableAdapter daEqu = new equipmentTableAdapter();
daEqu.Fill(dsReceipt.equipment);
}
protected void submit_Click(object sender, EventArgs e)
{
DataRow r = dsReceipt.receipt.NewRow();
r["custID"] = ListBox2.SelectedValue;
r["empID"] = dsReceipt.employee.Select("empLogin = '******'")[0]["id"];
r["ordDate"] = DateTime.Now;
r["paymentID"] = ddlPayment.SelectedValue;
dsReceipt.receipt.Rows.Add(r);
object adapter = null;
List <DataRow> ChildRows = new List <DataRow>();
DataTable childTable = null;
if (Mode == PageMode.Sale)
{
childTable = dsReceipt.order_line;
for (int i = 0; i < selectedProducts?.Rows.Count; i++)
{
if (Convert.ToInt32(Request.Form["ctl00$MainContent$gvSelectedProductsSales$ctl0" + (i + 2).ToString() + "$TextBox1"]) > 0)
{
DataRow l = dsReceipt.order_line.NewRow();
l["inventoryID"] = selectedProducts.Rows[i]["id"];
l["orlQuantity"] = Request.Form["ctl00$MainContent$gvSelectedProductsSales$ctl0" + (i + 2).ToString() + "$TextBox1"];
l["orlOrderReq"] = Convert.ToInt16(l["orlQuantity"]) > Convert.ToInt32(selectedProducts.Rows[i]["Stock"]);
l["orlPrice"] = Convert.ToBoolean(l["orlOrderReq"]) ? Convert.ToDouble(selectedProducts.Rows[i]["Price"]) * 1.01 : Convert.ToDouble(selectedProducts.Rows[i]["Price"]);
ChildRows.Add(l);
}
}
adapter = new order_lineTableAdapter();
if (ChildRows.Count == 0)
{
dsReceipt.RejectChanges();
lblError.Text = "Please select at least one item to purchase";
return;
}
}
else if (Mode == PageMode.Repair)
{
childTable = dsReceipt.service_order;
DataRow eq = dsReceipt.equipment.NewRow();
eq["equModel"] = txtModel.Text;
eq["equSerial"] = txtSerialNumber.Text;
eq["custID"] = r["custID"];
eq["equtypeID"] = ddlType.SelectedValue;
eq["equManuID"] = ddlManu.SelectedValue;
dsReceipt.equipment.Rows.Add(eq);
equipmentTableAdapter daEqu = new equipmentTableAdapter();
daEqu.Update(dsReceipt.equipment);
DataRow so = dsReceipt.service_order.NewRow();
so["serordDateIn"] = DateTime.Now;
so["serordIssue"] = RD.Text;
so["serordWarranty"] = RadioButtonList1.SelectedValue == "1";
so["serviceID"] = ddlService.SelectedValue;
//for reasons passing understanding,
//the equipment table adapter does not update the id column in the dataset,
//while the receipt adapter does
so["equipID"] = Convert.ToInt32(dsReceipt.equipment.Max(row => row["id"])) + 1;
ChildRows.Add(so);
adapter = new service_orderTableAdapter();
}
receiptTableAdapter daReceipt = new receiptTableAdapter();
daReceipt.Update(dsReceipt.receipt);
foreach (DataRow cr in ChildRows)
{
cr["receiptId"] = r["id"];
childTable.Rows.Add(cr);
}
if (adapter is service_orderTableAdapter daService)
{
daService.Update(dsReceipt.service_order);
}
else if (adapter is order_lineTableAdapter daOrder)
{
daOrder.Update(dsReceipt.order_line);
}
dsReceipt.AcceptChanges();
Response.Redirect("~/Default");
}
