protected void btnSearch_Click(object sender, EventArgs e) { try { string query = "SELECT * FROM Customer WHERE Customer_Id = '" + int.Parse(txtId.Text) + "'"; dataTransfere = new busMethods(); table = new DataTable(); dataSet = new DataSet(); con = new SqlConnection(); con = dataTransfere.Connect(); con.Open(); using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query, con); adapter.SelectCommand = cmd; adapter.Fill(dataSet, "Customer"); table = dataSet.Tables["Customer"]; foreach (DataRow row in table.Rows) { txtName.Text = row["CustName"].ToString(); txtSname.Text = row["CustSurname"].ToString(); txtCell.Text = row["PhoneNumber"].ToString(); txtAddr.Text = row["Address"].ToString(); } } con.Close(); } catch (Exception ex) { ex.ToString(); } }
protected void btnDel_Click(object sender, EventArgs e) { try { string query = "DELETE FROM Customer WHERE Customer_Id = @Customer_Id"; dataTransfere = new busMethods(); table = new DataTable(); dataSet = new DataSet(); con = new SqlConnection(); con = dataTransfere.Connect(); con.Open(); using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@Customer_Id", int.Parse(txtId.Text)); cmd.ExecuteNonQuery(); Response.Write("<script>alert('Record Deleted')</script>"); } } catch (Exception ex) { ex.ToString(); } }
protected void btnReport_Click(object sender, EventArgs e) { try { string query = "INSERT INTO Report (ReportId,BusNo,TripId,Date,Time) VALUES(@ReportId,@BusNo,@TripId,@Date,@Time)"; dataTransfere = new busMethods(); con = new SqlConnection(); con = dataTransfere.Connect(); con.Open(); using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@ReportId", int.Parse(txtTrip_ID.Text)); cmd.Parameters.AddWithValue("@BusNo", int.Parse(txtBus_No.Text)); cmd.Parameters.AddWithValue("@TripId", int.Parse(txtTrip_ID.Text)); cmd.Parameters.AddWithValue("@Date", DateTime.Now.Date.ToString()); cmd.Parameters.AddWithValue("@Time", DateTime.Now.TimeOfDay.ToString()); } } catch (Exception ex) { ex.ToString(); } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { string query = "UPDATE Customer SET CustName = @CustName, CustSurname = @CustSurname,Address = @Address ,PhoneNumber = @PhoneNumber WHERE Customer_Id = @Customer_Id"; dataTransfere = new busMethods(); con = new SqlConnection(); con = dataTransfere.Connect(); con.Open(); using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@Customer_Id", int.Parse(txtId.Text)); cmd.Parameters.AddWithValue("@CustName", txtName.Text); cmd.Parameters.AddWithValue("@CustSurname", txtSname.Text); cmd.Parameters.AddWithValue("@Address", txtAddr.Text); cmd.Parameters.AddWithValue("@PhoneNumber", txtCell.Text); cmd.ExecuteNonQuery(); Response.Write("<script>alert('Record Updated')</script>"); } con.Close(); } catch (Exception ex) { ex.ToString(); } }
protected void Button1_Click(object sender, EventArgs e) { con = new SqlConnection(); dataSet = new DataSet(); dataTransfere = new busMethods(); con = dataTransfere.Connect(); con.Open(); try { string query = "SELECT username,password FROM Login "; using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query, con); adapter.SelectCommand = cmd; adapter.Fill(dataSet, "Login"); table = new DataTable(); table = dataSet.Tables["Login"]; foreach (DataRow row in table.Rows) { //for passanger if (row["username"].ToString().Equals(txtUser.Text) && row["password"].ToString().Equals(txtPass.Text)) { Response.Redirect("~/payment.aspx"); } } } } catch (Exception ex) { ex.ToString(); } }
protected void btnSeacrh_Click(object sender, EventArgs e) { try { string query = "SELECT BusNo,time,price FROM AllocateBusToTrip,Tri WHERE AllocateBusToTrip.TripId = Tri.TripId AND Tri.location = '" + DropDownList1.SelectedValue.ToString() + "' AND Tri.Destination = '" + DropDownList2.SelectedValue.ToString() + "' "; dataTransfere = new busMethods(); table = new DataTable(); dataSet = new DataSet(); con = new SqlConnection(); con = dataTransfere.Connect(); con.Open(); using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query, con); adapter.SelectCommand = cmd; adapter.Fill(dataSet, "AllocateBusToTrip,Tri"); table = dataSet.Tables["AllocateBusToTrip,Tri"]; GridView1.DataSource = table; GridView1.DataBind(); } con.Close(); } catch (Exception ex) { ex.ToString(); } }
protected void btnSearch_Click(object sender, EventArgs e) { try { string query = "SELECT * FROM Bus WHERE BusNo = '" + int.Parse(txtBusNumber.Text) + "' "; dataSet = new DataSet(); table = new DataTable(); dataTransfere = new busMethods(); con = new SqlConnection(); con = dataTransfere.Connect(); con.Open(); using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query, con); adapter.SelectCommand = cmd; adapter.Fill(dataSet, "Bus"); table = dataSet.Tables["Bus"]; foreach (DataRow row in table.Rows) { txtRegNo.Text = row["RegNo"].ToString(); txtModel.Text = row["Model"].ToString(); txtBusName.Text = row["BusName"].ToString(); } } } catch (Exception ex) { ex.ToString(); } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { string query = "UPDATE Bus SET RegNo = @RegNo,Model = @Model ,BusName = @BusName WHERE BusNo = @BusNo"; dataTransfere = new busMethods(); con = new SqlConnection(); con = dataTransfere.Connect(); con.Open(); using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@RegNo", int.Parse(txtRegNo.Text)); cmd.Parameters.AddWithValue("@BusNo", int.Parse(txtBusNumber.Text)); cmd.Parameters.AddWithValue("@Model", txtModel.Text); cmd.Parameters.AddWithValue("@BusName", txtBusName.Text); cmd.ExecuteNonQuery(); Response.Write("<script>alert('Record Updated')</script>"); } con.Close(); } catch (Exception ex) { ex.ToString(); } }
protected void btnLogin_Click(object sender, EventArgs e) { con = new SqlConnection(); dataSet = new DataSet(); dataTransfere = new busMethods(); con = dataTransfere.Connect(); con.Open(); try { string query = "SELECT username,password FROM Login "; using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query, con); adapter.SelectCommand = cmd; adapter.Fill(dataSet, "Login"); table = new DataTable(); table = dataSet.Tables["Login"]; foreach (DataRow row in table.Rows) { //for passanger if (row["username"].ToString().Equals(txtUser.Text) && row["password"].ToString().Equals(txtPass.Text)) { if (RadioButton1.Checked == true) { File.WriteAllText("C:\\Users\\Sandile Cedric Xulu\\Desktop\\loginDetails.txt", txtUser.Text); Response.Redirect("~/pmHome.aspx"); } else if (RadioButton2.Checked == true) { File.WriteAllText("C:\\Users\\Sandile Cedric Xulu\\Desktop\\loginDetails.txt", txtUser.Text); Response.Redirect("~/empHome.aspx"); } else if (RadioButton3.Checked == true) { File.WriteAllText("C:\\Users\\Sandile Cedric Xulu\\Desktop\\loginDetails.txt", txtUser.Text); Response.Redirect("~/adHome.aspx"); } else if (RadioButton4.Checked == true) { File.WriteAllText("C:\\Users\\Sandile Cedric Xulu\\Desktop\\loginDetails.txt", txtUser.Text); Response.Redirect("~/mngHome.aspx"); } } } } } catch (Exception ex) { ex.ToString(); } }
protected void btnCreate_Click(object sender, EventArgs e) { con = new SqlConnection(); con = dataTransfere.Connect(); dataSet = new DataSet(); con.Open(); try { string query1 = "INSERT INTO Login(username,password) VALUES(@username,@password)"; string query2 = "INSERT INTO CreateAccount(accountID,username,password,question1,question2,answer1,answer2) VALUES(@accountID,@username,@password,@question1,@question2,@answer1,@answer2)"; string query3 = "INSERT INTO Customer(Customer_Id,CustName,CustSurname,Address,PhoneNumber) VALUES(@Customer_Id,@CustName,@CustSurname,@Address,@PhoneNumber)"; if (txtPass.Text.Equals(txtRPass.Text)) { using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query1, con); cmd.Parameters.AddWithValue("@username", int.Parse(txtUser.Text)); cmd.Parameters.AddWithValue("@password", txtPass.Text); cmd.ExecuteNonQuery(); cmd = new SqlCommand(query2, con); cmd.Parameters.AddWithValue("@accountID", int.Parse(txtUser.Text)); cmd.Parameters.AddWithValue("@username", int.Parse(txtUser.Text)); cmd.Parameters.AddWithValue("@password", txtPass.Text); cmd.Parameters.AddWithValue("@question1", DropDownList1.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@question2", DropDownList2.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@answer1", txtAnswer.Text); cmd.Parameters.AddWithValue("@answer2", txtAnswer2.Text); cmd.ExecuteNonQuery(); cmd = new SqlCommand(query3, con); cmd.Parameters.AddWithValue("@Customer_Id", int.Parse(txtUser.Text)); cmd.Parameters.AddWithValue("@CustName", txtName.Text); cmd.Parameters.AddWithValue("@CustSurname", txtSurname.Text); cmd.Parameters.AddWithValue("@Address", txtAddress.Text); cmd.Parameters.AddWithValue("@PhoneNumber", txtPhone.Text); cmd.ExecuteNonQuery(); Response.Write("<script>alert('Account Created');</script>"); } } } catch (Exception ex) { ex.ToString(); } }
protected void btnPrevPass_Click(object sender, EventArgs e) { try { string u_name = File.ReadAllText("C:\\Users\\Sandile Cedric Xulu\\Desktop\\loginDetails.txt"); // string query = "SELECT * FROM Login"; string query2 = "SELECT * FROM CreateAccount WHERE username = "******""; dataTransfere = new busMethods(); table = new DataTable(); dataSet = new DataSet(); con = new SqlConnection(); con = dataTransfere.Connect(); con.Open(); using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query2, con); adapter.SelectCommand = cmd; adapter.Fill(dataSet, "CreateAccount"); table = dataSet.Tables["CreateAccount"]; foreach (DataRow row in table.Rows) { if (row["password"].ToString().Equals(txtPrevPass.Text)) { txtAnswer.Enabled = true; txtAnswer2.Enabled = true; txtConfirm.Enabled = true; txtNewPass.Enabled = true; btnChangePass.Enabled = true; lblQ1.Text = row["question1"].ToString(); lblQ2.Text = row["question2"].ToString(); } //lblQ1.Text = table.Rows[0][4].ToString(); //lblQ2.Text = table.Rows[0][5].ToString(); } } } catch (Exception ex) { ex.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { dataTransfere = new busMethods(); table = new DataTable(); dataSet = new DataSet(); string u_name = File.ReadAllText("C:\\Users\\Sandile Cedric Xulu\\Desktop\\loginDetails.txt"); txtId.Text = u_name; string query = "SELECT * FROM Customer WHERE Customer_Id = " + int.Parse(u_name) + ""; try { con = dataTransfere.Connect(); con.Open(); using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query, con); adapter.SelectCommand = cmd; adapter.Fill(dataSet, "Customer"); table = dataSet.Tables["Customer"]; foreach (DataRow row in table.Rows) { txtName.Text = row["CustName"].ToString(); txtSname.Text = row["CustSurname"].ToString(); txtCell.Text = row["PhoneNumber"].ToString(); txtAddr.Text = row["Address"].ToString(); } } con.Close(); } catch (Exception ex) { ex.ToString(); } }
protected void btnChangePass_Click(object sender, EventArgs e) { string u_name = File.ReadAllText("C:\\Users\\Sandile Cedric Xulu\\Desktop\\loginDetails.txt"); // string query = "SELECT * FROM Login"; string query2 = "SELECT * FROM CreateAccount WHERE username = "******""; dataTransfere = new busMethods(); table = new DataTable(); dataSet = new DataSet(); con = new SqlConnection(); con = dataTransfere.Connect(); con.Open(); using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query2, con); adapter.SelectCommand = cmd; adapter.Fill(dataSet, "CreateAccount"); table = dataSet.Tables["CreateAccount"]; foreach (DataRow row in table.Rows) { if (txtAnswer.Text.Equals(row["answer1"].ToString()) && txtAnswer2.Text.Equals(row["answer2"].ToString())) { //Response.Write("<script>alert('Answers are the same');</script>"); if (txtConfirm.Text.Equals(txtNewPass.Text)) { try { string query = "UPDATE CreateAccount SET password = @password WHERE username = @username"; string query3 = "UPDATE Login SET password = @password WHERE username = @username"; dataTransfere = new busMethods(); con = new SqlConnection(); con = dataTransfere.Connect(); con.Open(); using (adapter = new SqlDataAdapter()) { cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@password", txtNewPass.Text); cmd.Parameters.AddWithValue("@username", int.Parse(u_name)); cmd.ExecuteNonQuery(); cmd = new SqlCommand(query3, con); cmd.Parameters.AddWithValue("@password", txtNewPass.Text); cmd.Parameters.AddWithValue("@username", int.Parse(u_name)); cmd.ExecuteNonQuery(); Response.Write("<script>alert('Password Changed')</script>"); } con.Close(); } catch (Exception ex) { ex.ToString(); } } } } } }