private void frmViewTeacher_Load(object sender, System.EventArgs e)
{
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView("SELECT r.ID, r.Rep_ID, rs.Name, User FROM user r Left Join Reps rs On rs.ID=r.Rep_ID Order By User,rs.Name", "Rep");
//cboTraineeFields.Items.Insert(0, "Teacher");
//cboTraineeFields.Items.Insert(1, "Students");
//cboTraineeFields.SelectedIndex = 0;
//
DataGridTableStyle TbStyle = new DataGridTableStyle();
TbStyle.MappingName = "Rep";
TbStyle.RowHeadersVisible = false;
TbStyle.GridLineColor = System.Drawing.Color.Black;
TbStyle.AllowSorting = false;
TbStyle.AlternatingBackColor = System.Drawing.Color.AliceBlue;
DataGridTextBoxColumn Col_00 = new DataGridTextBoxColumn();
Col_00.HeaderText = "Rep ID";
Col_00.MappingName = "ID";
Col_00.Width = 80;
Col_00.NullText = "";
Col_00.ReadOnly = true;
DataGridTextBoxColumn Col_01 = new DataGridTextBoxColumn();
Col_01.HeaderText = "User";
Col_01.MappingName = "User";
Col_01.Width = 80;
Col_01.NullText = "";
Col_01.ReadOnly = true;
DataGridTextBoxColumn Col_02 = new DataGridTextBoxColumn();
Col_02.HeaderText = "Name";
Col_02.MappingName = "Name";
Col_02.Width = 200;
Col_02.NullText = "";
Col_02.ReadOnly = true;
TbStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { Col_00, Col_01, Col_02 });
DataGrid.TableStyles.Add(TbStyle);
DataGrid.DataSource = dt;
//DataGrid.Focus();
//oMySql.Close();
GroupBox1.Focus();
txtSearch.Focus();
}
private void txtCustomerID_KeyUp(object sender, System.Windows.Forms.KeyEventArgs e)
{
#region txtOrderID
if (sender == txtOrderID)
{
if (e.KeyCode.ToString() == "Return" || e.KeyCode.ToString() == "Tab")
{
if (txtOrderID.Text.Trim() == "")
{
txtOrderID.Clear();
txtOrderID.Focus();
return;
}
Int32 OrderID;
try
{
OrderID = Convert.ToInt32(txtOrderID.Text);
}
catch (Exception ex)
{
Global.ShowNotifier(ex.Message);
Global.playSimpleSound(3);
txtOrderID.Clear();
txtOrderID.Focus();
return;
}
if (oImprinting.Find(OrderID, Global.CurrrentLine))
{
if (oImprinting.ImprintItems.Count == 0)
{
Global.ShowNotifier("This order does exist but has no items with this product type: " + Global.CurrrentLine);
txtOrderID.Clear();
txtOrderID.Focus();
return;
}
if (CompanyID != oImprinting.CompanyID)
{
Global.ShowNotifier("Different Order's Company/Season");
txtOrderID.Clear();
txtOrderID.Focus();
return;
}
txtTeacher.Text = oImprinting.Teacher;
txtStudent.Text = oImprinting.Student;
if (oImprinting.Imprinted)
{
Global.ShowNotifier("Order already printed");
//return;
}
this.ShowOrder();
txtOrderID.Enabled = false;
//txtBoxes.Enabled = false;
txtProductID.BackColor = Color.White;
txtProductID.Focus();
return;
}
else
{
MessageBox.Show("Order not found...");
txtOrderID.Clear();
txtOrderID.Focus();
return;
}
}
}
#endregion
#region txtProductID
if (sender == txtProductID)
{
if (e.KeyCode.ToString() == "F8")
{
this.Grid.Focus();
}
if (e.KeyCode.ToString() == "F2")
{
if (oImprinting.oProduct.View())
{
this.txtProductID.Text = oImprinting.oProduct.ID;
return;
}
}
if (e.KeyCode == Keys.Return || e.KeyCode == Keys.Tab)
{
txtDescription.Clear();
if (txtProductID.Text.ToUpper() == "DONE")
{
if (!oImprinting.IfDone())
{
Global.playSimpleSound(1);
txtDescription.Text = "You have products left";
Global.ShowNotifier(txtDescription.Text);
ActiveLeft();
txtProductID.Clear();
txtProductID.Focus();
return;
}
oImprinting.UpdateImprinted(true, Global.CurrrentLine);
Clear();
txtOrderID.Enabled = true;
txtOrderID.Focus();
return;
}
if (txtProductID.Text.ToUpper() == "ABORT")
{
Clear();
groupBox2.Focus();
txtOrderID.Enabled = true;
txtOrderID.Focus();
return;
}
Imprinting.ImprintItem oItem = oImprinting.GetItem(txtProductID.Text);
if (oItem == null)
{
oItem = oImprinting.GetItemTicket(txtProductID.Text);
}
if (oItem == null)
{
Global.playSimpleSound(2);
txtDescription.Text = "TICKET OR PRODUCT NOT IN ORDER";
Global.ShowNotifier(txtDescription.Text);
this.txtProductID.Clear();
this.txtProductID.Focus();
return;
}
txtProductID.Text = oItem.TicketID.ToString();
if (oItem.Printed)
{
Global.playSimpleSound(2);
txtDescription.Text = "TICKET ALREADY PRINTED";
Global.ShowNotifier(txtDescription.Text);
/*if (MessageBox.Show("Do you want reprint this Ticket?", "Re-print", MessageBoxButtons.YesNo, MessageBoxIcon.Warning,MessageBoxDefaultButton.Button2) == DialogResult.Yes)
* {
* oTicket.Find(Convert.ToInt32(txtProductID.Text));
* frmTicket frm = new frmTicket(oTicket);
* frm.Show();
* if (!frm.Print())
* {
* Global.ShowNotifier("No Printed");
* frm.Dispose();
* return;
* }
* frm.Dispose();
* oImprinting.ImprintItems[txtProductID.Text].Printed = true;
* }
* else*/
{
this.txtProductID.Clear();
this.txtProductID.Focus();
return;
}
}
else
{
oTicket.Find(Convert.ToInt32(txtProductID.Text));
frmTicket frm = new frmTicket(oTicket);
frm.Show();
if (!frm.Print())
{
Global.ShowNotifier("No Printed");
frm.Dispose();
return;
}
frm.Dispose();
oImprinting.ImprintItems[txtProductID.Text].Printed = true;
}
if (oImprinting.ImprintItems.Contains(txtProductID.Text))
{
this.txtDescription.Text = oImprinting.ImprintItems[txtProductID.Text].Description;
if (oImprinting.ImprintItems[txtProductID.Text].Printed)
{
this.ActiveRow(true);
}
else
{
this.ActiveRow(false);
}
// Grid.DataBind();
this.txtProductID.Clear();
return;
}
}
}
#endregion
#region txtGrid
if (sender == this.Grid)
{
//MessageBox.Show(e.KeyData.ToString());
if (Char.IsDigit(Convert.ToChar(e.KeyValue)))
{
txtProductID.Focus();
txtProductID.Text += Convert.ToChar(e.KeyValue).ToString();
SendKeys.Send("{END}");
return;
}
if (e.KeyCode.ToString() == "F8")
{
this.txtProductID.Focus();
return;
}
if (e.KeyCode == Keys.Enter || e.KeyCode == Keys.Up || e.KeyCode == Keys.Down || e.KeyCode == Keys.PageDown)
{
//return;
}
}
#endregion
#region Default Option
//Default option
switch (e.KeyCode)
{
case Keys.Tab:
if (!e.Shift)
{
this.SelectNextControl(this.ActiveControl, true, true, true, true);
}
break;
case Keys.Enter:
this.SelectNextControl(this.ActiveControl, true, true, true, true);
break;
case Keys.Down:
this.SelectNextControl(this.ActiveControl, true, true, true, true);
break;
case Keys.Up:
this.SelectNextControl(this.ActiveControl, false, true, true, true);
break;
case Keys.F8:
this.Grid.Focus();
break;
case Keys.F3:
break;
case Keys.PageDown:
break;
//case Keys.<some key>:
// ......;
// break;
}
#endregion
}
private void txtCustomerID_KeyUp(object sender, System.Windows.Forms.KeyEventArgs e)
{
#region txtOrderID
if (sender == txtOrderID)
{
if (e.KeyCode.ToString() == "Return" || e.KeyCode.ToString() == "Tab")
{
if (txtOrderID.Text.Trim() == "")
{
txtOrderID.Clear();
txtOrderID.Focus();
return;
}
int split = txtOrderID.Text.IndexOf('.');
if (split > -1)
{
txtOrderID.Text = txtOrderID.Text.Substring(0, split).Trim();
}
Int32 OrderID;
try
{
OrderID = Convert.ToInt32(txtOrderID.Text);
}
catch (Exception ex)
{
Global.ShowNotifier(ex.Message);
Global.playSimpleSound(3);
txtOrderID.Clear();
txtOrderID.Focus();
return;
}
if (oPacking.Find(OrderID, Global.CurrrentLine))
{
if (oPacking.ScanItems.Count == 0)
{
MessageBox.Show("This order does exist but has no items with this product type: " + Global.CurrrentLine);
txtOrderID.Clear();
txtOrderID.Focus();
return;
}
if (CompanyID != oPacking.CompanyID)
{
MessageBox.Show("Different Order's Company/Season");
txtOrderID.Clear();
txtOrderID.Focus();
return;
}
txtTeacher.Text = oPacking.Teacher;
txtStudent.Text = oPacking.Student;
Order.PackByOrder oOB = new Order.PackByOrder();
if (oOB.Find(Convert.ToInt32(txtOrderID.Text), Global.CurrrentLine))
{
if (oOB.Packed) // (oPacking.Packed)
{
MessageBox.Show("Order already packed by " + oOB.Packer + " " + oOB.BoxesPacked.ToString() + " boxes");
txtBoxes.Enabled = true;
txtBoxes.Text = oOB.BoxesPacked.ToString();
txtBoxes.Focus();
return;
}
}
/*
* if (oPacking.Packed)
* {
* MessageBox.Show("Order already packed by " + oPacking.Packer + " " + oPacking.BoxesPacked.ToString()+" boxes");
* txtBoxes.Enabled = true;
* txtBoxes.Text = oPacking.BoxesPacked.ToString();
* txtBoxes.Focus();
*
* return;
* }
*/
this.ShowOrder();
txtOrderID.Enabled = false;
txtBoxes.Enabled = false;
txtProductID.BackColor = Color.White;
txtProductID.Focus();
return;
}
else
{
MessageBox.Show("Order not found...");
txtOrderID.Clear();
txtOrderID.Focus();
return;
}
}
}
#endregion
#region txtProductID
if (sender == txtProductID)
{
if (e.KeyCode.ToString() == "F8")
{
this.Grid.Focus();
}
if (e.KeyCode.ToString() == "F2")
{
if (oPacking.oProduct.View())
{
this.txtProductID.Text = oPacking.oProduct.ID;
return;
}
}
if (e.KeyCode == Keys.Return || e.KeyCode == Keys.Tab)
{
txtDescription.Clear();
if (txtProductID.Text.ToUpper() == "DONE")
{
if (!oPacking.IfDone())
{
Global.playSimpleSound(1);
txtDescription.Text = "You have products left";
ActiveLeft();
txtProductID.Clear();
txtProductID.Focus();
return;
}
txtBoxes.Clear();
txtBoxes.Enabled = true;
txtBoxes.Focus();
//txtOrderID.Enabled = true;
return;
}
if (txtProductID.Text.ToUpper() == "ABORT")
{
Clear();
groupBox2.Focus();
txtOrderID.Enabled = true;
txtOrderID.Focus();
return;
}
BarCode_2:
if (txtProductID.Text.Length < 12)
{
if (!oPacking.ScanItems.Contains(txtProductID.Text))
{
txtProductID.Text = oPacking.GetItem(txtProductID.Text);
if (txtProductID.Text == "")
{
Global.playSimpleSound(2);
txtDescription.Text = "PRODUCT NOT IN ORDER";
this.txtProductID.Clear();
this.txtProductID.Focus();
return;
}
}
}
//Check by Code
if (oPacking.ScanItems.Contains(txtProductID.Text))
{
if (oPacking.ScanItems[txtProductID.Text].Quantity < (oPacking.ScanItems[txtProductID.Text].Scanned + 1))
{
Global.playSimpleSound(3);
txtDescription.Text = "EXTRA PRODUCT !!!";
txtProductID.Clear();
return;
}
oPacking.ScanItems[txtProductID.Text].Scanned += 1;
//if (oPacking.ScanItems[txtProductID.Text].Scanned == oPacking.ScanItems[txtProductID.Text].Quantity)
// DeleteRow();
this.txtDescription.Text = oPacking.ScanItems[txtProductID.Text].Description;
//this.ScannedItems.Text = oPacking.ScanItems[txtProductID.Text].ProductID + " - " + oPacking.ScanItems[txtProductID.Text].Description;
//this.ScannedItems.Items.Add(oPacking.ScanItems[txtProductID.Text].ProductID + " - " + oPacking.ScanItems[txtProductID.Text].Description);
if (oPacking.ScanItems[txtProductID.Text].Scanned == oPacking.ScanItems[txtProductID.Text].Quantity)
{
//oPacking.ScanItems[txtProductID.Text].Packed = "";
this.ActiveRow(true);
}
else
{
this.ActiveRow(false);
}
// Grid.DataBind();
this.txtProductID.Clear();
//this.txtDescription.Text = ""; //
return;
}
else
{
String Barcode2 = oPacking.GetSecondaryBarcode(txtProductID.Text);
if (Barcode2 != "")
{
txtProductID.Text = Barcode2;
goto BarCode_2;
}
Global.playSimpleSound(5);
txtDescription.Text = "PRODUCT NOT IN ORDER";
this.txtProductID.Clear();
this.txtProductID.Focus();
return;
}
}
}
#endregion
#region txtBoxes
if (sender == txtBoxes)
{
if (e.KeyCode == Keys.Return || e.KeyCode == Keys.Tab)
{
if (txtBoxes.Text == "")
{
txtBoxes.Focus();
return;
}
if (txtBoxes.Text.ToUpper() == "DONE" || txtBoxes.Text.ToUpper() == "ONE")
{
txtBoxes.Text = "1";
}
try
{
oPacking.BoxesPacked = Convert.ToInt16(txtBoxes.Text);
//oPacking.Lines[Global.CurrrentLine].BoxesPacked = Convert.ToInt16(txtBoxes.Text);
}
catch
{
txtBoxes.Text = "";
txtBoxes.Focus();
return;
}
oPacking.UpdatePacked(true, Global.CurrrentLine);
PrintTitle();
Clear();
txtBoxes.Enabled = false;
txtOrderID.Enabled = true;
txtOrderID.Focus();
return;
}
}
#endregion
#region txtGrid
if (sender == this.Grid)
{
//MessageBox.Show(e.KeyData.ToString());
if (Char.IsDigit(Convert.ToChar(e.KeyValue)))
{
txtProductID.Focus();
txtProductID.Text += Convert.ToChar(e.KeyValue).ToString();
SendKeys.Send("{END}");
return;
}
if (e.KeyCode.ToString() == "F8")
{
this.txtProductID.Focus();
return;
}
if (e.KeyCode == Keys.Enter || e.KeyCode == Keys.Up || e.KeyCode == Keys.Down || e.KeyCode == Keys.PageDown)
{
//return;
}
}
#endregion
#region Default Option
//Default option
switch (e.KeyCode)
{
case Keys.Tab:
if (!e.Shift)
{
this.SelectNextControl(this.ActiveControl, true, true, true, true);
}
break;
case Keys.Enter:
this.SelectNextControl(this.ActiveControl, true, true, true, true);
break;
case Keys.Down:
this.SelectNextControl(this.ActiveControl, true, true, true, true);
break;
case Keys.Up:
this.SelectNextControl(this.ActiveControl, false, true, true, true);
break;
case Keys.F8:
this.Grid.Focus();
break;
case Keys.F3:
break;
case Keys.PageDown:
break;
//case Keys.<some key>:
// ......;
// break;
}
#endregion
}
