private void Хүлээгдэжбуйгүйлгээ(object sender, RoutedEventArgs e)
{
List <ForGrid> ToDisplay2 = new List <ForGrid>();
Model1 ce = new Model1();
List <AdminOrder> requs = ce.AdminOrders.Where(r => r.state == 1 || r.state == 0 && r.memberid == memId).ToList <AdminOrder>();
var t = from tt in requs
join a1 in ce.AdminAssets on tt.assetid equals a1.id
select new
{
tt.id,
astprice = a1.price,
tt.accountid,
tt.state,
a1.name,
a1.ratio,
tt.qty,
a1.price,
};
foreach (var items in t)
{
decimal price = Convert.ToDecimal(items.price);
decimal ratio = Convert.ToDecimal(items.ratio);
decimal qty = Convert.ToDecimal(items.qty);
decimal totval = qty * (ratio * price);
ForGrid data = new ForGrid()
{
id = Convert.ToInt64(items.id),
accNumber = items.accountid.ToString(),
Барьцаа = items.name,
Хэмжээ = Convert.ToInt32(qty),
ЖишигҮнэ = (ratio * price).ToString("0.###"),
НийтДүн = totval.ToString("0.###"),
ДоодДүн = minval.ToString("0.###"),
ЗөрүүДүн = (totval - minval).ToString("0.###"),
state = items.state == 0 ? "Denied" : "Pending",
};
ToDisplay2.Add(data);
}
pendingColl.ItemsSource = ToDisplay2;
}
private void Биржийнбарьца(object sender, RoutedEventArgs e)
{
Model1 ce = new Model1();
List <ForGrid> Биржбарьцаа = new List <ForGrid>();
var accNums = ce.Accounts.Where(s => s.memId == memId).Select(s => s.id).ToArray();
foreach (var acnum in accNums)
{
var adet = ce.AccountDetails.Where(s => s.accountId == acnum).FirstOrDefault <AccountDetail>();
if (adet == null)
{
MessageBox.Show("Asset empty");
return;
}
AdminAsset asst = ce.AdminAssets.Where(s => s.id == adet.assetId).FirstOrDefault <AdminAsset>();
if (asst == null)
{
MessageBox.Show("Дансны дугаарууд Үц байхгүй байна");
return;
}
decimal price = Convert.ToDecimal(asst.price);
decimal jish = Convert.ToDecimal(asst.ratio * price);
decimal tot = Convert.ToDecimal(adet.totalNumber * jish);
//Adminmtype mty = ce.Adminmtypes.Where(r => r.id == 1).FirstOrDefault<Adminmtype>();
//int minval = Convert.ToInt32(mty.minValue);
ForGrid data = new ForGrid()
{
id = adet.id,
Барьцаа = asst.name,
Хэмжээ = Convert.ToDecimal(adet.totalNumber),
ЖишигҮнэ = (jish).ToString("0.##"),
НийтДүн = (tot).ToString("0.##"),
ДоодДүн = minval.ToString("0.##"),
ЗөрүүДүн = (tot - minval).ToString("0.##"),
};
Биржбарьцаа.Add(data);
}
Биржийнбарьцаа.ItemsSource = Биржбарьцаа;
}
private void assets2_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
tuhBalance.ItemsSource = null;
Model1 ce = new Model1();
var item = assets.SelectedValue;
int id = Convert.ToInt32(item);
var acc = ce.Accounts.Where(s => s.memId == memid).ToList();
var t = from tt in acc
join accde in ce.AccountDetails on tt.id equals accde.accountId
join ass in ce.AdminAssets on accde.assetId equals ass.id
where accde.assetId == id
select new
{
tt.accNum,
accde.totalNumber,
accde.freezeValue,
ass.name,
боломжит = accde.totalNumber - accde.freezeValue,
tt.state,
};
foreach (var i in t)
{
ForGrid data = new ForGrid()
{
accNum = i.accNum,
name = i.name,
totalNumber = (decimal)i.totalNumber,
freezeValue = (decimal)i.freezeValue,
боломжит = (decimal)i.боломжит,
state = (short)i.state,
};
forgrid.Add(data);
}
;
tuhBalance.ItemsSource = t;
}
private void assets_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Model1 ce = new Model1();
var item = assets.SelectedValue;
int id = Convert.ToInt32(item);
var acc = ce.AdminAccounts.Where(s => s.memberid == memid && s.accountType == 3).ToList();
var t = from tt in acc
join accde in ce.AdminAccountDetails on tt.id equals accde.accountId
join ass in ce.AdminAssets on accde.assetId equals ass.id
where accde.assetId == id
select new
{
tt.accNumber,
accde.amount,
accde.freezeValue,
ass.name,
боломжит = accde.amount - accde.freezeValue,
tt.state,
};
foreach (var i in t)
{
ForGrid data = new ForGrid()
{
accNum = i.accNumber,
name = i.name,
totalNumber = (int)i.amount,
freezeValue = (int)i.freezeValue,
боломжит = (int)i.боломжит,
state = (short)i.state,
};
forgrid1.Add(data);
}
;
unitedData.ItemsSource = forgrid1;
}
private void БарьцааТүүх(object sender, RoutedEventArgs e)
{
Model1 ce = new Model1();
List <AdminTransaction> trans = ce.AdminTransactions.ToList();
List <ForGrid> ToDisplay = new List <ForGrid>();
var t = from tt in trans
join a in ce.AdminAssets on tt.assetId equals a.id
select new
{
tt.id,
tt.accountId,
a.name,
tt.amount,
a.ratio,
a.price,
totval = tt.amount * a.ratio * a.price,
refprice = a.ratio * a.price,
diff = tt.amount * a.ratio * a.price - minval
};
foreach (var item in t)
{
decimal qty = Convert.ToDecimal(item.amount);
decimal totval = Convert.ToDecimal(item.totval);
decimal refprice = Convert.ToDecimal(item.refprice);
decimal diff = Convert.ToDecimal(item.diff);
ForGrid data = new ForGrid()
{
id = Convert.ToInt64(item.id),
accNumber = item.accountId.ToString(),
Барьцаа = item.name.ToString(),
Хэмжээ = Convert.ToInt32(qty),
ЖишигҮнэ = refprice.ToString("0.###"),
НийтДүн = totval.ToString("0.###"),
ДоодДүн = minval.ToString("0.###"),
ЗөрүүДүн = diff.ToString("0.###"),
//БуцаахДүн=,
};
ToDisplay.Add(data);
}
//foreach (AdminTransaction items in trans)
//{
// asset1 = Convert.ToInt32(items.assetId);
// AdminAsset asst = ce.AdminAssets.Where(r => r.id == asset1).FirstOrDefault<AdminAsset>();
// decimal price = Convert.ToDecimal(asst.price);
// decimal ratio = Convert.ToDecimal(asst.ratio);
// decimal qty = Convert.ToDecimal(items.amount);
// decimal totval = qty * (ratio * price);
// ForGrid data = new ForGrid()
// {
// id = Convert.ToInt64(items.id),
// accNumber = items.accountId.ToString(),
// Барьцаа = asst.name.ToString(),
// Хэмжээ = Convert.ToInt32(qty),
// ЖишигҮнэ = (ratio * price).ToString("0.###"),
// НийтДүн = totval.ToString("0.###"),
// ДоодДүн = minval.ToString("0.###"),
// ЗөрүүДүн = (totval - minval).ToString("0.###"),
// //БуцаахДүн=,
// };
// ToDisplay.Add(data);
//}
collHistory.ItemsSource = ToDisplay;
}
