private void frmSuggestedKO_Load(object sender, EventArgs e)
{
formloaded = false;
QueryParms = new ProdQueryParameters();
repo = new PPSRepository();
using (var context = new TTI2Entities())
{
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault();
if (Dept != null)
{
var ExistingMachines = context.TLADM_MachineDefinitions.Where(x => x.MD_Department_FK == Dept.Dep_Id).OrderBy(x => x.MD_MachineCode).ToList();
foreach (var record in ExistingMachines)
{
cmboMachine.Items.Add(new ProductionPlanning.CheckComboBoxItem(record.MD_Pk, record.MD_Description, false));
}
var ExistingGreige = context.TLADM_Griege.ToList();
foreach (var record in ExistingGreige)
{
cmboGreige.Items.Add(new ProductionPlanning.CheckComboBoxItem(record.TLGreige_Id, record.TLGreige_Description, false));
}
var ExistingQuality = context.TLADM_GreigeQuality.ToList();
foreach (var record in ExistingQuality)
{
cmboGreigeQuality.Items.Add(new ProductionPlanning.CheckComboBoxItem(record.GQ_Pk, record.GQ_Description, false));
}
}
formloaded = true;
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
Button oBtn = (Button)sender;
if (oBtn != null && FormLoaded)
{
if (!chkCMT.Checked && !chkCutting.Checked && !chkDyePrep.Checked && !chkWhse.Checked)
{
MessageBox.Show("Please select at least one Department to report on");
return;
}
if (chkDyePrep.Checked)
{
ReportDepts[0] = true;
}
if (chkCutting.Checked)
{
ReportDepts[1] = true;
}
if (chkCMT.Checked)
{
ReportDepts[2] = true;
}
if (chkWhse.Checked)
{
ReportDepts[3] = true;
}
ProductionPlanning.ProdQueryParameters QueryParms = new ProductionPlanning.ProdQueryParameters();
QueryParms.QAReportingDepts = ReportDepts;
DateTime FromDate = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString());
DateTime ToDate = Convert.ToDateTime(dtpToDate.Value.ToShortDateString());
ToDate = ToDate.AddHours(23);
QueryParms.FromDate = FromDate;
QueryParms.ToDate = ToDate;
frmPPSViewRep vRep = new frmPPSViewRep(6, QueryParms);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog();
frmQASDaysDelay_Load(this, null);
}
}
public IQueryable <TLPPS_Replenishment> PPSQuery(ProdQueryParameters parameters)
{
var PPSSortOrder = from T1 in _context.TLPPS_Replenishment
join T2 in _context.TLADM_Styles on T1.TLREP_Style_FK equals T2.Sty_Id
join T3 in _context.TLADM_Colours on T1.TLREP_Colour_FK equals T3.Col_Id
join T4 in _context.TLADM_Sizes on T1.TLREP_Size_FK equals T4.SI_id
orderby T2.Sty_Description, T3.Col_Display, T4.SI_DisplayOrder
select T1;
var PPS = PPSSortOrder.Where(x => (bool)x.TLREP_Discontinued != true).AsQueryable();
if (parameters.Styles.Count() > 0)
{
var stylePredicate = PredicateBuilder.False <TLPPS_Replenishment>();
foreach (var style in parameters.Styles)
{
var temp = style;
stylePredicate = stylePredicate.Or(s => s.TLREP_Style_FK == temp.Sty_Id);
}
PPS = PPS.AsExpandable().Where(stylePredicate);
}
if (parameters.Colours.Count() > 0)
{
var colourPredicate = PredicateBuilder.False <TLPPS_Replenishment>();
foreach (var style in parameters.Colours)
{
var temp = style;
colourPredicate = colourPredicate.Or(s => s.TLREP_Colour_FK == temp.Col_Id);
}
PPS = PPS.AsExpandable().Where(colourPredicate);
}
if (parameters.Sizes.Count() > 0)
{
var sizePredicate = PredicateBuilder.False <TLPPS_Replenishment>();
foreach (var style in parameters.Sizes)
{
var temp = style;
sizePredicate = sizePredicate.Or(s => s.TLREP_Size_FK == temp.SI_id);
}
PPS = PPS.AsExpandable().Where(sizePredicate);
}
return(PPS);
}
private void PlanningKnitStock_Load(object sender, EventArgs e)
{
FormLoaded = false;
QueryParms = new ProdQueryParameters();
using (var context = new TTI2Entities())
{
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault();
if (Dept != null)
{
var ExistingGreige = context.TLADM_Griege.OrderBy(x => x.TLGreige_Description).ToList();
foreach (var record in ExistingGreige)
{
cmboGreige.Items.Add(new ProductionPlanning.CheckComboBoxItem(record.TLGreige_Id, record.TLGreige_Description, false));
}
var ExistQuality = context.TLADM_GreigeQuality.ToList();
foreach (var record in ExistQuality)
{
cmboGreigeQuality.Items.Add(new ProductionPlanning.CheckComboBoxItem(record.GQ_Pk, record.GQ_Description, false));
}
var ExistWeight = context.TLADM_FabricWeight.ToList();
foreach (var Record in ExistWeight)
{
cmboFabWeight.Items.Add(new ProductionPlanning.CheckComboBoxItem(Record.FWW_Id, Record.FWW_Description, false));
}
var ExistWidth = context.TLADM_FabWidth.ToList();
foreach (var record in ExistWidth)
{
cmboFabWidth.Items.Add(new ProductionPlanning.CheckComboBoxItem(record.FW_Id, record.FW_Description, false));
}
var ExistWhse = context.TLADM_WhseStore.Where(x => x.WhStore_WhseOrStore).ToList();
foreach (var record in ExistWhse)
{
cmboStore.Items.Add(new ProductionPlanning.CheckComboBoxItem(record.WhStore_Id, record.WhStore_Description, false));
}
}
FormLoaded = true;
}
}
public IQueryable <TLCSV_PurchaseOrder> PPSCustomers(ProdQueryParameters parameters)
{
var PO = _context.TLCSV_PurchaseOrder.Where(x => !x.TLCSVPO_Closeed).AsQueryable();
if (parameters.Customers.Count() != 0)
{
var CustomerPredicate = PredicateBuilder.False <TLCSV_PurchaseOrder>();
foreach (var Customer in parameters.Customers)
{
var temp = Customer;
CustomerPredicate = CustomerPredicate.Or(s => s.TLCSVPO_Customer_FK == temp.Cust_Pk);
}
PO = PO.AsExpandable().Where(CustomerPredicate);
}
return(PO);
}
public IQueryable <TLCSV_StockOnHand> PPSSales(ProdQueryParameters parameters)
{
var SOH = (from soh in _context.TLCSV_StockOnHand
join szs in _context.TLADM_Sizes on soh.TLSOH_Size_FK equals szs.SI_id
where soh.TLSOH_Sold && !soh.TLSOH_Returned && soh.TLSOH_SoldDate >= parameters.FromDate && soh.TLSOH_SoldDate <= parameters.ToDate
orderby szs.SI_DisplayOrder
select soh).AsQueryable();
/*
* if (parameters.Styles.Count() != 0)
* {
* var StylePredicate = PredicateBuilder.False<TLCSV_StockOnHand>();
* foreach (var Style in parameters.Styles)
* {
* var temp = Style;
* StylePredicate = StylePredicate.Or(s => s.TLSOH_Style_FK == temp.Sty_Id);
* }
* SOH = SOH.AsExpandable().Where(StylePredicate);
* }
*
*
* if (parameters.Colours.Count() != 0)
* {
* var ColourPredicate = PredicateBuilder.False<TLCSV_StockOnHand>();
* foreach (var Colour in parameters.Colours)
* {
* var temp = Colour;
* ColourPredicate = ColourPredicate.Or(s => s.TYLSOH_Colour_FK == temp.Col_Id);
* }
* SOH = SOH.AsExpandable().Where(ColourPredicate);
* }
*
* if (parameters.Sizes.Count() != 0)
* {
* var SizePredicate = PredicateBuilder.False<TLCSV_StockOnHand>();
* foreach (var Size in parameters.Sizes)
* {
* var temp = Size;
* SizePredicate = SizePredicate.Or(s => s.TLSOH_Size_FK == temp.SI_id);
* }
* SOH = SOH.AsExpandable().Where(SizePredicate);
* }
*/
return(SOH);
}
private void button1_Click(object sender, EventArgs e)
{
Button oBth = sender as Button;
if (oBth != null && formloaded)
{
frmPPSViewRep vRep = new frmPPSViewRep(3, QueryParms);
vRep.ShowDialog();
QueryParms = new ProdQueryParameters();
cmboGreige.SelectedIndex = -1;
cmboGreigeQuality.SelectedIndex = -1;
cmboFabWeight.SelectedIndex = -1;
cmboFabWidth.SelectedIndex = -1;
cmboStore.SelectedIndex = -1;
}
}
private void frmSelReorderDetails_Load(object sender, EventArgs e)
{
formloaded = false;
repo = new PPSRepository();
parms = new ProdQueryParameters();
using (var context = new TTI2Entities())
{
var Customers = context.TLADM_CustomerFile.OrderBy(x => x.Cust_Description).ToList();
foreach (var Customer in Customers)
{
cmboCustomers.Items.Add(new ProductionPlanning.CheckComboBoxItem(Customer.Cust_Pk, Customer.Cust_Description, false));
}
var Styles = context.TLADM_Styles.ToList();
foreach (var Style in Styles)
{
cmboStyles.Items.Add(new ProductionPlanning.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
}
var Colours = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList();
foreach (var Colour in Colours)
{
cmboColours.Items.Add(new ProductionPlanning.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
}
var Sizes = context.TLADM_Sizes.OrderBy(x => x.SI_DisplayOrder).ToList();
foreach (var Size in Sizes)
{
cmboSizes.Items.Add(new ProductionPlanning.CheckComboBoxItem(Size.SI_id, Size.SI_Description, false));
}
}
//--------------------------------------------------------
// wire up the check state changed event
//--------------------------------------------------------------------------------------------------------
this.cmboCustomers.CheckStateChanged += new System.EventHandler(this.cmboCustomer_CheckStateChanged);
this.cmboStyles.CheckStateChanged += new System.EventHandler(this.cmboStyles_CheckStateChanged);
this.cmboColours.CheckStateChanged += new System.EventHandler(this.cmboColours_CheckStateChanged);
this.cmboSizes.CheckStateChanged += new System.EventHandler(this.cmboSizes_CheckStateChanged);
formloaded = true;
}
public IQueryable <TLADM_Griege> GreigeQuery(ProdQueryParameters parameters)
{
var GreigeItems = _context.TLADM_Griege.OrderBy(x => x.TLGreige_Description).AsQueryable();
if (parameters.Greiges.Count > 0)
{
var GreigePredicate = PredicateBuilder.False <TLADM_Griege>();
foreach (var Greige in parameters.Greiges)
{
var temp = Greige;
GreigePredicate = GreigePredicate.Or(s => s.TLGreige_Id == temp.TLGreige_Id);
}
GreigeItems = GreigeItems.AsExpandable().Where(GreigePredicate);
}
if (parameters.GreigeQualities.Count > 0)
{
var GreigeQualityPredicate = PredicateBuilder.False <TLADM_Griege>();
foreach (var Greige in parameters.GreigeQualities)
{
var temp = Greige;
GreigeQualityPredicate = GreigeQualityPredicate.Or(s => s.TLGreige_Quality_FK == temp.GQ_Pk);
}
GreigeItems = GreigeItems.AsExpandable().Where(GreigeQualityPredicate);
}
if (parameters.KnitMachines.Count > 0)
{
var KnitMachinePredicate = PredicateBuilder.False <TLADM_Griege>();
foreach (var Machine in parameters.KnitMachines)
{
var temp = Machine;
KnitMachinePredicate = KnitMachinePredicate.Or(s => s.TLGreige_Machine_FK == temp.MD_Pk);
}
GreigeItems = GreigeItems.AsExpandable().Where(KnitMachinePredicate);
}
return(GreigeItems);
}
public IQueryable <TLPPS_Replenishment> PPSQItemStatus(ProdQueryParameters parameters)
{
var IS = _context.TLPPS_Replenishment.AsQueryable();
if (parameters.Styles.Count() > 0)
{
var stylePredicate = PredicateBuilder.False <TLPPS_Replenishment>();
foreach (var style in parameters.Styles)
{
var temp = style;
stylePredicate = stylePredicate.Or(s => s.TLREP_Style_FK == temp.Sty_Id);
}
IS = IS.AsExpandable().Where(stylePredicate);
}
if (parameters.Colours.Count() > 0)
{
var colourPredicate = PredicateBuilder.False <TLPPS_Replenishment>();
foreach (var style in parameters.Colours)
{
var temp = style;
colourPredicate = colourPredicate.Or(s => s.TLREP_Colour_FK == temp.Col_Id);
}
IS = IS.AsExpandable().Where(colourPredicate);
}
if (parameters.Sizes.Count() > 0)
{
var sizePredicate = PredicateBuilder.False <TLPPS_Replenishment>();
foreach (var style in parameters.Sizes)
{
var temp = style;
sizePredicate = sizePredicate.Or(s => s.TLREP_Size_FK == temp.SI_id);
}
IS = IS.AsExpandable().Where(sizePredicate);
}
return(IS);
}
private void PlanningKnitStock_Load(object sender, EventArgs e)
{
formloaded = false;
QueryParms = new ProdQueryParameters();
repo = new PPSRepository();
using (var context = new TTI2Entities())
{
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault();
if (Dept != null)
{
cmboGreige.DataSource = context.TLADM_Griege.ToList();
cmboGreige.ValueMember = "TLGreige_Id";
cmboGreige.DisplayMember = "TLGreige_Description";
cmboGreige.SelectedIndex = -1;
cmboGreigeQuality.DataSource = context.TLADM_GreigeQuality.ToList();
cmboGreigeQuality.ValueMember = "GQ_Pk";
cmboGreigeQuality.DisplayMember = "GQ_Description";
cmboGreigeQuality.SelectedIndex = -1;
cmboFabWeight.DataSource = context.TLADM_FabricWeight.ToList();
cmboFabWeight.ValueMember = "FWW_Id";
cmboFabWeight.DisplayMember = "FWW_Description";
cmboFabWeight.SelectedIndex = -1;
cmboFabWidth.DataSource = context.TLADM_FabWidth.ToList();
cmboFabWidth.ValueMember = "FW_Id";
cmboFabWidth.DisplayMember = "FW_description";
cmboFabWidth.SelectedIndex = -1;
cmboStore.DataSource = context.TLADM_WhseStore.Where(x => x.WhStore_DepartmentFK == Dept.Dep_Id && !x.WhStore_WhseOrStore).ToList();
cmboStore.ValueMember = "WhStore_Id";
cmboStore.DisplayMember = "WhStore_Description";
cmboStore.SelectedIndex = -1;
}
formloaded = true;
}
}