private void BEdit_Click(object sender, EventArgs e)
{
if (tBAdresEdit.Text.Trim() != string.Empty)
{
string text = tBAdresEdit.Text;
int id = Convert.ToInt32(tBIDEdit.Text);
if (true == IsValid(tBAdresEdit.Text))
{
using (var db = new ExtensionContext())
{
var result = db.ListEmailsDB.SingleOrDefault(b => b.EmailsListId == id);
if (result != null)
{
result.AdresseEmail = tBAdresEdit.Text;
db.SaveChanges();
}
}
}
else
{
MessageBox.Show("Zły format adresu email", "Uwaga", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
Reflesh();
}
else
{
MessageBox.Show("Wpisano pusty adres email", "Uwaga", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
tBAdresDelete.Text = tBAdresEdit.Text;
this.dataGridView2.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
this.dataGridView2.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void BDelete_Click(object sender, EventArgs e)
{
if (tBAdresEdit.Text.Trim() != string.Empty || tBAdresEdit.Text.Trim() != "")
{
int id = Convert.ToInt32(tBIDEdit.Text);
string text = tBAdresEdit.Text;
using (var db = new ExtensionContext())
{
var result = db.ListEmailsDB.SingleOrDefault(b => b.EmailsListId == id);
if (result != null)
{
db.Entry(result).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
}
Reflesh();
this.dataGridView2.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
this.dataGridView2.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
tBAdresDelete.Text = "";
tBIDDelete.Text = "";
tBIDEdit.Text = "";
tBAdresEdit.Text = "";
}
private void BDeleteRecords_Click(object sender, EventArgs e)
{
tBExtId.Clear();
tBEditExt.Clear();
using (var db = new ExtensionContext())
{
var query = from c in db.ExtensionDB
select new { c.ListId };
if (query.ToList().Count >= 1)
{
foreach (var item in query)
{
using (var dbx = new ExtensionContext())
{
int x = Convert.ToInt32(item.ListId.ToString());
var delete = new ListExtension.List {
ListId = x
};
dbx.ExtensionDB.Attach(delete);
dbx.ExtensionDB.Remove(delete);
dbx.SaveChanges();
}
}
}
RefleshDataGrid();
}
}
private void BAddExt_Click(object sender, EventArgs e)
{
using (var db = new ExtensionContext())
{
var Record = new ListExtension.List {
Extension = tBAddExt.Text.Trim()
};
db.ExtensionDB.Add(Record);
db.SaveChanges();
}
RefleshDataGrid();
}
private void BAddEmail_Click(object sender, EventArgs e)
{
if (tBAddEmail.Text.Trim() != string.Empty)
{
string text = tBAddEmail.Text;
if (true == IsValid(tBAddEmail.Text))
{
using (var db = new ExtensionContext())
{
var query = from c in db.ListEmailsDB
where c.AdresseEmail == text
select new { c.EmailsListId, c.AdresseEmail };
if (query.ToList().Count < 1)
{
var UserFolderSave = new ListEmails.EmailsList {
AdresseEmail = text
};
db.ListEmailsDB.Add(UserFolderSave);
db.SaveChanges();
}
else
{
MessageBox.Show("Dany adres już isnieje, żądanie nie zostało wprowadzone", "Uwaga", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
else
{
MessageBox.Show("Zły format adresu email", "Uwaga", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
Reflesh();
this.dataGridView2.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
this.dataGridView2.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
else
{
MessageBox.Show("Wpisano pusty adres email", "Uwaga", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void BEditExt_Click(object sender, EventArgs e)
{
if (tBEditExt.Text.Trim() != string.Empty || tBEditExt.Text.Trim() != "")
{
int id = Convert.ToInt32(tBExtId.Text);
string text = tBEditExt.Text.Trim();
using (var db = new ExtensionContext())
{
var result = db.ExtensionDB.SingleOrDefault(b => b.ListId == id);
if (result != null)
{
result.Extension = text;
db.SaveChanges();
}
}
}
RefleshDataGrid();
}
