private static void CreateNewAirports(SqlCrud sql, List <AirportModel> airports)
{
foreach (var airport in airports)
{
sql.CreateAirport(airport);
}
}
private static void CreateNewAirlines(SqlCrud sql, List <AirlineModel> airlines)
{
foreach (var airline in airlines)
{
sql.CreateAirline(airline);
}
}
private static void CreateNewContact(SqlCrud sql)
{
FullContactModel nc = new FullContactModel
{
BasicInfo = new BasicContactModel
{
FirstName = "ncFname",
LastName = "ncLname"
}
};
nc.EmailAddresses.Add(new EmailAddressModel {
EmailAddress = "*****@*****.**"
});
nc.EmailAddresses.Add(new EmailAddressModel {
Id = 2, EmailAddress = "*****@*****.**"
});
nc.PhoneNumbers.Add(new PhoneNumberModel {
PhoneNumber = "555-213-3333"
});
nc.PhoneNumbers.Add(new PhoneNumberModel {
Id = 1, PhoneNumber = "555-123-1111"
});
sql.CreateContact(nc);
}
private static void ReadContact(SqlCrud sql, int contactId)
{
var contact = sql.GetFullContactById(contactId);
Console.WriteLine($"{contact.BasicInfo.Id}: {contact.BasicInfo.FirstName} {contact.BasicInfo.LastName}");
}
private static void CreateNewContact(SqlCrud sql)
{
FullContactModel user = new FullContactModel
{
BasicInfo = new BasicContactModel
{
FirstName = "Charity",
LastName = "Corey"
}
};
user.EmailAddresses.Add(new EmailAddressModel {
EmailAddress = "*****@*****.**"
});
user.EmailAddresses.Add(new EmailAddressModel {
Id = 2, EmailAddress = "*****@*****.**"
});
user.PhoneNumbers.Add(new PhoneNumberModel {
Id = 1, PhoneNumber = "555-1212"
});
user.PhoneNumbers.Add(new PhoneNumberModel {
PhoneNumber = "555-9876"
});
}
private static void ReadAllContacts(SqlCrud sql)
{
var rows = sql.GetAllContacts();
foreach (var row in rows)
{
Console.WriteLine($"{row.Id}: {row.FirstName} {row.LastName}");
}
}
private static void GetFullPersonInfo(SqlCrud sql, int id)
{
var person = sql.FullPersonInfo(id);
Console.WriteLine($"{person.BasicInfo.FirstName} {person.BasicInfo.LastName} ");
foreach (var adress in person.adresses)
{
Console.WriteLine(adress.Adress);
}
}
private static void ReadAllContacts(SqlCrud sql)
{
//calls sqlcrud to get all contacts
var rows = sql.GetAllContacts();
foreach (var i in rows)
{
Console.WriteLine($"Id: {i.Id}, FirstName: {i.FirstName}, LastName: {i.LastName}");
}
}
private static void CreateNewAirline(SqlCrud sql)
{
// Test Data
var airline = new AirlineModel
{
Name = "Turkish Airlines"
};
sql.CreateAirline(airline);
}
static void Main(string[] args)
{
SqlCrud sql = new SqlCrud(GetConnectionString());
// ReadAllContacts(sql);
// ReadContact(sql, 1);
CreateNewContact(sql);
Console.ReadLine();
}
private static void UpdateContact(SqlCrud sql)
{
BasicContactModel contact = new BasicContactModel
{
Id = 1,
FirstName = "fName1z",
LastName = "lName1"
};
sql.UpdateContactName(contact);
}
private static void UpdateContact(SqlCrud sql)
{
PeopleModel contact = new PeopleModel
{
Id = 1,
FirstName = "Doina",
LastName = "Stef"
};
sql.UpdateContactName(contact);
}
static void Main(string[] args)
{
SqlCrud sql = new SqlCrud(GetConnectionString());
GetFullPersonInfo(sql, 3);
// AddFullContact(sql);
// UpdateContact(sql);
// DeleteAdress(sql, 2, 1);
Console.WriteLine("Done processing SQL server");
Console.ReadLine();
}
private static void CreateNewAirport(SqlCrud sql)
{
// Test Data
var airport = new AirportModel
{
IATACode = "ORD",
Name = "O'Hare International Airport",
City = "Chicago",
State = "IL"
};
sql.CreateAirport(airport);
}
static void Main(string[] args)
{
SqlCrud sql = new SqlCrud(GetConnectionString());
//CreateNewAirport(sql); // It worked
//CreateNewAirports(sql, GetTestAirportData()); // it worked
//CreateNewAirline(sql);
//CreateNewAirlines(sql, GetAirlineData()); // it worked
Console.WriteLine("Completed..");
Console.ReadKey();
}
static void Main(string[] args)
{
//test connstring
//Console.WriteLine(GetConnectionString());
//instance of sqlcrud class, and pass in connstring
SqlCrud sql = new SqlCrud(GetConnectionString());
//ReadAllContacts(sql);
//CreateNewContact(sql);
//ReadContact(sql, 3);
//UpdateContact(sql);
//RemovePhoneNumberFromContact(sql, 1, 1);
Console.WriteLine("done sql server");
Console.ReadLine();
}
private static void AddFullContact(SqlCrud sql)
{
FullContactModel fullContact = new FullContactModel
{
BasicInfo = new PeopleModel
{
FirstName = "Alondra",
LastName = "Gates"
}
};
fullContact.adresses.Add(new AdressesModel {
Id = 1, Adress = "Ion Creanga nr 17"
});
fullContact.adresses.Add(new AdressesModel {
Adress = "Ion Caragiale nr 88"
});
sql.CreateFullContact(fullContact);
}
public void WriteToDb()
{
//DAL.Data.InitializeBreweries();uncomment and run when sql needs to be re-initialized
List <Brewery> breweries = (List <Brewery>)Session["Breweries"];
System.Data.SqlClient.SqlConnection sqlConnection1 =
new System.Data.SqlClient.SqlConnection("Server=tcp:aspnet.database.windows.net,1433;Database=brewery repo;User ID=Yato@aspnet;Password=Dragon5476;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;");
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "DELETE FROM Review";
//cmd.CommandText = "INSERT INTO Table (Id, name, address, city, state, zip, phone) VALUES (1, 'California','Los Angeles', 'California','Los Angeles', 'California','Los Angeles')";
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
cmd.ExecuteNonQuery();
sqlConnection1.Close();
SqlCrud Sql = new SqlCrud();
int index = 0;
foreach (Brewery brewery in breweries)
{
Sql.update(breweries[index].ID.ToString(), breweries[index].Name.ToString(), breweries[index].City.ToString(), breweries[index].State.ToString(), breweries[index].Zip.ToString(), breweries[index].Address.ToString(), breweries[index].Phone.ToString());
index++;
}
}
private static void RemovePhoneNumberFromContact(SqlCrud sql, int contactId, int phoneNumberId)
{
sql.RemovePhoneNumber(contactId, phoneNumberId);
}
private static void DeleteAdress(SqlCrud sql, int personId, int adressId)
{
sql.DeleteAdress(personId, adressId);
}
static void Main(string[] args)
{
SqlCrud sql = new SqlCrud(GetConnectionString());
GeneratePasswordAndSalt generatePasswordAndSalt = new GeneratePasswordAndSalt();
SqlDataAccess d = new SqlDataAccess();
VerifyPassword verifyValidPassword = new VerifyPassword();
// Creates a user
Users user = new Users();
Console.Write("Enter First Name: ");
user.FirstName = Console.ReadLine();
Console.Write("Enter Last Name: ");
user.LastName = Console.ReadLine();
Console.Write("Enter a password: "******"password and salt: {Convert.ToBase64String(passwordAndSalt)}");
Console.WriteLine("Type yoy password again to login");
string testPassword = Console.ReadLine();
Console.WriteLine(
verifyValidPassword.VerifyVerySecurePassword(testPassword, UserSalt, 50000, passwordAndSalt));
Console.ReadLine();
#endregion
//generatePasswordAndSalt.GeneratePassword(user);
// Creates a user wit password user ans saves it to the database
sql.CreateUserAndPassword(user);
Users u = new Users();
Console.Write("Enter a password To Verify Login: "******"Password: {u.Password} Salt: {u.Salt}");
Console.WriteLine(verifyValidPassword.VerifyValidPassword(verifyPassword, user, u));
Console.WriteLine("Hello World!");
}
