public IQueryable <TLKNI_YarnOrderPallets> YarnOrderPallets(KnitQueryParameters parameters)
{
var YarnOP = _context.TLKNI_YarnOrderPallets.Where(x => x.TLKNIOP_ReservedDate >= parameters.FromDate && x.TLKNIOP_ReservedDate <= parameters.ToDate && x.TLKNIOP_ReservedBy != 9999 && x.TLKNIOP_YarnOrder_FK != null).AsQueryable();
if (parameters.YarnTypes.Count != 0)
{
var YarnTypePredicate = PredicateBuilder.False <TLKNI_YarnOrderPallets>();
foreach (var YarnType in parameters.YarnTypes)
{
var temp = YarnType;
YarnTypePredicate = YarnTypePredicate.Or(s => s.TLKNIOP_YarnType_FK == temp.YA_Id);
}
}
if (parameters.YarnOrders.Count > 0)
{
var YarnPredicate = PredicateBuilder.False <TLKNI_YarnOrderPallets>();
foreach (var YarnOrder in parameters.YarnOrders)
{
var temp = YarnOrder;
YarnPredicate = YarnPredicate.Or(s => s.TLKNIOP_YarnOrder_FK == temp.YarnO_Pk);
}
YarnOP = YarnOP.AsExpandable().Where(YarnPredicate);
}
return(YarnOP);
}
private void Form_Load(object sender, EventArgs e)
{
formloaded = false;
using (var context = new TTI2Entities())
{
QueryParms = new KnitQueryParameters();
var Greiges = context.TLADM_Griege.OrderBy(x => x.TLGreige_Description).ToList();
foreach (var Greige in Greiges)
{
cmboProduct.Items.Add(new Knitting.CheckComboBoxItem(Greige.TLGreige_Id, Greige.TLGreige_Description, false));
}
var GradeOptions = new BindingList <KeyValuePair <int, string> >();
formloaded = false;
GradeOptions.Add(new KeyValuePair <int, string>(1, "A"));
GradeOptions.Add(new KeyValuePair <int, string>(2, "B"));
GradeOptions.Add(new KeyValuePair <int, string>(3, "C"));
cmboGrade.DataSource = GradeOptions;
cmboGrade.ValueMember = "Key";
cmboGrade.DisplayMember = "Value";
cmboGrade.SelectedIndex = -1;
chkBoughtInFabric.Checked = false;
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault();
if (Dept != null)
{
var Whses = context.TLADM_WhseStore.Where(x => !x.WhStore_WhseOrStore && x.WhStore_DepartmentFK == Dept.Dep_Id).OrderBy(x => x.WhStore_Description).ToList();
foreach (var Whse in Whses)
{
cmboStore.Items.Add(new Knitting.CheckComboBoxItem(Whse.WhStore_Id, Whse.WhStore_Description, false));
}
}
var StockTakeItems = context.TLADM_StockTakeFreq.OrderBy(x => x.STF_Description).ToList();
foreach (var Item in StockTakeItems)
{
cmboStockTake.Items.Add(new Knitting.CheckComboBoxItem(Item.STF_Pk, Item.STF_Description, false));
}
var QualityGroups = context.TLADM_GreigeQuality.OrderBy(x => x.GQ_Description).ToList();
foreach (var Quality in QualityGroups)
{
cmboProductGroup.Items.Add(new Knitting.CheckComboBoxItem(Quality.GQ_Pk, Quality.GQ_Description, false));
}
}
MandSelected = core.PopulateArray(MandatoryFields.Length, false);
formloaded = true;
}
public frmK07ReportSel()
{
InitializeComponent();
this.cmbGreigeProduct.CheckStateChanged += new System.EventHandler(this.cmboGreigeProduct_CheckStateChanged);
this.cmbKnittingCustomer.CheckStateChanged += new EventHandler(this.cmboKnittingCustomer_CheckStateChanged);
this.cmbYarnTypes.CheckStateChanged += new EventHandler(this.cmboYarnTypes_CheckStateChanged);
this.cmbMachines.CheckStateChanged += new System.EventHandler(this.cmboMachines_CheckStateChanged);
this.cmbOperator.CheckStateChanged += new EventHandler(this.cmboMachineOperators_CheckStateChanged);
QueryParms = new KnitQueryParameters();
repo = new Knitting.KnitRepository();
core = new Util();
}
private void frmYarnOrderAssigned_Load(object sender, EventArgs e)
{
FormLoaded = false;
QueryParms = new KnitQueryParameters();
using (var context = new TTI2Entities())
{
var YarnOrders = context.TLSPN_YarnOrder.OrderBy(x => x.YarnO_OrderNumber).ToList();
foreach (var YarnOrder in YarnOrders)
{
comboYarnOrders.Items.Add(new Knitting.CheckComboBoxItem(YarnOrder.YarnO_Pk, YarnOrder.YarnO_OrderNumber.ToString(), false));
}
}
FormLoaded = true;
}
public IQueryable <TLKNI_GreigeProduction> SOHGreigeProduction(KnitQueryParameters parameters)
{
IQueryable <TLKNI_GreigeProduction> GreigeProduction;
if (!parameters.BoughtInFabric)
{
GreigeProduction = _context.TLKNI_GreigeProduction.Where(x => x.GreigeP_Captured && !x.GreigeP_Dye && x.GreigeP_weightAvail > 0 && !x.GreigeP_BoughtIn).AsQueryable();
}
else
{
GreigeProduction = _context.TLKNI_GreigeProduction.Where(x => x.GreigeP_Captured && !x.GreigeP_Dye && x.GreigeP_weightAvail > 0 && x.GreigeP_BoughtIn).AsQueryable();
}
if (parameters.Grade.Length != 0)
{
var GradePredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
GreigeProduction = GreigeProduction.AsExpandable().Where(x => x.GreigeP_Grade.Contains(parameters.Grade.ToUpper()));
}
if (parameters.Greiges.Count > 0)
{
var GreigePredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Greige in parameters.Greiges)
{
var temp = Greige;
GreigePredicate = GreigePredicate.Or(s => s.GreigeP_Greige_Fk == temp.TLGreige_Id);
}
GreigeProduction = GreigeProduction.AsExpandable().Where(GreigePredicate);
}
if (parameters.WhseStores.Count > 0)
{
var WhsePredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var whse in parameters.WhseStores)
{
var temp = whse;
WhsePredicate = WhsePredicate.Or(s => s.GreigeP_Store_FK == temp.WhStore_Id);
}
GreigeProduction = GreigeProduction.AsExpandable().Where(WhsePredicate);
}
return(GreigeProduction);
}
public IQueryable <TLKNI_GreigeProduction> QAGreigeProduction(KnitQueryParameters parameters)
{
var GreigeProduction = _context.TLKNI_GreigeProduction.Where(x => x.GreigeP_InspDate >= parameters.FromDate && x.GreigeP_InspDate <= parameters.ToDate && x.GreigeP_Inspected && x.GreigeP_Captured && x.GreigeP_Machine_FK != null).AsQueryable();
if (parameters.Greiges.Count > 0)
{
var GreigePredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Greige in parameters.Greiges)
{
var temp = Greige;
GreigePredicate = GreigePredicate.Or(s => s.GreigeP_Greige_Fk == temp.TLGreige_Id);
}
GreigeProduction = GreigeProduction.AsExpandable().Where(GreigePredicate);
}
if (parameters.Operators.Count > 0)
{
var OperatorPredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Operator in parameters.Operators)
{
var temp = Operator;
OperatorPredicate = OperatorPredicate.Or(s => s.GreigeP_Operator_FK == temp.MachOp_Pk);
}
GreigeProduction = GreigeProduction.AsExpandable().Where(OperatorPredicate);
}
if (parameters.Machines.Count > 0)
{
var MachinePredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Machine in parameters.Machines)
{
var temp = Machine;
MachinePredicate = MachinePredicate.Or(s => s.GreigeP_Machine_FK == temp.MD_Pk);
}
GreigeProduction = GreigeProduction.AsExpandable().Where(MachinePredicate);
}
return(GreigeProduction);
}
private void frmViewOrders_Load(object sender, EventArgs e)
{
FormLoaded = false;
QueryParms = new KnitQueryParameters();
repo = new Knitting.KnitRepository();
core = new Util();
txtOrderNumber.Text = string.Empty;
using (var context = new TTI2Entities())
{
var Existing = context.TLADM_Griege.OrderBy(x => x.TLGreige_Description).ToList();
foreach (var Record in Existing)
{
cmboGreige.Items.Add(new Knitting.CheckComboBoxItem(Record.TLGreige_Id, Record.TLGreige_Description, false));
}
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "KNIT").FirstOrDefault();
if (Dept != null)
{
var Machines = context.TLADM_MachineDefinitions.Where(x => x.MD_Department_FK == Dept.Dep_Id).OrderBy(x => x.MD_MachineCode).ToList();
foreach (var Machine in Machines)
{
cmboMachines.Items.Add(new Knitting.CheckComboBoxItem(Machine.MD_Pk, Machine.MD_AlternateDesc, false));
}
}
}
oChkA = new DataGridViewCheckBoxColumn();
oChkA.HeaderText = "Select";
oChkA.ValueType = typeof(Boolean);
oChkA.Visible = true;
oTxtA = new DataGridViewTextBoxColumn(); // 0 Record Key
oTxtA.HeaderText = "Key";
oTxtA.ValueType = typeof(int);
oTxtA.Visible = false;
oTxtB = new DataGridViewTextBoxColumn(); // 1 Knit Order Number
oTxtB.HeaderText = "Knit Order";
oTxtB.ValueType = typeof(Int32);
oTxtB.Visible = true;
oTxtB.ReadOnly = true;
oTxtC = new DataGridViewTextBoxColumn(); // 2 Knit Order Quality
oTxtC.HeaderText = "Quality";
oTxtC.ValueType = typeof(String);
oTxtC.Visible = true;
oTxtC.ReadOnly = true;
oTxtD = new DataGridViewTextBoxColumn(); // 3 Knit Order Date
oTxtD.HeaderText = "Date Ordered";
oTxtD.ValueType = typeof(DateTime);
oTxtD.Visible = true;
oTxtD.ReadOnly = true;
oTxtE = new DataGridViewTextBoxColumn(); // 4 Knit Order Requested Date
oTxtE.HeaderText = "Date Required";
oTxtE.ValueType = typeof(DateTime);
oTxtE.Visible = true;
oTxtE.ReadOnly = true;
oTxtF = new DataGridViewTextBoxColumn(); // 5 Knitting Machine
oTxtF.HeaderText = "Knitting Machine";
oTxtF.ValueType = typeof(String);
oTxtF.Visible = true;
oTxtF.ReadOnly = true;
oTxtG = new DataGridViewTextBoxColumn(); // 6 Weight Required
oTxtG.HeaderText = "Weight Required";
oTxtG.ValueType = typeof(Decimal);
oTxtG.Visible = true;
oTxtG.ReadOnly = true;
dataGridView1.Columns.Add(oTxtA);
dataGridView1.Columns.Add(oChkA);
dataGridView1.Columns.Add(oTxtB);
dataGridView1.Columns.Add(oTxtC);
dataGridView1.Columns.Add(oTxtD);
dataGridView1.Columns.Add(oTxtE);
dataGridView1.Columns.Add(oTxtF);
dataGridView1.Columns.Add(oTxtG);
this.txtOrderNumber.KeyPress += core.txtWin_KeyPress;
this.txtOrderNumber.KeyDown += core.txtWin_KeyDownJI;
this.cmboGreige.CheckStateChanged += new System.EventHandler(this.cmboGreige_CheckStateChanged);
this.cmboMachines.CheckStateChanged += new EventHandler(this.cmboMachines_CheckStateChanged);
FormLoaded = true;
}
public IQueryable <TLKNI_GreigeProduction> GreigeProduction(KnitQueryParameters parameters)
{
IQueryable <TLKNI_GreigeProduction> GriegeProd;
var YarnOrders = _context.TLSPN_YarnOrder.AsQueryable();
var KnitOrders = _context.TLKNI_Order.AsQueryable();
GriegeProd = _context.TLKNI_GreigeProduction.Where(x => x.GreigeP_PDate >= parameters.FromDate && x.GreigeP_PDate <= parameters.ToDate && x.GreigeP_Captured).AsQueryable();
if (parameters.YarnTypes.Count != 0)
{
var YarnPredicate = PredicateBuilder.False <TLSPN_YarnOrder>();
foreach (var Yt in parameters.YarnTypes)
{
var temp = Yt;
YarnPredicate = YarnPredicate.Or(s => s.Yarno_YarnType_FK == temp.YA_Id);
}
YarnOrders = YarnOrders.AsExpandable().Where(YarnPredicate);
var KnitOrderPredicate = PredicateBuilder.False <TLKNI_Order>();
foreach (var YarnOrder in YarnOrders)
{
var temp = YarnOrder;
KnitOrderPredicate = KnitOrderPredicate.Or(s => s.KnitO_YarnO_FK == temp.YarnO_Pk);
}
KnitOrders = KnitOrders.AsExpandable().Where(KnitOrderPredicate);
var GPPredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Ko in KnitOrders)
{
var temp = Ko;
GPPredicate = GPPredicate.Or(s => s.GreigeP_KnitO_Fk == temp.KnitO_Pk);
}
GriegeProd = GriegeProd.AsExpandable().Where(GPPredicate);
}
if (parameters.Customers.Count != 0)
{
var CustomerPredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Customer in parameters.Customers)
{
var temp = Customer;
CustomerPredicate = CustomerPredicate.Or(s => s.GreigeP_CommissionCust_FK == temp.Cust_Pk);
}
GriegeProd = GriegeProd.AsExpandable().Where(CustomerPredicate);
}
if (parameters.Grade.Length != 0)
{
var GradePredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
GriegeProd = GriegeProd.AsExpandable().Where(x => x.GreigeP_Grade == parameters.Grade.ToUpper());
}
if (parameters.Greiges.Count != 0)
{
var GreigePredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Greige in parameters.Greiges)
{
var temp = Greige;
GreigePredicate = GreigePredicate.Or(s => s.GreigeP_Greige_Fk == temp.TLGreige_Id);
}
GriegeProd = GriegeProd.AsExpandable().Where(GreigePredicate);
}
if (parameters.Operators.Count != 0)
{
var OperatorPredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Operator in parameters.Operators)
{
var temp = Operator;
OperatorPredicate = OperatorPredicate.Or(s => s.GreigeP_Operator_FK == temp.MachOp_Pk);
}
GriegeProd = GriegeProd.AsExpandable().Where(OperatorPredicate);
}
if (parameters.Machines.Count != 0)
{
var MachinePredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Machine in parameters.Machines)
{
var temp = Machine;
MachinePredicate = MachinePredicate.Or(s => s.GreigeP_Machine_FK == temp.MD_Pk);
}
GriegeProd = GriegeProd.AsExpandable().Where(MachinePredicate);
}
return(GriegeProd);
}
public IQueryable <TLKNI_Order> KnitOrders(KnitQueryParameters parameters)
{
var KnitOrders = _context.TLKNI_Order.Where(x => !(bool)x.KnitO_Closed).AsQueryable();
var YarnOrders = _context.TLSPN_YarnOrder.AsQueryable();
//--------------------------------------------------------------
// Filter out any unwanted KnitOrders
//------------------------------------------------------------
if (parameters.YarnTypes.Count != 0)
{
var YarnPredicate = PredicateBuilder.False <TLSPN_YarnOrder>();
foreach (var Yt in parameters.YarnTypes)
{
var temp = Yt;
YarnPredicate = YarnPredicate.Or(s => s.Yarno_YarnType_FK == int.Parse(temp.ToString()));
}
YarnOrders = YarnOrders.AsExpandable().Where(YarnPredicate);
var KnitOrderPredicate = PredicateBuilder.False <TLKNI_Order>();
foreach (var YarnOrder in YarnOrders)
{
var temp = YarnOrder;
KnitOrderPredicate = KnitOrderPredicate.Or(s => s.KnitO_YarnO_FK == int.Parse(temp.ToString()));
}
KnitOrders = KnitOrders.AsExpandable().Where(KnitOrderPredicate);
}
if (parameters.KnitOrderPk.Count > 0)
{
var PkPredicate = PredicateBuilder.False <TLKNI_Order>();
foreach (var Pk in parameters.KnitOrderPk)
{
var temp = Pk;
PkPredicate = PkPredicate.Or(s => s.KnitO_Pk == int.Parse(temp.ToString()));
}
KnitOrders = KnitOrders.AsExpandable().Where(PkPredicate);
}
//--------------------------------------------------------------
// Filter out any Greiges
//------------------------------------------------------------
if (parameters.Greiges.Count > 0)
{
var GreigePredicate = PredicateBuilder.False <TLKNI_Order>();
foreach (var Greige in parameters.Greiges)
{
var temp = Greige;
GreigePredicate = GreigePredicate.Or(s => s.KnitO_Product_FK == temp.TLGreige_Id);
}
KnitOrders = KnitOrders.AsExpandable().Where(GreigePredicate);
}
//--------------------------------------------------------------
// Filter out any particular Customers if neccessary
//------------------------------------------------------------
if (parameters.Customers.Count > 0)
{
var CustomerPredicate = PredicateBuilder.False <TLKNI_Order>();
foreach (var Customer in parameters.Customers)
{
var temp = Customer;
CustomerPredicate = CustomerPredicate.Or(s => s.KnitO_Customer_FK == temp.Cust_Pk);
}
KnitOrders = KnitOrders.AsExpandable().Where(CustomerPredicate);
}
//----------------------------------------------------------------------
// Filter out any particular Machines if neccessary
//------------------------------------------------------------
if (parameters.Machines.Count > 0)
{
var MachinePredicate = PredicateBuilder.False <TLKNI_Order>();
foreach (var Machine in parameters.Machines)
{
var temp = Machine;
MachinePredicate = MachinePredicate.Or(s => s.KnitO_Machine_FK == temp.MD_Pk);
}
KnitOrders = KnitOrders.AsExpandable().Where(MachinePredicate);
}
return(KnitOrders);
}
public IQueryable <TLKNI_GreigeProduction> GKMeasurements(KnitQueryParameters parameters)
{
var GreigeProduction = _context.TLKNI_GreigeProduction.Where(x => x.GreigeP_Inspected && x.GreigeP_InspDate >= parameters.FromDate && x.GreigeP_InspDate <= parameters.ToDate && x.GreigeP_Captured).AsQueryable();
var YarnOrders = _context.TLSPN_YarnOrder.AsQueryable();
var KnitOrders = _context.TLKNI_Order.AsQueryable();
if (parameters.YarnTypes.Count != 0)
{
var YarnPredicate = PredicateBuilder.False <TLSPN_YarnOrder>();
foreach (var Yt in parameters.YarnTypes)
{
var temp = Yt;
YarnPredicate = YarnPredicate.Or(s => s.Yarno_YarnType_FK == int.Parse(temp.ToString()));
}
YarnOrders = YarnOrders.AsExpandable().Where(YarnPredicate);
var KnitOrderPredicate = PredicateBuilder.False <TLKNI_Order>();
foreach (var YarnOrder in YarnOrders)
{
var temp = YarnOrder;
KnitOrderPredicate = KnitOrderPredicate.Or(s => s.KnitO_YarnO_FK == int.Parse(temp.ToString()));
}
KnitOrders = KnitOrders.AsExpandable().Where(KnitOrderPredicate);
var GPPredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Ko in KnitOrders)
{
var temp = Ko;
GPPredicate = GPPredicate.Or(s => s.GreigeP_KnitO_Fk == temp.KnitO_Pk);
}
GreigeProduction = GreigeProduction.AsExpandable().Where(GPPredicate);
}
if (parameters.Greiges.Count > 0)
{
var GreigePredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Greige in parameters.Greiges)
{
var temp = Greige;
GreigePredicate = GreigePredicate.Or(s => s.GreigeP_Greige_Fk == temp.TLGreige_Id);
}
GreigeProduction = GreigeProduction.AsExpandable().Where(GreigePredicate);
}
if (parameters.Operators.Count > 0)
{
var OperatorPredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Operator in parameters.Operators)
{
var temp = Operator;
OperatorPredicate = OperatorPredicate.Or(s => s.GreigeP_Operator_FK == temp.MachOp_Pk);
}
GreigeProduction = GreigeProduction.AsExpandable().Where(OperatorPredicate);
}
if (parameters.Machines.Count > 0)
{
var MachinePredicate = PredicateBuilder.False <TLKNI_GreigeProduction>();
foreach (var Machine in parameters.Machines)
{
var temp = Machine;
MachinePredicate = MachinePredicate.Or(s => s.GreigeP_Machine_FK == temp.MD_Pk);
}
GreigeProduction = GreigeProduction.AsExpandable().Where(MachinePredicate);
}
return(GreigeProduction);
}
