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