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;
}
}
public frmPlanningKnitStock()
{
InitializeComponent();
repo = new PPSRepository();
//--------------------------------------------------------
// wire up the check state changed event
//--------------------------------------------------------------------------------------------------------
this.cmboGreige.CheckStateChanged += new System.EventHandler(this.cmboGreige_CheckStateChanged);
this.cmboGreigeQuality.CheckStateChanged += new System.EventHandler(this.cmboGreigeQuality_CheckStateChanged);
this.cmboFabWeight.CheckStateChanged += new System.EventHandler(this.cmboFabWeight_CheckStateChanged);
this.cmboFabWidth.CheckStateChanged += new System.EventHandler(this.cmboFabWidth_CheckStateChanged);
this.cmboStore.CheckStateChanged += new System.EventHandler(this.cmboStore_CheckStateChanged);
}
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;
}
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;
}
}
