public bool SetSuperAdmin()
{
using (MySqlConnection connection = new MySqlConnection(_connectionString))
{
connection.Open();
MySqlTransaction transaction = connection.BeginTransaction();
User user = null;
try
{
using (CafeBarContext contextDB = new CafeBarContext(connection, false))
{
contextDB.Database.CreateIfNotExists();
}
//DbConnection that is already opened
using (CafeBarContext context = new CafeBarContext(connection, false))
{
//Interception / SQL logging
context.Database.Log = (string message) => { Console.WriteLine(message); };
//Passing an existing transaction to the context
context.Database.UseTransaction(transaction);
if (!context.UserSet.Any(x => x.Username == "admin"))
{
context.UserSet.Add(new User()
{
DateCreated = DateTime.Now,
IsLocked = false,
HashedPassword = "******",
Email = "*****@*****.**",
Salt = "lobon",
Username = "******"
});
}
context.SaveChanges();
}
transaction.Commit();
}
catch (DbEntityValidationException ex)
{
transaction.Rollback();
return(false);
}
return(true);
}
}
public static void ExecuteExample()
{
string connectionString = "Server=localhost;Port=3306;Database=cafebar;user id=root;password=1234;";
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
//Create database if not exists
using (CafeBarContext contextDB = new CafeBarContext(connection, false))
{
contextDB.Database.CreateIfNotExists();
}
//connection.ConnectionString += ";password=1234;";
connection.Open();
MySqlTransaction transaction = connection.BeginTransaction();
try
{
//DbConnection that is already opened
using (CafeBarContext context = new CafeBarContext(connection, false))
{
//Interception / SQL logging
context.Database.Log = (string message) => { Console.WriteLine(message); };
//Passing an existing transaction to the context
context.Database.UseTransaction(transaction);
//DbSet.AddRange
// List<Category> cars = new List<Category>();
//cars.Add(new Category { Name = "Nissan2" });
// Console.WriteLine(context.Database.ExecuteSqlCommand(TransactionalBehavior.EnsureTransaction, "select * from categories"));
// context.SaveChanges();
}
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
}
}
public User CheckLogin(LogInModel model)
{
using (MySqlConnection connection = new MySqlConnection(_connectionString))
{
using (CafeBarContext contextDB = new CafeBarContext(connection, false))
{
contextDB.Database.CreateIfNotExists();
}
connection.Open();
MySqlTransaction transaction = connection.BeginTransaction();
User user = null;
try
{
//DbConnection that is already opened
using (CafeBarContext context = new CafeBarContext(connection, false))
{
//Interception / SQL logging
context.Database.Log = (string message) => { Console.WriteLine(message); };
//Passing an existing transaction to the context
context.Database.UseTransaction(transaction);
user = context.UserSet.FirstOrDefault(x => x.Email == model.Email && x.HashedPassword == model.Password);
// context.SaveChanges();
}
transaction.Commit();
}
catch
{
transaction.Rollback();
}
return(user);
}
}
