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