private void update(object sender, RoutedEventArgs e)
{
sides = Side.SelectedIndex.ToString();
if (sides == "0")
{
sides = "-1";
}
var ac = DateTable2.SelectedItem as Order;
using (demoEntities10 conx = new demoEntities10())
{
Order or = conx.Orders.FirstOrDefault(r => r.id == ac.id);
or.memberid = Convert.ToInt64(memid.SelectedValue);
or.side = Convert.ToInt16(sides);
or.accountid = Convert.ToInt64(accountid.SelectedValue);
or.assetid = Convert.ToInt64(assetid.SelectedValue);
or.qty = Convert.ToInt32(quantity.Text);
or.price = Convert.ToDecimal(price.Text);
or.state = Convert.ToInt16(stat.SelectedIndex - 1);
or.modified = DateTime.Now;
or.dealType = (short)dealtype.SelectedIndex;
conx.SaveChanges();
}
FillDataGrid();
}
private void insertFunc(object sender, RoutedEventArgs e)
{
if (memid.SelectedItem == null || accountid.SelectedItem == null || boardid.SelectedItem == null ||
stat.SelectedItem == null || assetid.SelectedItem == null || assetid.SelectedItem == null ||
string.IsNullOrEmpty(price.Text) || Side.SelectedItem == null || dealtype.SelectedItem == null)
{
MessageBox.Show("Талбар дутууу !!!!");
return;
}
sides = Side.SelectedIndex.ToString();
if (sides == "0")
{
sides = "-1";
}
using (demoEntities10 contx = new demoEntities10())
{
Order ord = new Order
{
side = Convert.ToInt16(sides),
memberid = Convert.ToInt64(memid.SelectedValue),
accountid = Convert.ToInt64(accountid.SelectedValue),
boardId = Convert.ToInt64(boardid.SelectedValue),
state = Convert.ToInt16(stat.SelectedIndex - 1),
assetid = Convert.ToInt32(assetid.SelectedValue),
qty = Convert.ToInt32(quantity.Text),
price = Convert.ToDecimal(price.Text),
dealType = (short)dealtype.SelectedIndex,
};
contx.Orders.Add(ord);
contx.SaveChanges();
}
FillDataGrid();
}
private void insertFunc(object sender, RoutedEventArgs e)
{
if (sdat.SelectedDate == null || edat.SelectedDate == null || markcontact.SelectedItem == null ||
markmember.SelectedItem == null || string.IsNullOrEmpty(markorderl.Text) || string.IsNullOrEmpty(markdesc.Text) ||
string.IsNullOrEmpty(markticks.Text) || markaccount.SelectedItem == null
)
{
MessageBox.Show("Талбар дутууу !!!!");
return;
}
using (demoEntities10 contx = new demoEntities10())
{
MarketMaker mam = new MarketMaker
{
contactid = Convert.ToInt32(markcontact.SelectedValue),
memberid = Convert.ToInt32(markmember.SelectedValue),
accountid = Convert.ToInt64(markaccount.SelectedValue),
startdate = Convert.ToDateTime(sdat.SelectedDate),
enddate = Convert.ToDateTime(edat.SelectedDate),
ticks = Convert.ToInt32(markticks.Text),
description = markdesc.Text,
orderlimit = Convert.ToInt32(markorderl.Text),
state = Convert.ToInt16(markstat.SelectedIndex - 1),
modified = DateTime.Now,
};
contx.MarketMakers.Add(mam);
contx.SaveChanges();
}
FillDataGrid();
}
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 insertFunc(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(bname.Text) || btype.SelectedItem == null || state.SelectedItem == null ||
dhour.SelectedItem == null || dminute.SelectedItem == null || dsecond.SelectedItem == null ||
string.IsNullOrEmpty(tdayss.Text) || dealtype.SelectedItem == null || string.IsNullOrEmpty(enddate.Text) ||
string.IsNullOrEmpty(desc.Text)
)
{
MessageBox.Show("Талбар дутууу !!!!");
return;
}
using (demoEntities10 contx = new demoEntities10())
{
TimeSpan times = new TimeSpan(
Convert.ToInt32(dhour.Text),
Convert.ToInt32(dminute.Text),
Convert.ToInt32(dsecond.Text));
Board boa = new Board
{
name = bname.Text,
expTime = times,
tdays = tdayss.Text,
description = desc.Text,
dealType = Convert.ToInt16(dealtype.SelectedIndex),
expDate = Convert.ToInt16(enddate.Text),
state = Convert.ToInt16(state.SelectedIndex - 1),
modified = DateTime.Now,
type = Convert.ToInt16(btype.SelectedIndex),
};
contx.Boards.Add(boa);
contx.SaveChanges();
}
FillDataGrid();
}
private void insertFunc(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(sell.Text) || string.IsNullOrEmpty(buy.Text) || string.IsNullOrEmpty(mmsell.Text) ||
string.IsNullOrEmpty(mmbuy.Text) || contractid.SelectedItem == null || mbuyType.SelectedItem == null ||
mselltype.SelectedItem == null
)
{
MessageBox.Show("Талбар дутууу !!!!");
return;
}
using (demoEntities10 contx = new demoEntities10())
{
Margin ma = new Margin
{
buy = Convert.ToDecimal(buy.Text),
buytype = Convert.ToInt16(mbuyType.SelectedIndex),
sell = Convert.ToDecimal(sell.Text),
selltype = Convert.ToInt16(mselltype.SelectedIndex),
modified = DateTime.Now,
msell = Convert.ToDecimal(mmsell.Text),
mbuy = Convert.ToDecimal(mmbuy.Text),
coid = Convert.ToInt64(contractid.SelectedValue),
};
contx.Margins.Add(ma);
contx.SaveChanges();
}
FillDataGrid();
}
private void insertFunc(object sender, RoutedEventArgs e)
{
if (aexpire.SelectedDate == null || string.IsNullOrEmpty(acode.Text) || string.IsNullOrEmpty(aname.Text) ||
string.IsNullOrEmpty(anote.Text) || string.IsNullOrEmpty(aprice.Text) || string.IsNullOrEmpty(avolume.Text) ||
string.IsNullOrEmpty(artio.Text) || astate.SelectedItem == null)
{
MessageBox.Show("Талбарууд дутуу !!!!");
return;
}
using (demoEntities10 contx = new demoEntities10())
{
Asset ast = new Asset
{
code = acode.Text,
name = aname.Text,
price = Convert.ToDecimal(aprice.Text),
note = anote.Text,
ratio = Convert.ToDecimal(artio.Text) / 100,
expireDate = Convert.ToDateTime(aexpire.SelectedDate),
state = Convert.ToInt16(astate.SelectedIndex - 1),
volume = Convert.ToInt64(avolume.Text),
};
contx.Assets.Add(ast);
contx.SaveChanges();
}
FillDataGrid();
}
private void update(object sender, RoutedEventArgs e)
{
var ac = DateTable2.SelectedItem as Contract;
using (demoEntities10 conx = new demoEntities10())
{
Contract ca = conx.Contracts.FirstOrDefault(r => r.id == ac.id);
ca.securityId = Convert.ToInt64(securityid_Copy.SelectedValue);
ca.type = Convert.ToInt16(ctype.SelectedIndex);
ca.code = ccode.Text;
ca.lot = Convert.ToDecimal(clot.Text);
ca.name = cname.Text;
ca.tickTable = Convert.ToInt32(ctick.SelectedValue);
ca.sdate = csdate.SelectedDate;
ca.edate = cedate.SelectedDate;
ca.groupId = Convert.ToInt16(cgroupid.Text);
ca.state = Convert.ToInt16(cstate.SelectedIndex - 1);
ca.modified = DateTime.Now;
ca.mmorderLimit = Convert.ToInt32(mmorderLim.Text);
ca.orderLimit = Convert.ToInt32(orderLim.Text);
ca.refpriceParam = Convert.ToDecimal(refpricePara.Text);
ca.bid = Convert.ToInt64(boardid.SelectedValue);
conx.SaveChanges();
}
FillDataGrid();
}
private void insertFunc(object sender, RoutedEventArgs e)
{
using (demoEntities10 contx = new demoEntities10())
{
TickSizeTable tit = new TickSizeTable
{
name = namee.Text,
};
contx.TickSizeTables.Add(tit);
contx.SaveChanges();
}
// if (statid == null || tid == null)
// return;
// upd.IsEnabled = true;
// string tick= tickk.Text;
// string price = pricee.Text;
// System.Data.SqlClient.SqlConnection sqlConnection1 =
//new System.Data.SqlClient.SqlConnection(connectionString);
// System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = "insert into dbo.TickSizeTable (tableid, tick, price, state, name) values" +
// " ('" + tid+ "',N'" + tick+ "',N'" + price+ "',N'" + statid+ "', N'"+ name+"')";
// cmd.Connection = sqlConnection1;
// sqlConnection1.Open();
// cmd.ExecuteNonQuery();
// sqlConnection1.Close();
FillDataGrid();
}
private void Button_Click(object sender, RoutedEventArgs e)//insert
{
if (members.SelectedItem == null)
{
MessageBox.Show("Please select Member:");
return;
}
using (demoEntities10 context = new demoEntities10())
{
var exist = context.users.Count(a => a.uname == usname.Text);
if (exist != 0)
{
MessageBox.Show("Username exists " + usname.Text + " !!!");
return;
}
}
using (var context = new demoEntities10())
{
var std = new user()
{
uname = usname.Text,
password = upass.Password,
role = urole.SelectedIndex.ToString(),
memId = (int)members.SelectedValue,
modified = DateTime.Now,
serverip = server.Text,
serverDatabase = database.Text,
serverUname = serveruname.Text,
serverPassword = serverpassword.Text,
};
context.users.Add(std);
context.SaveChanges();
}
FillGrid();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Order values = DateTable2.SelectedItem as Order;
if (null == values)
{
return;
}
using (demoEntities10 conx = new demoEntities10())
{
Transaction trans1 = new Transaction
{
accountId = values.accountid,
assetId = Convert.ToInt32(values.assetid),
amount = Convert.ToInt32(values.qty),
memberid = Convert.ToInt32(values.memberid),
modified = DateTime.Now,
tdate = values.modified,
type = values.side,
};
Transaction std = conx.Transactions.FirstOrDefault(r => r.id == values.id);
conx.Transactions.Remove(std);
conx.Transactions.Add(trans1);
conx.SaveChanges();
}
FillDataGrid();
}
private void insertFunc(object sender, RoutedEventArgs e)
{
if (markcontact.SelectedItem == null || string.IsNullOrEmpty(refprice.Text) || string.IsNullOrEmpty(name.Text))
{
MessageBox.Show("Талбар дутууу !!!!");
return;
}
long contract = Convert.ToInt64(markcontact.SelectedValue);
using (demoEntities10 conx = new demoEntities10())
{
var idexist = conx.RefPrices.Count(a => a.contractId == contract);
if (idexist != 0)
{
MessageBox.Show("contract давтагдсан байна " + markcontact.SelectedValue.ToString() + " !!!");
return;
}
var re = new RefPrice()
{
contractId = contract,
refprice1 = Convert.ToDecimal(refprice.Text),
name = name.Text,
modified = DateTime.Now,
};
conx.RefPrices.Add(re);
conx.SaveChanges();
}
// string refPrice = refprice.Text;
// System.Data.SqlClient.SqlConnection sqlConnection1 =
//new System.Data.SqlClient.SqlConnection(connectionString);
// System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = "DELETE demo.dbo.RefPrice WHERE id = '" + contrid + "'; " +
// "insert into dbo.RefPrice (id,refprice, modified) values" +
// " ("+ contrid + ",'" + refPrice + "', getdate())";
// cmd.Connection = sqlConnection1;
// sqlConnection1.Open();
// try
// {
// cmd.ExecuteNonQuery();
// }
// catch (SqlException ex)
// {
// if (ex.Number == 2)
// {
// MessageBox.Show("contract 2 is already price edit it !!!");
// }
// else throw;
// }
// sqlConnection1.Close();
FillDataGrid();
}
private void Button_Click_1(object sender, RoutedEventArgs e)//delete
{
user iiid = DateTable2.SelectedItem as user;
using (demoEntities10 context = new demoEntities10())
{
user acc = context.users.FirstOrDefault(r => r.memId == iiid.memId);
context.users.Remove(acc);
context.SaveChanges();
}
FillGrid();
}
private void update(object sender, RoutedEventArgs e)
{
var ac = DateTable2.SelectedItem as Board;
using (demoEntities10 conx = new demoEntities10())
{
DealerAccount dea = conx.DealerAccounts.FirstOrDefault(r => r.id == ac.id);
dea.memberid = Convert.ToInt64(memid.SelectedValue);
dea.accountid = Convert.ToInt64(accid.SelectedValue);
dea.state = Convert.ToInt16(stat.SelectedIndex - 1);
conx.SaveChanges();
}
FillDataGrid();
}
private void update(object sender, RoutedEventArgs e)
{
using (demoEntities10 conx = new demoEntities10())
{
Spread sp = conx.Spreads.FirstOrDefault(s => s.id == id);
sp.contractid = Convert.ToInt32(contractid.SelectedValue);
sp.sessionid = Convert.ToInt32(sessionid.SelectedValue);
sp.ispread = Convert.ToInt32(ispread.Text);
sp.rspread = Convert.ToInt32(rspread.Text);
sp.rparam = Convert.ToInt32(rparam.Text);
sp.modified = DateTime.Now;
conx.SaveChanges();
}
FillDataGrid();
}
private void delete(object sender, RoutedEventArgs e)
{
var values = DateTable2.SelectedItem as Margin;
if (null == values)
{
return;
}
using (demoEntities10 conx = new demoEntities10())
{
var del = conx.Margins.Where(x => x.contractId == values.contractId).First();
conx.Margins.Remove(del);
conx.SaveChanges();
}
FillDataGrid();
}
private void delete(object sender, RoutedEventArgs e)
{
var value = DateTable2.SelectedItem as Transaction;
if (value == null)
{
return;
}
using (demoEntities10 conx = new demoEntities10())
{
var del = conx.Transactions.Where(x => x.id == value.id).First();
conx.Transactions.Remove(del);
conx.SaveChanges();
}
FillDataGrid();
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
Transaction values = DateTable2.SelectedItem as Transaction;
if (null == values)
{
return;
}
using (demoEntities10 conx = new demoEntities10())
{
Transaction std = conx.Transactions.FirstOrDefault(r => r.id == values.id);
std.state = 0;
//std.reason = Convert.ToInt16(Reasons.SelectedValue);
conx.SaveChanges();
}
FillDataGrid();
}
private void insertFunc(object sender, RoutedEventArgs e)
{
if (sboardid.SelectedItem == null || string.IsNullOrEmpty(sname.Text) ||
string.IsNullOrEmpty(match1.Text) || string.IsNullOrEmpty(sname.Text) ||
string.IsNullOrEmpty(sdesc.Text) || stimehour.SelectedItem == null ||
stimeminute.SelectedItem == null || stimeSecond.SelectedItem == null || sstate.SelectedItem == null ||
dhour.SelectedItem == null || dminute.SelectedItem == null || dsecond.SelectedItem == null
)
{
MessageBox.Show("Талбар дутууу !!!!");
return;
}
TimeSpan startTime = new TimeSpan(
Convert.ToInt32(stimehour.Text), Convert.ToInt32(stimeminute.Text), Convert.ToInt32(stimeSecond.Text));
TimeSpan dur = new TimeSpan(
Convert.ToInt32(dhour.Text), Convert.ToInt32(dminute.Text), Convert.ToInt32(dsecond.Text));
using (demoEntities10 conx = new demoEntities10())
{
Session ses = new Session
{
boardid = Convert.ToInt64(sboardid.SelectedValue),
name = sname.Text,
stime = startTime,
duration = dur,
algorithm = Convert.ToInt16(algo.SelectedIndex),
match = Convert.ToInt32(match1.Text),
description = sdesc.Text,
state = Convert.ToInt16(sstate.SelectedIndex - 1),
modified = DateTime.Now,
isactive = isAct.IsChecked,
delorder = delOrder.IsChecked,
editorder = editOrder.IsChecked,
markettype = Convert.ToInt16(markT.SelectedIndex),
Захзээлүүсгэгч = Захзээлүүсгэгч.IsChecked,
Тохиролцсон = Тохиролцсон.IsChecked,
Кросс = Кросс.IsChecked,
Нөхцөлт = Нөхцөлт.IsChecked,
ЗахЗээлийн = ЗахЗээлийн.IsChecked,
};
conx.Sessions.Add(ses);
conx.SaveChanges();
}
FillDataGrid();
}
private void update(object sender, RoutedEventArgs e)
{
Member me = memid.SelectedItem as Member;
if (me.nominal == false && linkacc.SelectedItem == null)
{
MessageBox.Show("Арилжаа холбох дансгүй бол нээгдэхүй");
return;
}
var ac = DateTable2.SelectedItem as Account;
if (acctype.SelectedIndex != 0 && linkacc.SelectedItem == null)
{
MessageBox.Show("Нэмэх боломжгүй");
return;
}
string accnu = accno.Text;
using (demoEntities10 context = new demoEntities10())
{
var exist = context.Accounts.Count(a => a.accNumber == accnu);
if (exist != 0)
{
MessageBox.Show("Account number exists " + accnu + " !!!");
return;
}
}
using (demoEntities10 conx = new demoEntities10())
{
Account acc = conx.Accounts.FirstOrDefault(r => r.id == ac.id);
acc.memberid = Convert.ToInt64(memid.SelectedValue);
acc.accNumber = accno.Text;
acc.accountType = Convert.ToInt16(accountType);
acc.state = Convert.ToInt16(pstate.SelectedIndex - 1);
acc.LinkAccount = Convert.ToInt64(linkacc.SelectedValue);
acc.startdate = sdate.SelectedDate;
acc.enddate = edate.SelectedDate;
conx.SaveChanges();
//List<AccountDetail> accd = conx.AccountDetails.Where(r => r.accountId == ac.id).ToList();
//accd.ForEach(a => a.accountId = Convert.ToInt64(accno.Text));
//conx.SaveChanges();
}
FillDataGrid();
}
private void update(object sender, RoutedEventArgs e)
{
var ac = DateTable2.SelectedItem as Margin;
using (demoEntities10 conx = new demoEntities10())
{
Margin ma = conx.Margins.FirstOrDefault(r => r.contractId == ac.contractId);
ma.buy = Convert.ToDecimal(buy.Text);
ma.buytype = Convert.ToInt16(mbuyType.SelectedIndex);
ma.sell = Convert.ToDecimal(sell.Text);
ma.selltype = Convert.ToInt16(mselltype.SelectedIndex);
ma.modified = DateTime.Now;
ma.msell = Convert.ToDecimal(mmsell.Text);
ma.mbuy = Convert.ToDecimal(mmbuy.Text);
ma.coid = Convert.ToInt64(contractid.SelectedValue);
conx.SaveChanges();
}
FillDataGrid();
}
private void update(object sender, RoutedEventArgs e)
{
var ac = DateTable2.SelectedItem as Asset;
using (demoEntities10 conx = new demoEntities10())
{
Asset asst = conx.Assets.FirstOrDefault(r => r.id == ac.id);
asst.code = acode.Text;
asst.name = aname.Text;
asst.price = Convert.ToInt32(aprice.Text);
asst.note = anote.Text;
asst.state = Convert.ToInt16(astate.SelectedIndex - 1);
asst.ratio = Convert.ToDecimal(artio.Text);
asst.expireDate = Convert.ToDateTime(aexpire.SelectedDate);
asst.volume = Convert.ToInt64(avolume.Text);
conx.SaveChanges();
}
FillDataGrid();
}
private void insertFunc(object sender, RoutedEventArgs e)
{
if (partId.SelectedValue == null ||
stype.SelectedValue == null ||
assetId.SelectedValue == null ||
sname.Text == null ||
totalquant.Text == null ||
fprice.Text == null ||
srate.Text == null ||
sdate.SelectedDate == null ||
edate.SelectedDate == null ||
state.SelectedValue == null ||
scode.Text == null)
{
MessageBox.Show("Талбарууд дутуу байна");
return;
}
if (string.IsNullOrEmpty(srate.Text))
{
srate.Text = "0";
}
using (demoEntities10 conx = new demoEntities10())
{
var secu = new Security
{
partid = Convert.ToInt32(partId.SelectedValue),
type = Convert.ToInt16(stype.SelectedIndex),
assetId = Convert.ToInt32(assetId.SelectedValue),
name = sname.Text,
totalQty = Convert.ToInt32(totalquant.Text),
firstPrice = Convert.ToDecimal(fprice.Text),
intRate = Convert.ToDecimal(srate.Text),
sdate = sdate.SelectedDate,
edate = edate.SelectedDate,
modified = DateTime.Now,
state = Convert.ToInt16(state.SelectedIndex - 1),
code = scode.Text,
};
conx.Securities.Add(secu);
conx.SaveChanges();
}
FillDataGrid();
}
private void Button_Click_2(object sender, RoutedEventArgs e)
{
using (demoEntities10 conx = new demoEntities10())
{
user us = conx.users.FirstOrDefault(r => r.id == id);
us.uname = usname.Text;
us.password = upass.Password;
us.role = urole.SelectedIndex.ToString();
//us.memId = (int)members.SelectedValue;
us.modified = DateTime.Now;
us.serverip = server.Text;
us.serverDatabase = database.Text;
us.serverUname = serveruname.Text;
us.serverPassword = serverpassword.Text;
us.modified = DateTime.Now;
conx.SaveChanges();
}
FillGrid();
}
private void update(object sender, RoutedEventArgs e)
{
if (sboardid.SelectedItem == null || string.IsNullOrEmpty(sname.Text) ||
string.IsNullOrEmpty(match1.Text) || string.IsNullOrEmpty(sname.Text) ||
string.IsNullOrEmpty(sdesc.Text) || stimehour.SelectedItem == null ||
stimeminute.SelectedItem == null || stimeSecond.SelectedItem == null || sstate.SelectedItem == null ||
dhour.SelectedItem == null || dminute.SelectedItem == null || dsecond.SelectedItem == null
)
{
MessageBox.Show("Талбар дутууу !!!!");
return;
}
TimeSpan startTime = new TimeSpan(
Convert.ToInt32(stimehour.Text), Convert.ToInt32(stimeminute.Text), Convert.ToInt32(stimeSecond.Text));
TimeSpan dur = new TimeSpan(
Convert.ToInt32(dhour.Text), Convert.ToInt32(dminute.Text), Convert.ToInt32(dsecond.Text));
using (demoEntities10 conx = new demoEntities10())
{
Session se = conx.Sessions.FirstOrDefault(r => r.id == id);
se.boardid = Convert.ToInt64(sboardid.SelectedValue);
se.name = sname.Text;
se.stime = startTime;
se.duration = dur;
se.algorithm = Convert.ToInt16(algo.SelectedIndex);
se.match = Convert.ToInt32(match1.Text);
se.description = sdesc.Text;
se.state = Convert.ToInt16(sstate.SelectedIndex - 1);
se.modified = DateTime.Now;
se.isactive = isAct.IsChecked;
se.delorder = delOrder.IsChecked;
se.editorder = editOrder.IsChecked;
se.markettype = Convert.ToInt16(markT.SelectedIndex);
se.Захзээлүүсгэгч = Захзээлүүсгэгч.IsChecked;
se.Тохиролцсон = Тохиролцсон.IsChecked;
se.Кросс = Кросс.IsChecked;
se.Нөхцөлт = Нөхцөлт.IsChecked;
se.ЗахЗээлийн = ЗахЗээлийн.IsChecked;
conx.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();
}
private void insertFunc(object sender, RoutedEventArgs e)
{
if (memid.SelectedItem == null || accid.SelectedItem == null || stat.SelectedItem == null)
{
MessageBox.Show("Талбар дутууу !!!!");
return;
}
using (demoEntities10 contx = new demoEntities10())
{
DealerAccount dea = new DealerAccount
{
memberid = Convert.ToInt32(memid.SelectedValue),
accountid = Convert.ToInt64(accid.SelectedValue),
state = Convert.ToInt16(stat.SelectedIndex - 1),
modified = DateTime.Now,
};
contx.DealerAccounts.Add(dea);
contx.SaveChanges();
}
FillDataGrid();
}
private void update(object sender, RoutedEventArgs e)
{
using (demoEntities10 conx = new demoEntities10())
{
Security se = conx.Securities.FirstOrDefault(r => r.id == id);
se.partid = Convert.ToInt32(partId.SelectedValue);
se.type = Convert.ToInt16(stype.SelectedIndex);
se.code = scode.Text;
se.name = sname.Text;
se.totalQty = Convert.ToInt32(totalquant.Text);
se.firstPrice = Convert.ToDecimal(fprice.Text);
se.intRate = Convert.ToDecimal(srate.Text);
se.sdate = sdate.SelectedDate;
se.edate = edate.SelectedDate;
se.state = Convert.ToInt16(state.SelectedIndex - 1);
se.modified = DateTime.Now;
se.assetId = Convert.ToInt32(assetId.SelectedValue);
conx.SaveChanges();
}
FillDataGrid();
}
private void update(object sender, RoutedEventArgs e)
{
var ac = DateTable2.SelectedItem as MarketMaker;
using (demoEntities10 conx = new demoEntities10())
{
MarketMaker mm = conx.MarketMakers.FirstOrDefault(r => r.id == ac.id);
mm.contactid = Convert.ToInt32(markcontact.SelectedValue);
mm.memberid = Convert.ToInt32(markmember.SelectedValue);
mm.modified = DateTime.Now;
mm.accountid = Convert.ToInt64(markaccount.SelectedValue);
mm.startdate = Convert.ToDateTime(sdat.SelectedDate);
mm.enddate = Convert.ToDateTime(edat.SelectedDate);
mm.ticks = Convert.ToInt32(markticks.Text);
mm.description = markdesc.Text;
mm.orderlimit = Convert.ToInt32(markorderl.Text);
mm.state = Convert.ToInt16(markstat.SelectedIndex - 1);
conx.SaveChanges();
}
FillDataGrid();
}
private void delete(object sender, RoutedEventArgs e)
{
long iiid = (DateTable2.SelectedItem as TickSizeTable).id;
demoEntities10 de = new demoEntities10();
TickSizeTable del = de.TickSizeTables.Find(iiid);
de.Entry(del).State = EntityState.Deleted;
de.SaveChanges();
// var value = DateTable2.SelectedItem as DataRowView;
// if (null == value) return;
// id = value.Row[0].ToString();
// System.Data.SqlClient.SqlConnection sqlConnection1 =
//new System.Data.SqlClient.SqlConnection(connectionString);
// System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = "DELETE demo.dbo.TickSizeTable WHERE id='" + id + "'";
// cmd.Connection = sqlConnection1;
// sqlConnection1.Open();
// cmd.ExecuteNonQuery();
// sqlConnection1.Close();
FillDataGrid();
}
