public IActionResult Block(int unit, BlockingViewModel model, string blocking)
{
setDbContext();
model.BeginningDate = DateTime.Now;
if (blocking == "permanently")
{
model.Permanently = true;
}
else
{
model.Permanently = false;
switch (blocking)
{
case "hours":
model.ExpirationDate = DateTime.Now.AddHours(unit);
break;
case "days":
model.ExpirationDate = DateTime.Now.AddDays(unit);
break;
case "months":
model.ExpirationDate = DateTime.Now.AddMonths(unit);
break;
case "years":
model.ExpirationDate = DateTime.Now.AddYears(unit);
break;
}
}
context.BlockUser(model);
return(RedirectToAction("Index", "Clients"));
}
public void BlockUser(BlockingViewModel model)
{
using (MySqlConnection conn = GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("select id_client from blocking", conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (Convert.ToInt32(reader["id_client"]) == model.Id)
{
return;
}
}
}
using (var transaction = conn.BeginTransaction())
{
var insertCommand = conn.CreateCommand();
insertCommand.CommandText = "call block_client(@id_client, @permanently, " +
"@beginningdate, @expirationdate)";
insertCommand.Parameters.AddWithValue("@id_client", model.Id);
insertCommand.Parameters.AddWithValue("@permanently", model.Permanently);
insertCommand.Parameters.AddWithValue("@beginningdate", model.BeginningDate);
insertCommand.Parameters.AddWithValue("@expirationdate", model.ExpirationDate);
insertCommand.ExecuteScalar();
transaction.Commit();
}
}
}
public BlockingPage()
{
InitializeComponent();
BindingContext = new BlockingViewModel()
{
Navigation = this.Navigation
};
}
public IActionResult Block(string id)
{
setDbContext();
Client client = context.GetClientById(id, "clients");
if (client != null)
{
BlockingViewModel model = new BlockingViewModel
{
Id = client.Id,
Email = client.Email
};
return(View(model));
}
else
{
return(NotFound());
}
}
