public void tao(int r, int c) { // select Bidatablemap lg.openconection(); SqlDataAdapter adapter = new SqlDataAdapter(); DataTable table = new DataTable(); SqlCommand command = new SqlCommand("SELECT * FROM BidaTabledb", lg.Connection); adapter = new SqlDataAdapter(command); adapter.Fill(table); // lg.closeconection(); int check = 0; int lengh = table.Rows.Count; r = lengh / 5 + 1; int top = 0; for (int i = 0; i < r; i++) { int left = 0; for (int j = 0; j < 5; j++) { if (check >= lengh) { break; } Button NewButton = new Button(); // int name = Convert.ToInt32(table.Rows[check].ItemArray[0].ToString()); NewButton.Name = string.Format("{0}", name); NewButton.Text = string.Format("ban so {0}", name); NewButton.BackColor = Color.Green; NewButton.Tag = string.Format("{0}", name); NewButton.Size = new Size(50, 50); NewButton.Top = top; NewButton.Left = left; left += 50; NewButton.Click += new EventHandler(Button_Click); panel1.Controls.Add(NewButton); check++; } top += 50; } }
private void ButtonSignin_Click(object sender, EventArgs e) { MYDB lg = new MYDB(); lg.openconection(); SqlDataAdapter adapter = new SqlDataAdapter(); DataTable table = new DataTable(); SqlCommand command = new SqlCommand("SELECT * FROM Customersdb WHERE Cuser=@User and Cpass=@Pass", lg.Connection); command.Parameters.Add("@User", SqlDbType.VarChar).Value = textBoxUser.Text; command.Parameters.Add("@Pass", SqlDbType.VarChar).Value = textBoxPass.Text; SqlDataReader reader = command.ExecuteReader(); if ((reader.Read() == true)) //if (command.ExecuteNonQuery() == 1) { KhachHangForm kh = new KhachHangForm(textBoxUser.Text); kh.Show(); } else { lg.closeconection(); lg.openconection(); command = new SqlCommand("SELECT * FROM Employeesdb WHERE Euser=@User and Epass=@Pass", lg.Connection); command.Parameters.Add("@User", SqlDbType.VarChar).Value = textBoxUser.Text; command.Parameters.Add("@Pass", SqlDbType.VarChar).Value = textBoxPass.Text; SqlDataReader reader1 = command.ExecuteReader(); if (reader1.Read() == true) { NhanVienForm nv = new NhanVienForm(); nv.Show(); } else { MessageBox.Show("invalid user"); } } }
public void loaddatabidamap() { MYDB lg = new MYDB(); int id = Convert.ToInt32(labelSoBan.Text); lg.openconection(); SqlDataAdapter adapter = new SqlDataAdapter(); DataTable table = new DataTable(); SqlCommand command = new SqlCommand("SELECT * FROM BidaTableMap where BidaTableID = " + id, lg.Connection); adapter = new SqlDataAdapter(command); adapter.Fill(table); // lg.closeconection(); dataGridView2.DataSource = table; }
public bool UpdateStatus(int status, int id) { MYDB db = new MYDB(); SqlCommand command = new SqlCommand("UPDATE BidaTableMap SET Status = @status where BidaTableMapID = @id", db.Connection); //command.Parameters.Add("@id", SqlDbType.Int).Value = PeopleId; command.Parameters.Add("@id", SqlDbType.Int).Value = id; command.Parameters.Add("@status", SqlDbType.Int).Value = status; db.openconection(); if ((command.ExecuteNonQuery() == 1)) { db.closeconection(); return(true); } else { db.closeconection(); return(false); } }
public bool insert(int Soban, string madichvu, int soluong) { MYDB db = new MYDB(); SqlCommand command = new SqlCommand("insert into OrderFooddb (BidaTableMap,Food,Number)" + "values(@BidaTableMap,@Food,@Number)", db.Connection); command.Parameters.Add("@BidaTableMap", SqlDbType.Int).Value = Soban; command.Parameters.Add("@Food", SqlDbType.Char).Value = madichvu; command.Parameters.Add("@Number", SqlDbType.Int).Value = soluong; db.openconection(); if ((command.ExecuteNonQuery() == 1)) { db.closeconection(); return(true); } else { db.closeconection(); return(false); } }
private void ButtonCapNhat_Click(object sender, EventArgs e) { string sex; if (radioButtonNam.Checked == true) { sex = "Man"; } else { sex = "Girl"; } MYDB db = new MYDB(); SqlCommand cmd = new SqlCommand("update Customersdb set CName=@ht,Cphone=@st,CBrithday=@bd,Csex=@dc where [Cuser]=N'" + std + "'", db.Connection); cmd.Parameters.Add("@ht", SqlDbType.NVarChar).Value = textBoxHoTen.Text; cmd.Parameters.Add("@st", SqlDbType.NVarChar).Value = textBoxStd.Text; cmd.Parameters.Add("@bd", SqlDbType.DateTime).Value = dateTimePicker1.Value; cmd.Parameters.Add("@dc", SqlDbType.NVarChar).Value = sex; db.openconection(); if (cmd.ExecuteNonQuery() == 1) { db.closeconection(); ThongTinKhachHang_Load(sender, e); textBoxHoTen.Enabled = false; textBoxStd.Enabled = false; dateTimePicker1.Enabled = false; radioButtonNam.Enabled = false; radioButtonNu.Enabled = false; MessageBox.Show("Đã Cập Nhật Thành Công", "Thông tin Khách Hàng", MessageBoxButtons.OK); } else { db.closeconection(); MessageBox.Show("Không Thể Cập Nhật", "Thông Tin Khách Hàng", MessageBoxButtons.OK); } }
public bool insert(DateTime Bdate, int employee, int bidatablemapID, float total) { MYDB db = new MYDB(); SqlCommand command = new SqlCommand("INSERT INTO Billsdb (Bdate,Employee,BidaTableMapID,Total)" + " VALUES (@Bdate,@Employee,@BidaTableMapID,@Total)", db.Connection); //command.Parameters.Add("@id", SqlDbType.Int).Value = PeopleId; command.Parameters.Add("@Bdate", SqlDbType.DateTime).Value = Bdate; command.Parameters.Add("@Employee", SqlDbType.Int).Value = employee; command.Parameters.Add("@BidaTableMapID", SqlDbType.Int).Value = bidatablemapID; command.Parameters.Add("@Total", SqlDbType.Float).Value = total; db.openconection(); if ((command.ExecuteNonQuery() == 1)) { db.closeconection(); return(true); } else { db.closeconection(); return(false); } }
public bool insert(int id, int status, int custommer, DateTime begin, DateTime end) { MYDB db = new MYDB(); SqlCommand command = new SqlCommand("INSERT INTO BidaTableMap (BidaTableID, Status,Customer,TimeBegin,TimeEnd)" + " VALUES (@id, @status, @customer, @begin,@end)", db.Connection); //command.Parameters.Add("@id", SqlDbType.Int).Value = PeopleId; command.Parameters.Add("@id", SqlDbType.Int).Value = id; command.Parameters.Add("@status", SqlDbType.Int).Value = status; command.Parameters.Add("@customer", SqlDbType.Int).Value = custommer; command.Parameters.Add("@begin", SqlDbType.DateTime).Value = begin; command.Parameters.Add("@end", SqlDbType.DateTime).Value = end; db.openconection(); if ((command.ExecuteNonQuery() == 1)) { db.closeconection(); return(true); } else { db.closeconection(); return(false); } }