protected void Register()
{
sqlDB sqlhelper = new sqlDB();
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM users WHERE username = @username", conn);
cmd.Parameters.AddWithValue("@username", tbxRegisterUsername.Text);
var data = sqlhelper.DataReader(cmd, "username");
if (data.Count() == 0)
{
cmd = new SqlCommand("INSERT INTO users(username,password,email,country) VALUES(@username,@password,@email,@country)", conn);
cmd.Parameters.AddWithValue("@username", tbxRegisterUsername.Text);
cmd.Parameters.AddWithValue("@password", tbxRegisterPassword.Text);
cmd.Parameters.AddWithValue("@email", tbxRegisterEmail.Text);
cmd.Parameters.AddWithValue("@country", tbxRegisterCountry.Text);
int control = cmd.ExecuteNonQuery();
if (control > 0)
{
JSMessage("You Have Succesfully Registered.");
}
else
{
JSMessage("Error while registering, try again");
}
}
else
{
JSMessage("Username already exists, Pick another one :( ");
}
}
protected List <string> GetPredictionInputs()
{
var source = sourceInput.Text;
var dest = destinationInput.Text;
sqlDB helperDB = new sqlDB();
Data helperData = new Data();
string strLat1, strLat2, strLon1, strLon2;
//Distance
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM airports WHERE airport = @airport", conn);
cmd.Parameters.AddWithValue("@airport", source);
helperDB.DataReader(cmd, "lat", "long", out strLat1, out strLon1);
cmd = new SqlCommand("SELECT * FROM airports WHERE airport = @airport", conn);
cmd.Parameters.AddWithValue("@airport", dest);
helperDB.DataReader(cmd, "lat", "long", out strLat2, out strLon2);
var tempDistance = GreatDistanceCalculation(strLat1.Replace('.', ',').ToDouble(), strLon1.Replace('.', ',').ToDouble(), strLat2.Replace('.', ',').ToDouble(), strLon2.Replace('.', ',').ToDouble());
tempDistance = tempDistance * 0.621371192; //Mile türünden lazım, databasemizde öyle çünkü
int distance = Convert.ToInt32(tempDistance);
//End Distance
//Origin And Destination
source = helperData.airportNames.FindIndexOf(source).ToString();
dest = helperData.airportNames.FindIndexOf(dest).ToString();
//End Origin and Destination
//Deperature Time and Arrival Time
var deptime = deperatureInput.Text;
var arrtime = arrivalInput.Text;
//End Deperature Time and Arrival Time
//ElapsedTime
TimeSpan tsDeptime = new TimeSpan(deptime.Substring(0, 2).ToInt32(), deptime.Substring(2, 2).ToInt32(), 0);
TimeSpan tsArrtime = new TimeSpan(arrtime.Substring(0, 2).ToInt32(), arrtime.Substring(2, 2).ToInt32(), 0);
TimeSpan tsElapsedTime = new TimeSpan();
tsElapsedTime = tsArrtime.Subtract(tsDeptime);
var ElapsedTime = tsElapsedTime.TotalMinutes.ToString();
//End ElapsedTime
//TailNumber And UniqeCarrier
var tailNum = tailnumInput.Text;
cmd = new SqlCommand("SELECT * FROM finalDataSet WHERE Tailnum = @Tailnum", conn);
cmd.Parameters.AddWithValue("@Tailnum", tailNum);
var uniqeCarrierID = helperDB.DataReader(cmd, "UniqueCarrier")[0]; //ID sini aldık
//End TailNumber And UniqeCarrier
//Flight Number
var flightnumber = flightnumInput.Text;
//End FlightNumber
//Date
var tempdate = datepicker.Text.Split('/').ToArray(); // 04/23/2017 year month day
var date = new DateTime(int.Parse(tempdate[2]), int.Parse(tempdate[0]), int.Parse(tempdate[1]));
//End Date
Values = new List <string>();
Values.Add(date.Year.ToString());
Values.Add(date.Month.ToString());
Values.Add(date.Day.ToString());
int dayofWeek = ((int)date.DayOfWeek == 0) ? 7 : (int)date.DayOfWeek;
Values.Add(dayofWeek.ToString());
Values.Add(deptime);
Values.Add(arrtime);
Values.Add(uniqeCarrierID);
Values.Add(flightnumber);
Values.Add(tailNum);
Values.Add(ElapsedTime);
Values.Add("0"); //ARRIVAL DELAY
Values.Add(source);
Values.Add(dest);
Values.Add(distance.ToString()); //In miles
Values.Add("0"); //DIVERTED
return(Values);
}
