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(); }