protected void btnSearch_Click(object sender, EventArgs e) { RepairLookUpTableAdapter daRepair = new RepairLookUpTableAdapter(); daRepair.Fill(RepairsDataSet.RepairLookUp); if (RepairsDataSet.RepairLookUp.Count > 0) { string criteria = FilterCriteria(); // Save the criteria in the session, so that when filtered the rows contains the filtered records instead of the fresh table Session["RepairCriteria"] = FilterCriteria(); rows = (criteria.Length > 0) ? RepairsDataSet.RepairLookUp.Select(criteria) : RepairsDataSet.RepairLookUp.Select(); // Data satisfying the conditions is saved in rows DisplayRepairTable(); Response.Redirect("default.aspx"); } else { this.Label1.Text = "No Records Matching The Filter Was Found"; this.Label1.ForeColor = Color.Red; } }
protected void Page_Load(object sender, EventArgs e) { if (!User.Identity.IsAuthenticated) //if not logged in { Response.Redirect("/"); } try { // Refresh the dataset so all updates are shown on page refresh RepairLookUpTableAdapter daRepair = new RepairLookUpTableAdapter(); service_orderTableAdapter daServiceOrder = new service_orderTableAdapter(); daRepair.Fill(RepairsDataSet.RepairLookUp); daServiceOrder.Fill(RepairsDataSet.service_order); } catch { this.Label1.Text = " ❌ Failed to load Data, Please Contact the system administrator"; this.Label1.ForeColor = Color.Red; return; } // Set the criteria so that the grid is refreshed Session["ServiceCriteria"] = null; Session["editRedirect"] = null; Session["createRedirect"] = null; Session["Resumed"] = null; Session["Paused"] = null; Session["deleteId"] = null; if (Session["deleteMsg"] != null) { if (Session["deleteMsg"].ToString() == "true") { this.lblDeleteMsg.Visible = true; this.lblDeleteMsg.Text = "✔ Record deleted Successfully"; Session["deleteMsg"] = null; } else { this.lblDeleteMsg.Visible = true; this.lblDeleteMsg.Text = "❌ Record not deleted. Please check if this record is related to any sales"; Session["deleteMsg"] = null; this.lblDeleteMsg.ForeColor = Color.Red; } } try { //get records rows = (Session["RepairCriteria"] != null) ? RepairsDataSet.RepairLookUp.Select(Session["RepairCriteria"].ToString()) //has criteria : RepairsDataSet.RepairLookUp.Select(); //select all } catch { this.Label1.Text = "❌ Database Error,Please try again"; this.Label1.ForeColor = Color.Red; return; } DisplayRepairTable(); }
protected void Page_Load(object sender, EventArgs e) { if (!User.Identity.IsAuthenticated) //if not logged in { Response.Redirect("/"); } if (Request.Cookies["ID"] != null) // Request the cookies which contaions the ID Of thr record that was carried over from the index page { 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 (Session["deleteId"] != null) { deleteId = Convert.ToInt32(Session["deleteId"]); this.pnlDeleteConfirm.Visible = true; } if (Session["editRedirect"] != null) { this.redirectMsg.Visible = true; if (Session["editRedirect"].ToString() == "true") { this.redirectMsg.Text = "✔ Record Successfully Updated"; } else if (Session["editRedirect"].ToString() == "repairStarted") { this.redirectMsg.Text = "✔ Repair Timer Started"; } else if (Session["editRedirect"].ToString() == "repairPaused") { this.redirectMsg.Text = "✔ Repair Timer Started"; } else if (Session["editRedirect"].ToString() == "repairResumed") { this.redirectMsg.Text = "✔ Repair Timer Resumed"; } else { this.redirectMsg.Text = "✔ Repair Timer Stoped"; } } if (Session["createRedirect"] != null) { this.redirectMsg.Visible = true; this.redirectMsg.ForeColor = Color.Green; this.redirectMsg.Text = "✔ Record Successfully Created"; } if (id != -1) { try { RepairLookUpTableAdapter daRepair = new RepairLookUpTableAdapter(); daRepair.Fill(repairsDataSet.RepairLookUp); service_orderTableAdapter daServiceOrder = new service_orderTableAdapter(); daRepair.Fill(repairsDataSet.RepairLookUp); daServiceOrder.Fill(repairsDataSet.service_order); DataRow record = repairsDataSet.RepairLookUp.FindByid(id); // Find the related Record and fill the fields in the page with the data if (record != null) { if (record.ItemArray[8].ToString() != "") { this.lblDateIn.Text = Convert.ToDateTime(record.ItemArray[7].ToString()).ToString("dddd, dd MMMM yyyy"); this.lblDateOut.Text = Convert.ToDateTime(record.ItemArray[8].ToString()).ToString("dddd, dd MMMM yyyy"); this.lblStatus.Text = "Repair Finished"; this.lblStatus.ForeColor = Color.Green; //display none of the btn if finished this.btnStop.Visible = false; this.btnStart.Visible = false; this.btnPause.Visible = false; this.btnResume.Visible = false; this.lblStart.Text = Convert.ToDateTime(record.ItemArray[7]).ToString("dddd, dd MMMM yyyy hh:mm tt"); this.lblStop.Text = Convert.ToDateTime(record.ItemArray[8]).ToString("dddd, dd MMMM yyyy hh:mm tt"); if (Session["Resumed"] != null) { this.lblpaused.Text = Session["Resumed"].ToString(); this.Label15.Visible = true; this.lblpaused.Visible = true; } if (Session["Paused"] != null) { this.lblResumed.Text = Session["Paused"].ToString(); this.Label19.Visible = true; this.lblResumed.Visible = true; } this.Label20.Visible = true; this.lblStart.Visible = true; this.Label21.Visible = true; this.lblStop.Visible = true; } else if ((record.ItemArray[8].ToString() == "") && (record.ItemArray[7].ToString() != "")) { this.lblDateIn.Text = Convert.ToDateTime(record.ItemArray[7].ToString()).ToShortDateString(); this.lblStart.Text = Convert.ToDateTime(record.ItemArray[7]).ToString("dddd, dd MMMM yyyy hh:mm tt"); this.lblDateOut.Text = "Repari in progress"; this.lblStatus.Text = "Repari in progress"; this.lblStatus.ForeColor = Color.Orange; this.btnStart.Visible = false; this.btnResume.Visible = false; this.btnStop.Visible = true; this.btnPause.Visible = true; this.Label20.Visible = true; this.lblStart.Visible = true; if (Session["Paused"] != null) { this.btnPause.Visible = false; //display pasue and stop btns if in progress this.btnResume.Visible = true; this.lblStatus.Text = "Repair Paused"; this.lblpaused.Text = Session["Paused"].ToString(); this.Label15.Visible = true; this.lblpaused.Visible = true; } if (Session["Resumed"] != null) { this.btnStart.Visible = false; this.btnPause.Visible = false; this.btnResume.Visible = false; this.btnStop.Visible = true; this.Label19.Visible = true; this.lblResumed.Visible = true; this.lblStatus.Text = "Reparir in progress"; this.lblResumed.Text = Session["Paused"].ToString(); } } else { this.lblDateIn.Text = "Repair not started"; this.lblDateOut.Text = "Repair not started"; this.lblStatus.Text = "Repair not started"; this.lblStatus.ForeColor = Color.Red; this.btnResume.Visible = false; this.btnPause.Visible = false; this.btnStop.Visible = false; this.btnStart.Visible = true; this.Label20.Visible = false; this.lblStart.Visible = false; this.Label15.Visible = false; this.lblpaused.Visible = false; this.Label19.Visible = false; this.lblResumed.Visible = false; this.Label21.Visible = false; this.lblStop.Visible = false; } this.lblssue.Text = record.ItemArray[1].ToString(); if (record.ItemArray[2].ToString() == "False") { this.lblWarranty.Text = "❌"; } else { this.lblWarranty.Text = "✔"; } this.lblService.Text = record.ItemArray[3].ToString(); this.lblEmployee.Text = record.ItemArray[5].ToString(); this.lblEquipmentType.Text = record.ItemArray[6].ToString(); this.lblEquipmentModel.Text = record.ItemArray[10].ToString(); this.lblEquipmentSerial.Text = record.ItemArray[11].ToString(); this.lblEquipmentManufacturer.Text = record.ItemArray[19].ToString(); this.lblCustomerFirst.Text = record.ItemArray[12].ToString(); this.lblCustomerLast.Text = record.ItemArray[14].ToString(); this.lblCustomerPhone.Text = record.ItemArray[13].ToString(); this.lblCustomerEmail.Text = record.ItemArray[18].ToString(); this.lblCustomerAddress.Text = record.ItemArray[15].ToString(); this.lblCustomerCity.Text = record.ItemArray[16].ToString(); this.lblCustomerPostal.Text = record.ItemArray[17].ToString(); } else { // this.Clear(); Label1.Text = "❌ Please Try Again"; } } catch { Label1.Text = "❌ Database Eror, Contact System Administrator"; } } }