private void btnSubmit_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
if (oBtn != null && FormLoaded)
{
dataGridView1.Rows.Clear();
DyeParameters.FromDate = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString());
DyeParameters.ToDate = Convert.ToDateTime(dtpToDate.Value.ToShortDateString());
DyeParameters.ToDate = DyeParameters.ToDate.AddHours(23);
var CommTransGrps = repo.CommissionTransactions(DyeParameters).GroupBy(x => x.GreigeCom_GrnNo);
using (var context = new TTI2Entities())
{
foreach (var Grp in CommTransGrps)
{
var index = dataGridView1.Rows.Add();
dataGridView1.Rows[index].Cells[0].Value = Grp.FirstOrDefault().GreigeCom_GrnNo.ToString();
dataGridView1.Rows[index].Cells[1].Value = Grp.FirstOrDefault().GreigeCom_Transdate;
dataGridView1.Rows[index].Cells[2].Value = Grp.FirstOrDefault().GreigeCom_Custdoc;
var Pk = Grp.FirstOrDefault().GreigeCom_ProductType_FK;
dataGridView1.Rows[index].Cells[3].Value = context.TLADM_Griege.Find(Pk).TLGreige_Description;
dataGridView1.Rows[index].Cells[4].Value = Grp.FirstOrDefault().GreigeCom_Custdoc;
dataGridView1.Rows[index].Cells[5].Value = Grp.Count();
dataGridView1.Rows[index].Cells[6].Value = Grp.Sum(x => x.GreigeCom_NettWeight);
}
}
comboCustomers.Items.Clear();
comboQuality.Items.Clear();
frmViewCommissionReceipts_Load(this, null);
}
}
private void chkPrevious_CheckedChanged(object sender, EventArgs e)
{
CheckBox oChk = (CheckBox)sender;
IList <TLCMT_PanelIssue> PanelIssue = new List <TLCMT_PanelIssue>();
if (oChk != null && oChk.Checked && formloaded)
{
var selected = (TLADM_Departments)cmboCMT.SelectedItem;
if (selected != null)
{
using (var context = new TTI2Entities())
{
var Dt = dtpTransDate.Value;
var ExistingGrouped = context.TLCMT_PanelIssue.Where(x => x.CMTPI_Closed && x.CMTPI_Date >= Dt && x.CMTPI_Department_FK == selected.Dep_Id).GroupBy(x => x.CMTPI_DeliveryNumber).ToList();
foreach (var Grp in ExistingGrouped)
{
PanelIssue.Add(Grp.FirstOrDefault());
}
formloaded = false;
cmboPrevious.DataSource = PanelIssue;
cmboPrevious.ValueMember = "CMTPI_Pk";
cmboPrevious.DisplayMember = "CMTPI_DeliveryNumber";
cmboPrevious.SelectedValue = -1;
formloaded = true;
}
}
}
else
{
label2.Text = string.Empty;
label6.Text = string.Empty;
label7.Text = string.Empty;
cmboPrevious.DataSource = null;
cmboPrevious.Items.Clear();
}
}
