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);
}
