//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);
}
}
protected void btnDeleteConfirm_Click(object sender, EventArgs e)
{
if (deleteId != -1)
{
try
{
DataRow record = repairsDataSet.service_order.FindByid(deleteId); // Find the requested record
record.Delete(); // Deletes the record in memory
service_orderTableAdapter daServiceOrder = new service_orderTableAdapter(); // table adapter to Repair table (Repair adapter)
daServiceOrder.Update(record); // Call update method on the Repair adapter so it updates the table in memory ( All changes made are applied - CRUD)
repairsDataSet.AcceptChanges(); // Call accept method on the dataset so it update the chanmges to the database
redirectMsg.Text = "✔ Record deleted";
//Refresh the page to show the record being deleted
Session["deleteMsg"] = "true";
}
catch
{
Session["deleteMsg"] = "false";
redirectMsg.Text = "❌ Record not deleted";
this.redirectMsg.ForeColor = Color.Red;
}
finally
{
Response.Redirect("default.aspx");
}
}
}
protected void btnStop_Click(object sender, EventArgs e)
{
if (id != -1)
{
try
{
service_orderTableAdapter daService_order = new service_orderTableAdapter();
daService_order.Fill(repairsDataSet.service_order);
DataRow record = repairsDataSet.service_order.FindByid(id); // find the related Record
//update the record with user's input
record[2] = (DateTime.Now).ToString();
service_orderTableAdapter daServiceOrder = new service_orderTableAdapter();
daServiceOrder.Update(record); // Call update method on the service adapter so it updates the table in memory ( All changes made are applied - CRUD)
repairsDataSet.AcceptChanges(); // Call accept method on the dataset so it update the chanmges to the database
//Send Id to details view
HttpCookie cID = new HttpCookie("ID"); // Cokkie variable named cID to hold a value
cID.Value = id.ToString();
Response.Cookies.Add(cID);
Session["editRedirect"] = "repairStoped"; // session for details view to see if its a redirect or not
Response.Redirect("details.aspx"); // Redirect the user to Edit page on btn click
}
catch
{
this.Label1.Visible = true;
this.Label1.Text = "❌ Record Updation Failed";
this.Label1.ForeColor = Color.Red;
}
}
}
static NewRepair()
{
RepairsDataSet = new RepairsDataSet();
service_orderTableAdapter daServiceOrder = new service_orderTableAdapter();
try
{
daServiceOrder.Fill(RepairsDataSet.service_order);
}
catch { }
}
static RepairSearch()
{
//load data at the beginning of the session
dsRepair = new dsRepairSearch();
service_orderTableAdapter daRepair = new service_orderTableAdapter();
service_orderUpdateTableAdapter daRepairUpdate = new service_orderUpdateTableAdapter();
try
{
daRepair.Fill(dsRepair.service_order);
daRepairUpdate.Fill(dsRepair.service_orderUpdate);
}
catch { }
}
protected void btnCreate_Click(object sender, EventArgs e)
{
if (Repairvalidation())
{
try
{
DataRow serviceOrder = RepairsDataSet.service_order.NewRow(); // Create a new row of service_order table in memory
//update record with user's input
serviceOrder[3] = this.txtIssue.Text;
if (this.radInWarranty.Checked)
{
serviceOrder[4] = 1;
}
else
{
serviceOrder[4] = 0;
}
serviceOrder[5] = this.ddlReceipt.SelectedValue;
serviceOrder[6] = this.ddlService.SelectedValue;
serviceOrder[7] = this.ddlEquipment.SelectedValue;
serviceOrder[8] = this.ddlEmployee.SelectedValue;
RepairsDataSet.service_order.Rows.Add(serviceOrder); // add the rows to the dataset
service_orderTableAdapter daSericeOrder = new service_orderTableAdapter();
daSericeOrder.Update(serviceOrder); // Call update method on the service adapter so it updates the table in memory ( All changes made are applied - CRUD)
RepairsDataSet.AcceptChanges(); // Call accept method on the dataset so it update the chanmges to the database
//Send Id to details view to show added record
HttpCookie cID = new HttpCookie("ID"); // Cokkie variable named cID to hold a value
cID.Value = serviceOrder[0].ToString(); // get the id of the newly added row/record
Response.Cookies.Add(cID);
Session["createRedirect"] = true; // session for details view to see if its a redirect or not
Response.Redirect("details.aspx");
}
catch
{
this.lblStatus.Visible = true;
this.lblStatus.Text = "❌ Record Creation Failed";
}
}
}
//save new repair ticket
private void Save()
{
service_orderUpdateTableAdapter daRepairUpdate = new service_orderUpdateTableAdapter();
service_orderTableAdapter daRepair = new service_orderTableAdapter();
try
{
daRepairUpdate.Update(dsRepair.service_orderUpdate);
dsRepair.AcceptChanges();
dsRepair.service_order.Clear();
daRepair.Fill(dsRepair.service_order);
this.lblSave.Text = "Data Saved. Repair ticket created.";
}
catch
{
dsRepair.RejectChanges();
this.lblSave.Text = "Unable to update";
}
}
protected void lstSearchResult_SelectedIndexChanged(object sender, EventArgs e)
{
this.Clear("lstsearch");
int id = Convert.ToInt32(lstSearchResult.SelectedValue);
service_orderTableAdapter daServiceOrder = new service_orderTableAdapter();
rows = daServiceOrder.GetData().Select("custID = " + id.ToString());
foreach (DataRow r in rows)
{
ListItem item = new ListItem();
DateTime d = Convert.ToDateTime(r.ItemArray[1].ToString());
item.Text = "Order Number: " + r.ItemArray[0].ToString() + " - Date: " + d.ToShortDateString();
item.Value = r.ItemArray[0].ToString();
this.lstOrders.Items.Add(item);
}
Session["OrderSearchClass"] = "collapse";
Session["CustomerSearchClass"] = "in";
Session["VendorSearchClass"] = "collapse";
}
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) { }
}
//Edit btn
protected void btnCreate_Click(object sender, EventArgs e)
{
//check a record has been selected
if (id != -1 && Repairvalidation())
{
try
{
DataRow record = repairsDataSet.service_order.FindByid(id); // find the related Record
//update the record with user's input
record[3] = this.txtIssue.Text;
if (this.radInWarranty.Checked)
{
record[4] = 1;
}
else
{
record[4] = 0;
}
record[5] = this.ddlReceipt.SelectedValue;
record[6] = this.ddlService.SelectedValue;
record[7] = this.ddlEquipment.SelectedValue;
record[8] = this.ddlEmployee.SelectedValue;
service_orderTableAdapter daServiceOrder = new service_orderTableAdapter();
daServiceOrder.Update(record); // Call update method on the service adapter so it updates the table in memory ( All changes made are applied - CRUD)
repairsDataSet.AcceptChanges(); // Call accept method on the dataset so it update the chanmges to the database
//Send Id to details view
HttpCookie cID = new HttpCookie("ID"); // Cokkie variable named cID to hold a value
cID.Value = id.ToString();
Response.Cookies.Add(cID);
Session["editRedirect"] = "true"; // session for details view to see if its a redirect or not
Response.Redirect("details.aspx"); // Redirect the user to Edit page on btn click
}
catch
{
this.Label1.Visible = true;
this.Label1.Text = "❌ Record Updation Failed";
this.Label1.ForeColor = Color.Red;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
{
service_orderTableAdapter daServ = new service_orderTableAdapter();
try
{
daServ.Fill(dsRepair.service_order);
}
catch { }
foreach (DataRow r in dsRepair.service_order)
{
MakeTable(r);
}
}
}
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 Page_Load(object sender, EventArgs e)
{
if (User.Identity.IsAuthenticated)
{
pnlHide.Visible = true;
}
else
{
Response.Redirect("~/Login.aspx");
}
pnlEdit.Visible = false;
pnlSearch.Visible = true;
btnBack.Visible = false;
service_orderTableAdapter daRepair = new service_orderTableAdapter();
daRepair.Fill(dsRepair.service_order);
dsRepair.GetChanges();
service_orderUpdateTableAdapter daRepairUpdate = new service_orderUpdateTableAdapter();
daRepairUpdate.Fill(dsRepair.service_orderUpdate);
gvRepair.AllowSorting = false;
}
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");
}
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
{
this.Label1.Text = Request.Cookies["ID"].Value;
}
id = Convert.ToInt32(Request.Cookies["ID"].Value);
if (!IsPostBack)
{
if (id != -1)
{
try
{
service_orderTableAdapter daServiceOrder = new service_orderTableAdapter();
daServiceOrder.Fill(repairsDataSet.service_order);
DataRow record = repairsDataSet.service_order.FindByid(id); // Find the related Record and fill the fields in the page with the data
if (record != null)
{
this.txtIssue.Text = record.ItemArray[3].ToString();
if (record.ItemArray[4].ToString() == "False")
{
this.radNoWarranty.Checked = true;
}
else
{
this.radInWarranty.Checked = true;
}
this.ddlReceipt.SelectedValue = record.ItemArray[5].ToString();
this.ddlService.SelectedValue = record.ItemArray[6].ToString();
this.ddlEquipment.SelectedValue = record.ItemArray[7].ToString();
this.ddlEmployee.SelectedValue = record.ItemArray[8].ToString();
}
else
{
// this.Clear();
this.Label1.Visible = true;
this.Label1.Text = "❌ Please Try Again";
}
}
catch
{
this.Label1.Visible = true;
this.Label1.Text = "❌ Database Eror, Contact System Administrator";
this.Label1.ForeColor = Color.Red;
}
}
}
else
{
Repairvalidation();
}
}
static EditRepair()
{
repairsDataSet = new RepairsDataSet();
service_orderTableAdapter daServiceOrder = new service_orderTableAdapter();
}
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";
}
}
}
