private void button1_Click(object sender, EventArgs e)
{
DateTime from = dateTimePicker1.Value.Date;
DateTime to = dateTimePicker2.Value.Date;
using (AccountingRef.AccountingClient client = new AccountingRef.AccountingClient())
{
var result = client.GetTxCylinders(from, to, "");
var groups = result.Where(x => x.CashMemoNo == 0).AsEnumerable().GroupBy(g => g.CylinderDetails).Select(g => new { CylinderDetails = g.Key, Price = Math.Round(g.Sum(s => s.Price) / g.Count(), 2), Quentity = g.Sum(s => s.Quentity), Total = g.Sum(s => s.Total) });
dataGridView1.DataSource = groups.ToList();
groups = result.Where(x => x.CashMemoNo != 0).AsEnumerable().GroupBy(g => g.CylinderDetails).Select(g => new { CylinderDetails = g.Key, Price = Math.Round(g.Sum(s => s.Price) / g.Count(), 2), Quentity = g.Sum(s => s.Quentity), Total = g.Sum(s => s.Total) });
dataGridView3.DataSource = groups.ToList();
var result1 = client.GetTxStoveRegulators(from, to, "");
var groups1 = result1.Where(x => x.CashMemoNo == 0).AsEnumerable().GroupBy(g => g.Details).Select(g => new { Details = g.Key, Price = Math.Round(g.Sum(s => s.Price) / g.Count(), 2), Quentity = g.Sum(s => s.Quentity), Total = g.Sum(s => s.Total) });
dataGridView2.DataSource = groups1.ToList();
groups1 = result1.Where(x => x.CashMemoNo != 0).AsEnumerable().GroupBy(g => g.Details).Select(g => new { Details = g.Key, Price = Math.Round(g.Sum(s => s.Price) / g.Count(), 2), Quentity = g.Sum(s => s.Quentity), Total = g.Sum(s => s.Total) });
dataGridView4.DataSource = groups1.ToList();
}
}
private void button1_Click_1(object sender, EventArgs e)
{
// dataGridView1.Rows.Clear();
DateTime from = dateTimePicker1.Value;
DateTime to = dateTimePicker2.Value;
string cyType = comboBox1.Text;
using (AccountingRef.AccountingClient client = new AccountingRef.AccountingClient())
{
var result = client.GetTxStoveRegulators(from, to, cyType);
if (!checkBox1.Checked)
{
result = result.Where(x => x.CashMemoNo == 0).ToArray();
}
if (!checkBox2.Checked)
{
result = result.Where(x => x.CashMemoNo != 0).ToArray();
}
label5.Text = result.Count().ToString();
result = result.OrderByDescending(x => x.TxDate).ToArray();
dataGridView1.DataSource = result;
}
}