public static void InsertDataInDatabase()
{
try
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = "(LocalDb)\\MSSQLLocalDB"; // update me
builder.UserID = ""; // update me
builder.Password = ""; // update me
builder.InitialCatalog = "martketStoreDB";
using (MarketContext context = new MarketContext(builder.ConnectionString))
{
User newUser = new User {
Id = 1, FirstName = "Anna", LastName = "Shrestinian"
};
try
{
context.Users.Add(newUser);
context.SaveChanges();
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
User FirstUser = new User {
Id = 2, FirstName = "Aa", LastName = "Shrestin"
};
try
{
context.Users.Add(FirstUser);
context.SaveChanges();
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
User NewUser = new User {
Id = 3, FirstName = "Ann", LastName = "Shre"
};
try
{
context.Users.Add(NewUser);
context.SaveChanges();
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
User OneMorenewUser = new User {
Id = 4, FirstName = "Ana", LastName = "Shtinian"
};
try
{
context.Users.Add(OneMorenewUser);
context.SaveChanges();
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
}
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
}
public static void InsertDataInDatabase()
{
try
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = "(LocalDb)\\MSSQLLocalDB"; // update me
builder.UserID = ""; // update me
builder.Password = ""; // update me
builder.InitialCatalog = "martketStoreDB";
using (MarketContext context = new MarketContext(builder.ConnectionString))
{
Bronze Bronze = new Bronze {
Id = 1, Turnover = 0, Discount = 0, User_Id = 1
};
GetData.valueOfPurchase(Bronze, 150);
try
{
context.Bronze.Add(Bronze);
context.SaveChanges();
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
Silver Silver = new Silver {
Id = 1, Turnover = 600, Discount = 2, User_Id = 2
};
GetData.valueOfPurchase(Silver, 850);
try
{
context.Silver.Add(Silver);
context.SaveChanges();
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
Gold Gold = new Gold {
Id = 1, Turnover = 1500, Discount = 2, User_Id = 3
};
GetData.valueOfPurchase(Gold, 1300);
try
{
context.Gold.Add(Gold);
context.SaveChanges();
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
Console.WriteLine("Done");
}
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
}