private void button_Them_Click(object sender, EventArgs e) { String tennhanvien = textBox_name.Text; String vitri = textBox_vitri.Text; int luong = int.Parse(textBox_luong.Text); if (textBox_luong.Text == "" || textBox_name.Text == "" || textBox_vitri.Text == "") { MessageBox.Show("Khong duoc de trong"); } else { String sql = String.Format("Insert into NHANVIEN values('{0}','{1}','{2}')", tennhanvien, vitri, luong); int result = genericDatabase.NonQuerySQL(sql); if (result > 0) { MessageBox.Show("Luu thanh cong"); frm_NhanVien_Load(null, null); } else { MessageBox.Show("Them that bai"); } } }
private void button_Them_Click(object sender, EventArgs e) { string query = string.Format("insert into KhachHang values('{0}','{1}','{2}')", txt_HoTen.Text, txt_SDT.Text, txt_DiaChi.Text); int result = genericDatabase.NonQuerySQL(query); if (result >= 1) { MessageBox.Show("Thêm thành công"); } else { MessageBox.Show("Thêm thất bại"); } frm_KhachHang_Load(null, null); }
private void buttonThem_Click(object sender, EventArgs e) { string query = string.Format("insert into DANHMUCBANH values('{0}','{1}')", textBoxTenbanh.Text, textBoxGia.Text); int result = genericDatabase.NonQuerySQL(query); frm_DanhMuc_Load(null, null); if (result >= 1) { MessageBox.Show("Thêm thành công"); } else { MessageBox.Show("Thêm thất bại"); } }
private void button_TaoHoaDon_Click(object sender, EventArgs e) { string query1 = string.Format("insert into DonHang values({0},'{1}',{2},'{3}',{4})", int.Parse(comboBox_KhachHang.SelectedValue.ToString()), dateTimePicker_NgayDat.Value.ToString(), int.Parse(textBox_TienCoc.Text), dateTimePicker_NgayNhan.Value.ToString(), int.Parse(comboBox_NhanVien.SelectedValue.ToString())); genericDatabase.NonQuerySQL(query1); int msdh = (int)genericDatabase.QuerySQL("select max(msdh) from DonHang"); for (int i = 0; i < tb.Rows.Count; i++) { int msb = int.Parse(tb.Rows[i]["MSB"].ToString()); int soluong = int.Parse(tb.Rows[i]["SOLUONG"].ToString()); string query2 = string.Format("insert into CHITIETDONHANG values({0},{1},{2})", msdh, msb, soluong); genericDatabase.NonQuerySQL(query2); } MessageBox.Show("Thành Công"); }
private void button_add_Click(object sender, EventArgs e) { int msnl = int.Parse(textBox_msnl.Text); string name = textBox_tennguyenlieu.Text; string donvitinh = textBox_donvi.Text; int soluong = int.Parse(textBox_soluong.Text); string date_nhap = dateTimePicker_ngaynhap.Value.ToString("MM-dd-yyyy"); string date_capnhat = DateTime.Today.ToString("MM-dd-yyyy"); string sql = String.Format("insert into NGUYENLIEU values('{0}','{1}','{2}','{3}','{4}','{5}')", msnl, name, donvitinh, soluong, date_nhap, date_capnhat); int output = gen.NonQuerySQL(sql); if (output >= 1) { MessageBox.Show("Thành công", "Thông báo"); } frm_NguyenLieu_Load(null, null); }