private void btnAdd_Click(object sender, EventArgs e)
{
try
{
var context = new AdventureWorksCurrencyEntities();
//adding new rows in currency table
Currency curr = new Currency
{
Name = txtName.Text,
CurrencyCode = txtCode.Text,
ModifiedDate = new DateTime(1998, 1, 1)
};
//add and change save in the table
context.Currencies.AddObject(curr);
context.SaveChanges();
MessageBox.Show("Record Inserted");
}
catch (Exception err)
{
MessageBox.Show(err.ToString());
}
finally
{
txtName.Text = "";
txtCode.Text = "";
}
}
// data update manipluation
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
var context = new AdventureWorksCurrencyEntities();
//update by currency code
Currency depart = context.Currencies
.First(i => i.CurrencyCode == txtCode.Text);
//update the Department name column data
depart.Name = TxtUpdate.Text;
context.SaveChanges();
MessageBox.Show("Record Updated");
}
catch (Exception err)
{
MessageBox.Show(err.ToString());
}
finally
{
TxtUpdate.Text = "";
}
}
//for displaying intial list of data in currency table
private void Display()
{
using (var context = new AdventureWorksCurrencyEntities())
{
var curr = context.Currencies
.Where(o => o.ModifiedDate > new DateTime(1998, 1, 1));
foreach (var cr in curr)
{
txtCurrency.AppendText(cr.ModifiedDate.ToString());
txtCurrency.AppendText("\t\t");
txtCurrency.AppendText(cr.CurrencyCode.ToString());
txtCurrency.AppendText("\t\t");
txtCurrency.AppendText(cr.Name.ToString());
txtCurrency.AppendText("\t");
txtCurrency.AppendText("\n");
}
}
}
// for delete records by Currency Code
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
var context = new AdventureWorksCurrencyEntities();
Currency del = context.Currencies
.First(i => i.CurrencyCode == TxtDelete.Text);
//record Delete and save to table
context.Currencies.DeleteObject(del);
context.SaveChanges();
MessageBox.Show("Record Deleted");
TxtDelete.Text = "";
}
catch (Exception err)
{
MessageBox.Show("you can't delete this row because it is maintaing dependency to other row.");
}
}
