private void frmSelSalesByPeriod_Load(object sender, EventArgs e)
{
FormLoaded = false;
QueryParms = new CustomerServicesParameters();
using (var context = new TTI2Entities())
{
var Styles = context.TLADM_Styles.Where(x => !(bool)x.Sty_Discontinued).OrderBy(x => x.Sty_Description).ToList();
foreach (var Style in Styles)
{
cmboStyles.Items.Add(new CustomerServices.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
}
// cmboStyles.ValueMember = "Sty_Id";
// cmboStyles.DisplayMember = "Sty_Description";
var Customers = context.TLADM_CustomerFile.OrderBy(x => x.Cust_Description).ToList();
foreach (var Customer in Customers)
{
this.cmboCustomers.Items.Add(new CustomerServices.CheckComboBoxItem(Customer.Cust_Pk, Customer.Cust_Description, false));
}
// cmboCustomers.DisplayMember = "Cust_Description";
// cmboCustomers.ValueMember = "Cust_PK";
}
FormLoaded = true;
}
public frmPurchaseOrderConfig(int PurchaseOrder)
{
InitializeComponent();
_PurchaseKey = PurchaseOrder;
dt = new DataTable();
core = new Util();
repo = new Repository();
QueryParms = new CustomerServicesParameters();
txtPONumber.KeyPress += core.txtWin_KeyPress;
txtPONumber.KeyDown += core.txtWin_KeyDownJI;
}
private void frmBoxesDespatchedNoReceipted_Load(object sender, EventArgs e)
{
FormLoaded = false;
parms = new CustomerServicesParameters();
using (var context = new TTI2Entities())
{
var Whses = context.TLADM_WhseStore.Where(x => x.WhStore_WhseOrStore).OrderBy(x => x.WhStore_Description).ToList();
foreach (var Whse in Whses)
{
cmboWarehouses.Items.Add(new CustomerServices.CheckComboBoxItem(Whse.WhStore_Id, Whse.WhStore_Description, false));
}
}
FormLoaded = true;
}
private void frmPastelRecon_Load(object sender, EventArgs e)
{
FormLoaded = false;
QueryParms = new CustomerServices.CustomerServicesParameters();
using (var context = new TTI2Entities())
{
var Styles = context.TLADM_Styles.Where(x => !(bool)x.Sty_Discontinued).OrderBy(x => x.Sty_Description).ToList();
foreach (var Style in Styles)
{
cmboStyles.Items.Add(new CustomerServices.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
}
}
FormLoaded = true;
}
private void btnSubmit_Click(object sender, EventArgs e)
{
Button oBtn = (Button)sender;
if (oBtn != null && FormLoaded)
{
var SingleRow = (from Rows in dataGridView1.Rows.Cast <DataGridViewRow>()
where (bool)Rows.Cells[1].Value == true
select Rows).FirstOrDefault();
if (SingleRow == null)
{
MessageBox.Show("Please select at least one row to process");
return;
}
foreach (DataGridViewRow Row in dataGridView1.Rows)
{
if (!(bool)Row.Cells[1].Value)
{
continue;
}
QueryParms.OrdersAllocated.Add(Repo.LoadOrderAllocated((int)Row.Cells[0].Value));
}
var services = new CSVServices();
frmCSViewRep vRep = new frmCSViewRep(24, QueryParms, services);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
QueryParms = new CustomerServicesParameters();
foreach (DataGridViewRow Row in dataGridView1.Rows)
{
if (!(bool)Row.Cells[1].Value)
{
continue;
}
Row.Cells[1].Value = false;
}
}
}
private void frmCustomerTransHistory_Load(object sender, EventArgs e)
{
FormLoaded = false;
using (var context = new TTI2Entities())
{
cmboCustomers.DataSource = context.TLADM_CustomerFile.Where(x => !x.Cust_Blocked).OrderBy(x => x.Cust_Description).ToList();
cmboCustomers.ValueMember = "Cust_Pk";
cmboCustomers.DisplayMember = "Cust_Description";
cmboCustomers.SelectedValue = -1;
}
this.cmboPurchaseOrders.Items.Clear();
QueryParms = new CustomerServicesParameters();
FormLoaded = true;
}
private void frmRepackCenterStatus_Load(object sender, EventArgs e)
{
FormLoaded = false;
QueryParms = new CustomerServicesParameters();
IList <TLCSV_RePackConfig> RePack = new List <TLCSV_RePackConfig>();
using (var context = new TTI2Entities())
{
var ConFigs = context.TLCSV_RePackConfig.GroupBy(x => x.PORConfig_BoxNumber_Key);
foreach (var ConFig in ConFigs)
{
var ConFigPk = ConFig.FirstOrDefault().PORConfig_BoxNumber_Key;
var ConFigDesc = ConFig.FirstOrDefault().PORConfig_BoxNumber_Key.ToString();
cmboRepackConfig.Items.Add(new CustomerServices.CheckComboBoxItem(ConFigPk, ConFigDesc, false));
}
}
FormLoaded = true;
}
private void frmDaysSales_Load(object sender, EventArgs e)
{
FormLoaded = false;
QueryParms = new CustomerServicesParameters();
using (var context = new TTI2Entities())
{
var Styles = context.TLADM_Styles.Where(x => (bool)!x.Sty_Discontinued).OrderBy(x => x.Sty_Description).ToList();
foreach (var Style in Styles)
{
cmboStyles.Items.Add(new CustomerServices.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
}
var Colours = context.TLADM_Colours.Where(x => (bool)!x.Col_Discontinued).OrderBy(x => x.Col_Display).ToList();
foreach (var Colour in Colours)
{
cmboColours.Items.Add(new CustomerServices.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
}
}
FormLoaded = true;
}
private void frmCrossBorderDoc_Load(object sender, EventArgs e)
{
FormLoaded = false;
dataGridView1.Rows.Clear();
using (var context = new TTI2Entities())
{
var OrderAllocated = context.TLCSV_OrderAllocated.Where(x => !x.TLORDA_Delivered).OrderBy(x => x.TLORDA_TransNumber).ToList();
foreach (var Order in OrderAllocated)
{
var index = dataGridView1.Rows.Add();
dataGridView1.Rows[index].Cells[0].Value = (int)Order.TLORDA_Pk;
dataGridView1.Rows[index].Cells[1].Value = false;
dataGridView1.Rows[index].Cells[2].Value = context.TLCSV_PurchaseOrder.Find(Order.TLORDA_POOrder_FK).TLCSVPO_PurchaseOrder;
dataGridView1.Rows[index].Cells[3].Value = "PL" + Order.TLORDA_TransNumber.ToString().PadLeft(5, '0');
dataGridView1.Rows[index].Cells[4].Value = Convert.ToDateTime(Order.TLORDA_TransDate.ToShortDateString());
}
}
QueryParms = new CustomerServicesParameters();
FormLoaded = true;
}
private void frmWareHouseTransfers_Load(object sender, EventArgs e)
{
formloaded = false;
Submit = true;
core = new Util();
using (var context = new TTI2Entities())
{
QueryParms = new CustomerServicesParameters();
cmboFrom.DataSource = context.TLADM_Departments.Where(x => x.Dep_IsCMT).ToList();
cmboFrom.ValueMember = "Dep_Id";
cmboFrom.DisplayMember = "Dep_Description";
cmboFrom.SelectedValue = -1;
cmboTo.DataSource = context.TLADM_WhseStore.Where(x => x.WhStore_WhseOrStore).ToList();
cmboTo.ValueMember = "WhStore_Id";
cmboTo.DisplayMember = "WhStore_Description";
cmboTo.SelectedValue = -1;
var Styles = context.TLADM_Styles.OrderBy(x => x.Sty_Description).ToList();
foreach (var Style in Styles)
{
cmboStyles.Items.Add(new CustomerServices.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false));
}
var Colours = context.TLADM_Colours.Where(x => !(bool)x.Col_Discontinued).OrderBy(x => x.Col_Display).ToList();
foreach (var Colour in Colours)
{
cmboColours.Items.Add(new CustomerServices.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false));
}
var Sizes = context.TLADM_Sizes.Where(x => !(bool)x.SI_Discontinued).OrderBy(x => x.SI_DisplayOrder).ToList();
foreach (var Size in Sizes)
{
cmboSizes.Items.Add(new CustomerServices.CheckComboBoxItem(Size.SI_id, Size.SI_Description, false));
}
DGVResults.Visible = false;
oTxtA = new DataGridViewTextBoxColumn();
oTxtA.Visible = false;
oTxtA.ValueType = typeof(int);
oTxtA.ReadOnly = true;
DGVResults.Columns.Add(oTxtA);
oChkA = new DataGridViewCheckBoxColumn();
oChkA.Visible = true;
oChkA.ValueType = typeof(Boolean);
oChkA.HeaderText = "Select";
DGVResults.Columns.Add(oChkA);
oTxtB = new DataGridViewTextBoxColumn();
oTxtB.Visible = true;
oTxtB.HeaderText = "Box Detail";
oTxtB.ReadOnly = true;
oTxtB.ValueType = typeof(string);
DGVResults.Columns.Add(oTxtB);
oTxtC = new DataGridViewTextBoxColumn();
oTxtC.Visible = true;
oTxtC.HeaderText = "Box Qty";
oTxtC.ReadOnly = true;
oTxtC.ValueType = typeof(int);
DGVResults.Columns.Add(oTxtC);
oTxtD = new DataGridViewTextBoxColumn();
oTxtD.Visible = true;
oTxtD.HeaderText = "Box Weight";
oTxtD.ReadOnly = true;
oTxtD.ValueType = typeof(decimal);
DGVResults.Columns.Add(oTxtD);
oTxtE = new DataGridViewTextBoxColumn();
oTxtE.Visible = true;
oTxtE.HeaderText = "Customer";
oTxtE.ReadOnly = true;
oTxtE.ValueType = typeof(string);
DGVResults.Columns.Add(oTxtE);
oTxtF = new DataGridViewTextBoxColumn();
oTxtF.Visible = true;
oTxtF.HeaderText = "Style";
oTxtF.ReadOnly = true;
oTxtF.ValueType = typeof(string);
DGVResults.Columns.Add(oTxtF);
oTxtG = new DataGridViewTextBoxColumn();
oTxtG.Visible = true;
oTxtG.HeaderText = "Colour";
oTxtG.ReadOnly = true;
oTxtG.ValueType = typeof(string);
DGVResults.Columns.Add(oTxtG);
oTxtH = new DataGridViewTextBoxColumn();
oTxtH.Visible = true;
oTxtH.HeaderText = "Size";
oTxtH.ReadOnly = true;
oTxtH.ValueType = typeof(string);
DGVResults.Columns.Add(oTxtH);
DGVResults.AutoGenerateColumns = false;
DGVResults.AllowUserToAddRows = false;
formloaded = true;
}
}
