private void bindCombo()
{
demoEntities10 st = new demoEntities10();
participants.ItemsSource = st.Participants.ToList();
linkMember.ItemsSource = st.Members.Where(s => s.type == 1).ToList();
}
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 (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 bindcombo()
{
demoEntities10 dc = new demoEntities10();
partId.ItemsSource = dc.Participants.ToList();;
assetId.ItemsSource = dc.Assets.ToList();
}
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 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 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 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 (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 (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 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 bindcombo()
{
demoEntities10 dc = new demoEntities10();
memid.ItemsSource = dc.Members.ToList();
linkacc.ItemsSource = dc.Accounts.ToList();
}
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 (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 bindcombo()
{
demoEntities10 dc = new demoEntities10();
markmember.ItemsSource = dc.Members.ToList();
markcontact.ItemsSource = dc.Contracts.ToList();
markaccount.ItemsSource = dc.Accounts.ToList();
}
private void bindcombo()
{
demoEntities10 dc = new demoEntities10();
sboardid.ItemsSource = dc.Members.ToList();
accId.ItemsSource = dc.Accounts.ToList();
asstId.ItemsSource = dc.Assets.ToList();
}
private void bindCombo()
{
demoEntities10 dE = new demoEntities10();
securityid_Copy.ItemsSource = dE.Securities.ToList();
boardid.ItemsSource = dE.Boards.ToList();
ctick.ItemsSource = dE.TickSizeTables.ToList();
}
private void bindCombo()
{
demoEntities10 ac = new demoEntities10();
var act = ac.Accounts.ToList();
ACCT = act;
accountid.ItemsSource = ACCT;
}
private void bindCombo()
{
demoEntities10 de = new demoEntities10();
var reasonss = de.Reasons.ToList();
reas = reasonss;
Reasons.ItemsSource = reas;
}
private void bindCombo()
{
demoEntities10 dc = new demoEntities10();
memid.ItemsSource = dc.Members.ToList();
boardid.ItemsSource = dc.Boards.ToList();
accountid.ItemsSource = dc.Accounts.ToList();
assetid.ItemsSource = dc.Assets.ToList();
}
private void acctype_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
linkacc.SelectedItem = null;
linkacc.ItemsSource = null;
string item = acctype.Text;
try
{
switch (item)
{
case "Төлбөр":
linkacc.IsEnabled = false;
break;
case "Барьцаа":
linkType = 0;
linkacc.IsEnabled = true;
break;
case "Клиринг":
linkType = 0;
linkacc.IsEnabled = true;
break;
case "Арилжаа":
linkType = 2;
linkacc.IsEnabled = true;
break;
case "":
MessageBox.Show("Empty String");
break;
default:
MessageBox.Show("Error not expected !!! " + item);
break;
}
if (item == null)
{
return;
}
demoEntities10 dc = new demoEntities10();
List <Account> linkas = linkacc.ItemsSource as List <Account>;
var lists = dc.Accounts.Where(s => s.accountType == linkType).ToList();
//var final = linkas.Where
//linkacc.ItemsSource = linkas.;
var items = memid.SelectedItem as Member;
//var lists = dc.Accounts.Where(r => r.memberid == items.id).ToList();
linkacc.ItemsSource = lists.Where(s => s.accountType == linkType).ToList();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
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 FillDataGrid()
{
demoEntities10 de = new demoEntities10();
DateTable2.ItemsSource = de.TickSizeTables.ToList();
//using (SqlConnection conn = new SqlConnection(connectionString))
//{
// string CmdString = "SELECT * FROM dbo.TickSizeTable";
// SqlCommand cmd = new SqlCommand(CmdString, conn);
// SqlDataAdapter sda = new SqlDataAdapter(cmd);
// DataTable dt = new DataTable("Securities");
// sda.Fill(dt);
// DateTable2.ItemsSource = dt.DefaultView;
//}
}
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();
}
