private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView("SELECT PrizeID, Description, Prize_Break, Levels from Prizes Where CompanyID='" + sCompanyID + "'", "Prize");
DataGridTableStyle TbStyle = new DataGridTableStyle();
TbStyle.MappingName = "Prize";
TbStyle.RowHeadersVisible = false;
TbStyle.GridLineColor = System.Drawing.Color.Black;
TbStyle.AllowSorting = false;
TbStyle.AlternatingBackColor = System.Drawing.Color.AliceBlue;
DataGridTextBoxColumn Col_01 = new DataGridTextBoxColumn();
Col_01.HeaderText = "Prize ID";
Col_01.MappingName = "PrizeID";
Col_01.Width = 60;
Col_01.NullText = "";
Col_01.ReadOnly = true;
Col_01.Alignment = System.Windows.Forms.HorizontalAlignment.Center;
DataGridTextBoxColumn Col_02 = new DataGridTextBoxColumn();
Col_02.HeaderText = "Description";
Col_02.MappingName = "Description";
Col_02.Width = 70;
Col_02.NullText = "";
Col_02.ReadOnly = true;
DataGridTextBoxColumn Col_03 = new DataGridTextBoxColumn();
Col_03.HeaderText = "PrizeBreak";
Col_03.MappingName = "PrizeBreak";
Col_03.Width = 70;
Col_03.NullText = "";
Col_03.ReadOnly = true;
DataGridTextBoxColumn Col_04 = new DataGridTextBoxColumn();
Col_03.HeaderText = "Levels";
Col_03.MappingName = "Leves";
Col_03.Width = 70;
Col_03.NullText = "";
Col_03.ReadOnly = true;
TbStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { Col_01, Col_02, Col_03, Col_04 });
DataGrid.TableStyles.Add(TbStyle);
DataGrid.DataSource = dt;
//DataGrid.Focus();
this.txtSearch.Focus();
//oMySql.Close();
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView("SELECT CustomerID, Name, City, State from Customer Where CompanyID='" + sCompanyID + "'", "Customer");
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView(String.Format("Select r.Reference, ReceiveID, r.Date, r.PurchaseID, v.Name from Receive r Left join Purchase p on r.PurchaseID=p.PurchaseID And r.CompanyID=p.CompanyID Left join Vendor v on p.VendorID=v.VendorID And p.CompanyID=v.CompanyID Where p.CompanyID='{0}' Order By r.Date DESC ", sCompanyID), "Tmp");
//dt = oMySql.GetDataView(String.Format("CALL get_pending_PO('{0})", sCompanyID), "Tmp");
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView(String.Format("SELECT * FROM CardTemplate"), "CardTemplate");
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + CompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView(String.Format("Select distinct(os.CustomerID), c.Name from OrderScanned os Left Join Customer c on os.CompanyID=c.CompanyID And os.CustomerID=c.CustomerID Where os.CompanyID='" + this.CompanyID + "'", "OrderScanned"), "Customers");
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
contextMenu1 = new System.Windows.Forms.ContextMenu();
System.Windows.Forms.MenuItem menuItem1;
menuItem1 = new System.Windows.Forms.MenuItem();
System.Windows.Forms.MenuItem menuItem2;
menuItem2 = new System.Windows.Forms.MenuItem();
System.Windows.Forms.MenuItem menuItem3;
menuItem3 = new System.Windows.Forms.MenuItem();
contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] { menuItem1, menuItem2, menuItem3 });
menuItem1.Index = 0;
menuItem1.Text = "View";
menuItem2.Index = 1;
menuItem2.Text = "Modify";
menuItem3.Index = 2;
menuItem3.Text = "Delete";
menuItem1.Click += new EventHandler(this.menuitem1_Click);
//textBox1.ContextMenu = contextMenu1;
//txtSearch.ContextMenu = contextMenu1;
Grid.ContextMenu = contextMenu1;
//
Signature.Data.MySQL oMySql = Global.oMySql;
if (this.All)
{
dt = oMySql.GetDataView("SELECT CompanyID, Name FROM Company Order By CompanyID", "Company");
}
else
{
dt = oMySql.GetDataView("SELECT CompanyID, Name FROM Company where IsExternal='0' Order By CompanyID", "Company");
}
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
contextMenu1 = new System.Windows.Forms.ContextMenu();
System.Windows.Forms.MenuItem menuItem1;
menuItem1 = new System.Windows.Forms.MenuItem();
System.Windows.Forms.MenuItem menuItem2;
menuItem2 = new System.Windows.Forms.MenuItem();
System.Windows.Forms.MenuItem menuItem3;
menuItem3 = new System.Windows.Forms.MenuItem();
contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] { menuItem1, menuItem2, menuItem3 });
menuItem1.Index = 0;
menuItem1.Text = "View";
menuItem2.Index = 1;
menuItem2.Text = "Modify";
menuItem3.Index = 2;
menuItem3.Text = "Delete";
menuItem1.Click += new EventHandler(this.menuitem1_Click);
//textBox1.ContextMenu = contextMenu1;
//txtSearch.ContextMenu = contextMenu1;
Grid.ContextMenu = contextMenu1;
//
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView(String.Format("SELECT user, RepID FROM mailserver.virtual_users Where domain_id='{0}'", this.DomainID), "Domains");
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmViewTeacher_Load(object sender, System.EventArgs e)
{
Signature.Data.MySQL oMySql = Global.oMySql;
//dt = oMySql.GetDataView("SELECT ID, Teacher, Student, Scanned, Packed FROM Orders Where CompanyID='"+sCompanyID+ "' And CustomerID='"+sCustomerID+"' And (BoxesPacked!=0 And BoxesPacked!=BoxesScanned)","Tmp");
dt = oMySql.GetDataView(String.Format("SELECT o.ID, o.Teacher,o.Student,ol.Scanned, ol.Packed FROM Orders o Left Join OrderByLine ol On o.ID=ol.OrderID Where o.CompanyID='{0}' And CustomerID='{1}' And ol.PackID='{2}' And (ol.Packed<>'1' Or ol.Scanned <>'1') And o.Teacher NOT Like '%A INTERNET%'", Global.CurrrentCompany, this.sCustomerID, Global.CurrrentLine), "Tmp");
//cboTraineeFields.Items.Insert(0, "Teacher");
//cboTraineeFields.Items.Insert(1, "Students");
//cboTraineeFields.SelectedIndex = 0;
//
DataGridTableStyle TbStyle = new DataGridTableStyle();
TbStyle.MappingName = "Tmp";
TbStyle.RowHeadersVisible = false;
TbStyle.GridLineColor = System.Drawing.Color.Black;
TbStyle.AllowSorting = false;
TbStyle.AlternatingBackColor = System.Drawing.Color.AliceBlue;
DataGridTextBoxColumn Col_01 = new DataGridTextBoxColumn();
Col_01.HeaderText = "Order ID";
Col_01.MappingName = "ID";
Col_01.Width = 50;
Col_01.NullText = "";
Col_01.ReadOnly = true;
DataGridTextBoxColumn Col_02 = new DataGridTextBoxColumn();
Col_02.HeaderText = "Teacher Name";
Col_02.MappingName = "Teacher";
Col_02.Width = 150;
Col_02.NullText = "";
Col_02.ReadOnly = true;
DataGridTextBoxColumn Col_03 = new DataGridTextBoxColumn();
Col_03.HeaderText = "Student Name";
Col_03.MappingName = "Student";
Col_03.Width = 150;
Col_03.NullText = "";
Col_03.ReadOnly = true;
DataGridTextBoxColumn Col_04 = new DataGridTextBoxColumn();
Col_04.HeaderText = "Packed";
Col_04.MappingName = "Packed";
Col_04.Width = 50;
Col_04.NullText = "";
Col_04.ReadOnly = true;
DataGridTextBoxColumn Col_05 = new DataGridTextBoxColumn();
Col_05.HeaderText = "Scanned";
Col_05.MappingName = "Scanned";
Col_05.Width = 50;
Col_05.NullText = "";
Col_05.ReadOnly = true;
TbStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { Col_01, Col_02, Col_03, Col_04, Col_05 });
DataGrid.TableStyles.Add(TbStyle);
DataGrid.DataSource = dt;
DataGrid.Focus();
//oMySql.Close();
}
