public static void CheckPerformanceDbCall() { const int m = 10000; var s1 = Stopwatch.StartNew(); DataBaseCall.GetStudents(); s1.Stop(); var s2 = Stopwatch.StartNew(); DataBaseCall.GetStudentsOrderByAsParallel(); s2.Stop(); var s3 = Stopwatch.StartNew(); DataBaseCall.GetStudentsAsParallelOrderBy(); s3.Stop(); Console.WriteLine("Normal Fetch Time Students : " + ((double)(s1.Elapsed.TotalMilliseconds * 1000000) / m).ToString("0.00 ns")); Console.WriteLine("Order By Then AsParallel Fetch Time Students : " + ((double)(s2.Elapsed.TotalMilliseconds * 1000000) / m).ToString("0.00 ns")); Console.WriteLine("AsParallel Then Order By Fetch Time Students : " + ((double)(s3.Elapsed.TotalMilliseconds * 1000000) / m).ToString("0.00 ns")); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = new DataTable(); DataBaseCall.getCountryList().Fill(dt); ddl_list_country.DataSource = dt; ddl_list_country.DataBind(); } }
protected void btnUserSubmit_Click(object sender, EventArgs e) { int result = DataBaseCall.authenticateUser(txtUserid.Text, txtPassword.Text); if (result == 1) { Response.Redirect("SearchFlights.aspx"); } else { MessageBox.Show("Invalid Credentials!!!"); } }
protected void btnAdminSubmit_Click(object sender, EventArgs e) { int result = DataBaseCall.authenticateAdmin(txtUserid.Text, txtPassword.Text); if (result == 1) { Response.Redirect("AdminControlForm.aspx"); } else { MessageBox.Show("Invalid Credentials!!!"); } }
protected void ddl_list_country_SelectedIndexChanged(object sender, EventArgs e) { ListItem first = ddl_list_state.Items[0]; ddl_list_state.Items.Clear(); ddl_list_state.Items.Add(first); DataTable dt = new DataTable(); DataBaseCall.getStateList(Convert.ToInt32(ddl_list_country.SelectedItem.Value)).Fill(dt); ddl_list_state.DataSource = dt; ddl_list_state.DataBind(); //conn.Close(); }
protected void btnRegister_Click(object sender, EventArgs e) { int result = DataBaseCall.regiterNewUser(FirstNameTextBox.Text, LastNameTextBox.Text, UserContact.Text, UserNameTextBox.Text , ddl_list_country.SelectedItem.Text, ddl_list_state.SelectedItem.Text, UserPassword.Text); if (result == 1) { MessageBox.Show("UserID already taken Please Try with another one!!!"); } else { MessageBox.Show("User Successfully Registered!!!"); Response.Redirect("LoginPage.aspx"); } }
protected void btnsearch_Click(object sender, EventArgs e) { dt = DataBaseCall.fetchFlight(ddl_list_boarding.SelectedItem.Text, ddl_list_destination.SelectedItem.Text, input_date.Text); if (dt == null) { mysearchData.Visible = true; btnBook.Visible = true; } else { string x = Convert.ToString(dt.Rows.Count); for (int j = 0; j < dt.Rows.Count; j++) { DataRow dr = dt.Rows[j]; TableRow row = new TableRow(); for (int i = 0; i <= dr.ItemArray.Length; i++) { if (i == 0) { TableCell cell1 = new TableCell(); RadioButton rad = new RadioButton(); rad.ID = "rad_" + j.ToString(); rad.GroupName = "selectFlight"; cell1.Controls.Add(rad); row.Cells.Add(cell1); } else { TableCell cell1 = new TableCell(); row.Cells.Add(cell1); cell1.Style["border-width"] = "1"; cell1.Style["border-color"] = "yellow"; cell1.Style["border-style"] = "solid"; cell1.Text = Convert.ToString(dr[i - 1]); } } mysearchData.Rows.Add(row); } mysearchData.Visible = true; btnBook.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = DataBaseCall.getUserData(); TextBox1.Text = Convert.ToString(dt.Rows.Count); for (int j = 0; j < dt.Rows.Count; j++) { DataRow dr = dt.Rows[j]; TableRow row = new TableRow(); for (int i = 0; i < dr.ItemArray.Length - 1; i++) { TableCell cell1 = new TableCell(); row.Cells.Add(cell1); cell1.Style["border-width"] = "1"; cell1.Style["border-color"] = "blue"; cell1.Style["border-style"] = "solid"; cell1.Text = Convert.ToString(dr[i]); } myTable.Rows.Add(row); } } }