public bool Insert(ChiTiet_HD ct, out string message)
{
bool result = false;
string str = String.Format("insert into ChiTiet_HD values({0},{1},{2})", ct.MaHD, ct.MaSP, ct.SoLuong);
result = main.ExecuteNonQuery(str, out message);
return(result);
}
public bool Insert(HoaDon hd, out string message)
{
bool result = false;
string str = String.Format("insert into HoaDon values({0},{1},{2},{3},{4},{5},{6})", hd.MaHD, hd.TongTien,
hd.TongGiaSP, hd.Ngay, hd.Thang, hd.Nam, 1);
result = main.ExecuteNonQuery(str, out message);
return(result);
}
public bool Insert(NhanVien nv, out string message)
{
bool result = false;
string sql = string.Format("insert into NhanVien(MaNV,HoTen,GT,CMND,SDT,TT_LamViec,MatKhau,QuanLi) " +
"values({0},N'{1}','{2}',{3},{4},1,'{5}',{6})", nv.MaNV, nv.HoTen, nv.GT, nv.CMND, nv.SDT, nv.MatKhau, nv.QuanLi);
result = dbNV.ExecuteNonQuery(sql, out message);
return(result);
}
public bool Insert(DoanhThu dthu, out string message)
{
bool result = false;
string sql = string.Format("insert into DOANHTHU_THANG " +
"values({0},{1},{2},{3},{4})", dthu.ThangBH, dthu.NamBH, dthu.DoanhThu_TH, dthu.TongGiaSP_TH, dthu.TongLuong_NV);
result = dbDT.ExecuteNonQuery(sql, out message);
return(result);
}
public bool Insert(Luong salar, out string message)
{
bool result = false;
string sql = string.Format("insert into LUONG " +
"values({0},{1},{2})", salar.MaNV, salar.NgayTraLuong, salar.TienLuong);
result = dbLuong.ExecuteNonQuery(sql, out message);
return(result);
}
public bool Update(PhanCong pc, out string message)
{
bool result = false;
string sql = string.Format("update PHANCONG set HeSo={0}" +
"where MaCa = {1} and MaNV ={2}", pc.HeSo, pc.MaCa, pc.MaNV);
result = main.ExecuteNonQuery(sql, out message);
return(result);
}
public bool ThemKhoa(string maKhoa, string tenKhoa, ref string err)
{
if (maKhoa == "" || tenKhoa == "")
{
err = "Không đủ thông tin để thêm !";
return(false);
}
string sqlString = "Insert Into Khoa Values(" + "'" + maKhoa + "',N'" + tenKhoa + "')";
return(dbMain.ExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool ThemSinhVien(string MSSV, string HoVaTen, string GioiTinh, string QueQuan, string NgaySinh, string CMND, string DiaChi, string NienKhoa, string maLop, ref string err)
{
string sqlString = "Select SinhVien.MSSV From SinhVien Where SinhVien.MSSV='" + MSSV + "'";
SqlDataReader sdr = dbMain.ExecuteReader(sqlString, CommandType.Text);
if (sdr.Read())
{
err = "Không thêm được, mã số sinh viên đã tồn tại !";
return(false);
}
sqlString = "Insert Into SinhVien Values('" + MSSV + "',N'" + HoVaTen + "',N'" + QueQuan + "','" + NgaySinh + "','" + CMND + "',N'" + GioiTinh + "',N'" + DiaChi + "','" + NienKhoa + "','" + maLop + "')";
return(dbMain.ExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool ThemDiem(string MSSV, string maMon, string TrangThai, string DiemSo, ref string err)
{
string sqlString = "Insert Into Diem Values('" + MSSV + "','" + maMon + "',N'" + TrangThai + "','" + DiemSo + "')";
return(dbMain.ExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool ThemNguoiThan(string HoVaTen, string MSSV, string DiaChi, string SDT, string QuanHe, ref string err)
{
string sqlString = "Insert Into ThanNhan Values(" + "N'" + HoVaTen + "','" + MSSV + "',N'" + DiaChi + "','" + SDT + "',N'" + QuanHe + "')";
return(dbMain.ExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool XoaLop(string maLop, ref string err)
{
string sqlString = "Delete From Lop Where MaLop='" + maLop + "'";
return(dbMain.ExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool ThemChuyenNganh(string maChuyenNganh, string tenChuyenNganh, string maKhoa, ref string err)
{
string sqlString = "Insert Into ChuyenNganh Values(" + "'" + maChuyenNganh + "',N'" + tenChuyenNganh + "','" + maKhoa + "')";
return(dbMain.ExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool XoaMonHoc(string maMonHoc, ref string err)
{
string sqlString = "Delete From MonHoc Where MaMon='" + maMonHoc + "'";
return(dbMain.ExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
