private void insertFunc(object sender, RoutedEventArgs e)
{
if (memid.SelectedItem == null || typee.SelectedItem == null || string.IsNullOrEmpty(accid.Text) ||
string.IsNullOrEmpty(currency.Text) || string.IsNullOrEmpty(balanc.Text) ||
string.IsNullOrEmpty(sbalanc.Text) || stat.SelectedItem == null
)
{
MessageBox.Show("Талбар дутууу !!!!");
return;
}
using (demoEntities10 contx = new demoEntities10())
{
ClearingAccount ca = new ClearingAccount
{
memberid = Convert.ToInt32(memid.SelectedValue),
type = Convert.ToInt16(typee.SelectedIndex),
account = accid.Text,
currency = Convert.ToInt32(currency.Text),
blnc = Convert.ToDecimal(balanc.Text),
sblnc = Convert.ToDecimal(sbalanc.Text),
linkaccount = Convert.ToInt64(linkacc.SelectedValue),
state = Convert.ToInt16(stat.SelectedIndex - 1),
modified = DateTime.Now,
};
contx.ClearingAccounts.Add(ca);
contx.SaveChanges();
}
FillDataGrid();
}
private void update(object sender, RoutedEventArgs e)
{
var ac = DateTable2.SelectedItem as ClearingAccount;
using (demoEntities10 conx = new demoEntities10())
{
ClearingAccount ca = conx.ClearingAccounts.FirstOrDefault(r => r.id == ac.id);
ca.memberid = Convert.ToInt32(memid.SelectedValue);
ca.account = accid.Text;
ca.type = Convert.ToInt16(typee.SelectedIndex);
ca.currency = Convert.ToInt32(currency.Text);
ca.blnc = Convert.ToDecimal(balanc.Text);
ca.sblnc = Convert.ToDecimal(sbalanc.Text);
ca.linkaccount = Convert.ToInt64(linkacc.SelectedValue);
ca.state = Convert.ToInt16(stat.SelectedIndex - 1);
ca.modified = DateTime.Now;
conx.SaveChanges();
}
FillDataGrid();
}
