public CreateAc(EditMenu m) { InitializeComponent(); this.m = m; Dictionary <String, String> comboSource = new Dictionary <String, String>(); comboSource.Add("1", "RM"); comboSource.Add("2", "PM"); comboSource.Add("3", "CM"); comboSource.Add("4", "WC"); comboSource.Add("5", "AD"); comboSource.Add("6", "AM"); comboBox1.DataSource = new BindingSource(comboSource, null); comboBox1.DisplayMember = "Value"; comboBox1.ValueMember = "Key"; Dictionary <String, String> comboSource2 = new Dictionary <String, String>(); MySqlDataAdapter sda = new MySqlDataAdapter("select RestNo, RestName from Restaurant;", cnn); DataTable dt = new DataTable(); sda.Fill(dt); int i = 1; foreach (DataRow dr in dt.Rows) { String restInfo = dr["RestNo"].ToString() + " - " + dr["RestName"].ToString(); comboSource2.Add(i++.ToString(), restInfo); } comboBox2.DataSource = new BindingSource(comboSource2, null); comboBox2.DisplayMember = "Value"; comboBox2.ValueMember = "Key"; }
public CreateRest(EditMenu m) { InitializeComponent(); this.m = m; int restID; MySqlConnection cnn = new MySqlConnection("server=code4cat.me;user id=jackysc;password=123456;database=procurement;SslMode=none;"); MySqlDataAdapter sda = new MySqlDataAdapter("select Max(RestNo) from Restaurant;", cnn); DataTable dt = new DataTable(); sda.Fill(dt); rid = dt.Rows[0][0].ToString(); //add 1 to the restaurant number rid = Regex.Match(rid, @"\d+").Value; restID = Int32.Parse(rid); restID += 1; rid = "R" + restID.ToString().PadLeft(3, '0'); tbID.Text = rid; Dictionary <String, String> comboSource = new Dictionary <String, String>(); MySqlDataAdapter sda2 = new MySqlDataAdapter("select distinct name from Category where parent_id is not null;", cnn); DataTable dt2 = new DataTable(); sda2.Fill(dt2); int i = 1; foreach (DataRow dr2 in dt2.Rows) { comboSource.Add(i++.ToString(), dr2["name"].ToString()); } comboBox1.DataSource = new BindingSource(comboSource, null); comboBox1.DisplayMember = "Value"; comboBox1.ValueMember = "Key"; }
public EditAc(String deptCode, String userDept, String StaffNo, EditMenu em) { InitializeComponent(); this.StaffNo = StaffNo; this.deptCode = deptCode; this.em = em; this.userDept = userDept; if (userDept == "AM" && deptCode == "RM") { comboBox2.Enabled = true; comboBox2.Visible = true; } else { comboBox2.Visible = false; label7.Visible = false; } setData(); }
private void button1_Click(object sender, EventArgs e) { switch (deptCode) { case "AM": this.Hide(); EditMenu em = new EditMenu(this, 0); em.Show(); break; case "RM": this.Hide(); PurchaseRequest pr = new PurchaseRequest(this, restNo, StaffNo); pr.Show(); break; case "PM": this.Hide(); TypeofAgreementMenu tam = new TypeofAgreementMenu(staffName, this); tam.Show(); break; case "CM": this.Hide(); Category cat = new Category(this); cat.Show(); break; case "WC": this.Hide(); WHViewDPI dpi = new WHViewDPI(this); dpi.Show(); break; case "AD": this.Hide(); TypeofAgreementMenu adtam = new TypeofAgreementMenu(staffName, this); adtam.Show(); break; } }
public EditRest(String restNo, EditMenu em) { InitializeComponent(); this.restNo = restNo; Dictionary <String, String> comboSource = new Dictionary <String, String>(); MySqlDataAdapter sda = new MySqlDataAdapter("select distinct name from Category where parent_id is not null;", cnn); DataTable dt = new DataTable(); sda.Fill(dt); int i = 1; foreach (DataRow dr in dt.Rows) { comboSource.Add(i++.ToString(), dr["name"].ToString()); } comboBox1.DataSource = new BindingSource(comboSource, null); comboBox1.DisplayMember = "Value"; comboBox1.ValueMember = "Key"; setData(); this.em = em; }
private void btn2_Click(object sender, EventArgs e) { switch (deptCode) { case "PM": this.Hide(); PRMapping prm = new PRMapping(this); prm.Show(); break; case "RM": this.Hide(); ViewDeliveryNoteMenu vDN = new ViewDeliveryNoteMenu(this, "RM", restNo); vDN.Show(); break; case "AD": case "WC": this.Hide(); ViewDeliveryNoteMenu WHvDN = new ViewDeliveryNoteMenu(this, "WC"); WHvDN.Show(); break; case "AM": this.Hide(); EditMenu em = new EditMenu(this, 1); em.Show(); break; case "CM": this.Hide(); Item itm = new Item(this); itm.Show(); break; } }