private void buttonChange_Click(object sender, EventArgs e)
{
if (clientID == "" || clientMail == "")
{
return;
}
MailSubscription subscription = mailSubscriptions.Where(mail => mail.id.ToString() == clientID).First();
bool subscriptionStatus = !subscription.subscribted;
bool result = sqlHelper.ExecuteSQLCommand
("update tblClientes set Subscrito = " + Convert.ToInt32(subscriptionStatus) + " where ClienteID = " + subscription.id);
if (result)
{
HandleDictionaryUpdate();
clientID = "";
clientMail = "";
buttonChange.ButtonText = "Selecciona un usuario para cambiar";
buttonChange.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
buttonChange.Enabled = false;
//NotificationsCenter.notifyIcon.ShowBalloonTip(1000, "¡Listo!", "Subscripción actualizada.", ToolTipIcon.Error);
}
else
{
//NotificationsCenter.notifyIcon.ShowBalloonTip(1000, "Error al cambiar de subscripcion", "Verifica la conexión a la Base de Datos.", ToolTipIcon.Error);
}
}
public List <MailSubscription> GetDictionaryFromSQL(string query)
{
List <MailSubscription> mailSubscriptions = new List <MailSubscription>();
using (SqlConnection connection = new SqlConnection(ConnectionString.connectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(query, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
MailSubscription subscriptions = new MailSubscription(reader.GetInt32(0), reader.GetString(1), reader.GetBoolean(2));
mailSubscriptions.Add(subscriptions);
}
}
}
}
return(mailSubscriptions);
}
public async Task <IActionResult> OnPostAsync()
{
var user = await GetUser();
foreach (var item in MailSubscriptions)
{
if (item.MailSubscriptionId == 0)
{
var ms = new MailSubscription
{
Email = user.UserName,
MailTypeId = item.MailTypeId,
Name = ""
};
await _context.AddAsync(ms);
await _context.SaveChangesAsync();
}
else
{
var ms = new MailSubscription
{
Id = item.MailSubscriptionId,
Email = user.UserName,
MailTypeId = item.MailTypeId,
Name = "",
IsScription = item.IsScription
};
_context.Attach(ms).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
}
;
return(RedirectToPage());
}
