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