public GenXlsx(String fileName, Main main, String dayOfweek, MaintainMenu_v2 m_v2) { InitializeComponent(); this.fileName = fileName; this.main = main; this.dayOfweek = dayOfweek; this.m_v2 = m_v2; tableLayoutPanel1.AutoScroll = true; label1.Text = "This menu will be named :" + fileName; label1.Font = new Font("Comic Sans MS", 12); DataTable dt = main.db.getDb("foodType"); int x = 50; for (int i = 0; i < dt.Rows.Count; i++) { Label lab = new Label(); String hidden = dt.Rows[i]["ftypeid"].ToString(); lab.Text = dt.Rows[i]["name"].ToString(); lab.Tag = hidden; lab.Location = new Point(500, x); lab.Font = new Font("Comic Sans MS", 12); lab.MouseDown += new MouseEventHandler(labMouseDown); x += 30; tabControl1.TabPages[0].Controls.Add(lab); } }
public addMenuType(Main main, MaintainMenu_v2 m_v2) { InitializeComponent(); this.main = main; this.m_v2 = m_v2; dt_menuCategory = main.db.getDb("menucategory"); }
public Main(Login login) { InitializeComponent(); this.login = login; this.db = login.database; this.KeyPreview = true; updateMenu(); AddValue addValue = new AddValue(this); MaintainMenu mMenu = new MaintainMenu(this); MaintainMenu_v2 mMenu_v2 = new MaintainMenu_v2(this); MaintainUser mUser = new MaintainUser(this); kitchenView kcv = new kitchenView(login); Form[] temp = { addValue, mMenu_v2, mUser, kcv }; frm = temp; int count = 0; DataTable dt_student = db.getDb("student where status not in('refund','freeze')"); for (int i = 0; i < dt_student.Rows.Count; i++) { DateTime create = DateTime.Parse(dt_student.Rows[i]["createAt"].ToString()); if (create.AddYears(2).ToShortDateString().Equals(DateTime.Now.ToShortDateString())) { String s = "Update student set status ='refund' where stuid='" + dt_student.Rows[i]["stuid"].ToString() + "'"; db.queny(s); count++; } } MessageBox.Show("There are " + count + " students' status change to refund."); string subPath = "Menu"; // your code goes here System.IO.Directory.CreateDirectory(subPath); string menuday = "1Monday"; System.IO.Directory.CreateDirectory(subPath + "\\" + menuday); menuday = "2Tuesday"; System.IO.Directory.CreateDirectory(subPath + "\\" + menuday); menuday = "3Wednesday"; System.IO.Directory.CreateDirectory(subPath + "\\" + menuday); menuday = "4Thursday"; System.IO.Directory.CreateDirectory(subPath + "\\" + menuday); menuday = "5Friday"; System.IO.Directory.CreateDirectory(subPath + "\\" + menuday); menuday = "6Saturday"; System.IO.Directory.CreateDirectory(subPath + "\\" + menuday); menuday = "7Sunday"; System.IO.Directory.CreateDirectory(subPath + "\\" + menuday); }
public addFood(String fid, Main main, DateTime date, MaintainMenu_v2 m_v2) { InitializeComponent(); this.fid = fid; this.main = main; this.date = date; this.m_v2 = m_v2; dt_foodtype = main.db.getDb("foodtype"); for (int i = 0; i < dt_foodtype.Rows.Count; i++) { combo_FoodType.Items.Add(dt_foodtype.Rows[i]["name"].ToString()); } /*if (date.ToShortDateString().Equals(DateTime.Today.ToShortDateString())) * { * dt_foodtype = main.db.getDb("foodtype"); * for (int i = 0; i < dt_foodtype.Rows.Count; i++) * { * combo_FoodType.Items.Add(dt_foodtype.Rows[i]["name"].ToString()); * } * } * else { * String dd = date.Day.ToString(); * String mm = date.Month.ToString(); * String yyyy = date.Year.ToString(); * String fileName = ""; * String[] temp = { "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday" }; * for (int i = 0; i < temp.Length; i++) * { * if (temp[i].Equals(date.DayOfWeek.ToString())) * { * fileName = i + 1 + temp[i]; * } * } * fileName += "\\" + dd + "_" + mm + "_" + yyyy + ".xlsx"; * * dt_foodtype = readXlsx(fileName, "foodtype"); * for (int i = 0; i < dt_foodtype.Rows.Count; i++) * { * String name = dt_foodtype.Rows[i]["name"].ToString(); * combo_FoodType.Items.Add(dt_foodtype.Rows[i]["name"].ToString()); * } * * }*/ }