// Delete btn
protected void btnDelete_Click(object sender, EventArgs e)
{
HtmlButton btnDelete = (HtmlButton)sender;
id = Convert.ToInt32(btnDelete.Attributes["value"]);
if (id != -1)
{
try
{
DataRow record = dsOrder.on_orderCRUD.FindByid(id); // Find and add the record to tbe record variable
//Send Id using cookie, more seecure I presume
HttpCookie cID = new HttpCookie("ID"); // Cokkie variable named cID to hold a value
cID.Value = id.ToString();
HttpCookie action = new HttpCookie("Action"); // Cokkie variable named cID to hold a value
action.Value = "Delete";
Response.Cookies.Add(action);
Response.Cookies.Add(cID);
// Redirect the user to Edit page on btn click
on_orderTableAdapter daOrder = new on_orderTableAdapter(); // table adapter to service table (Service adapter)
//Refresh the page to show the record being deleted
//Response.Redirect(Request.RawUrl);
Response.Redirect("DeleteConfirmation.aspx");
}
catch
{
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.Identity.IsAuthenticated) //if not logged in
{
Response.Redirect("/");
}
try
{
dsOrder = new OrdersDataSet();
on_orderTableAdapter daOrder = new on_orderTableAdapter();
daOrder.Fill(dsOrder.on_order);
if (Request.Cookies["ID"] != null) // Request the cookies which contaions the ID Of thr record that was carried over from the index page
{
id = Convert.ToInt32(Request.Cookies["ID"].Value);
}
if (Request.Cookies["Action"] != null && Request.Cookies["Action"].Value == "Delete")
{
pnlDeleteConfirm.Visible = true;
lblTitle.Text = "Delete Order";
}
else
{
pnlDeleteConfirm.Visible = false;
}
}
catch { return; }
}
static ArrivedOrder()
{
on_orderTableAdapter daOrder = new on_orderTableAdapter();
try
{
daOrder.Fill(dsOrder.on_order);
}
catch { }
}
private void Save()
{
try
{
on_orderTableAdapter daOrder = new on_orderTableAdapter();
daOrder.Update(dsOrder.on_order); // Call update method on the service adapter so it updates the table in memory ( All changes made are applied - CRUD)
dsOrder.AcceptChanges(); // Call accept method on the dataset so it update the chanmges to the database
lblStatus.Text = "Record Successfully Updated";
}
catch
{
dsOrder.RejectChanges();
lblStatus.Text = "Unable to Update Record";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.Identity.IsAuthenticated) //if not logged in
{
Response.Redirect("/");
}
try
{
dsOrder = new OrdersDataSet();
on_orderTableAdapter daOrder = new on_orderTableAdapter();
daOrder.Fill(dsOrder.on_order);
if (Request.Cookies["ID"] != null) // Request the cookies which contaions the ID Of thr record that was carried over from the index page
{
id = Convert.ToInt32(Request.Cookies["ID"].Value);
}
}
catch { return; }
if (!IsPostBack)
{
if (id != -1)
{
try
{
DataRow order = dsOrder.on_order.FindByid(id); // Find the related Record and fill the fields in the page with the data
if (order != null)
{
this.txtID.Text = order.ItemArray[0].ToString();
this.txtInvoiceNumber.Text = order.ItemArray[1].ToString();
this.txtArriveDate.Text = Convert.ToDateTime(order.ItemArray[2]).ToString("yyyy-MM-dd");
this.txtNumberInOrder.Text = order.ItemArray[3].ToString();
this.txtPrice.Text = order.ItemArray[4].ToString();
this.ddlInventoryID.SelectedValue = order.ItemArray[5].ToString();
this.ddlProdOrderID.SelectedValue = order.ItemArray[6].ToString();
}
else
{
lblStatus.Text = "Please Try Again";
}
}
catch
{
lblStatus.Text = "Database Error";
}
}
}
}
private void Save()
{
on_orderTableAdapter daOrder = new on_orderTableAdapter();
try
{
daOrder.Update(dsOrder.on_order);
dsOrder.AcceptChanges();
this.lblStatus.Text = "Order Created";
Clear();
}
catch
{
dsOrder.RejectChanges();
this.lblStatus.Text = "Failed";
}
}
protected void btnDeleteConfirm_Click(object sender, EventArgs e)
{
if (id != -1)
{
try
{
DataRow record = dsOrder.on_order.FindByid(id); // Find and add the record to tbe record variable
record.Delete(); // Deletes the record in memory
on_orderTableAdapter daOrder = new on_orderTableAdapter(); // table adapter to service table (Service adapter)
daOrder.Update(record); // Call update method on the service adapter so it updates the table in memory ( All changes made are applied - CRUD)
dsOrder.AcceptChanges(); // Call accept method on the dataset so it update the chanmges to the database
//Refresh the page to show the record being deleted
Response.Redirect("ArrivedOrderDefaultPage.aspx");
}
catch
{
lblStatus.Text = "Delete failed.";
}
}
}
