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";
}
}
}
