public static List <Lop> GetListLop(string maNamHoc = null)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd;
if (maNamHoc == null)
{
cmd = DataAccessHelper.GetInstance().Command("GetLop");
cmd.CommandType = CommandType.StoredProcedure;
}
else
{
cmd = DataAccessHelper.GetInstance().Command("GETLISTLOP_NAM");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaNamHoc", maNamHoc);
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
List <Lop> listLop = new List <Lop>();
foreach (DataRow row in DataAccessHelper.GetInstance().GetDataTable().Rows)
{
listLop.Add(new Lop(row));
}
DataAccessHelper.GetInstance().Close();
return(listLop);
}
public static bool ThemThongTinThucDon(Entities.ThongTinThucDon thongTinTD)
{
try
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("ThemThongTinThucDon");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaTre", thongTinTD.MaTre);
cmd.Parameters.AddWithValue("@BuoiApDung", thongTinTD.BuoiApDung);
cmd.Parameters.AddWithValue("@NgayApDung", thongTinTD.NgayApDung);
cmd.Parameters.AddWithValue("@MonApDung", thongTinTD.MonApDung);
cmd.Parameters.AddWithValue("@LoaiApDung", thongTinTD.LoaiApDung);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
}
catch (Exception e)
{
MessageBox.Show("Phát sinh lỗi khi thêm thông thực đơn, vui lòng kiểm tra thông tin và thử lại" + e.Message, "Thông báo", MessageBoxButtons.OK);
return(false);
}
return(true);
}
public static void ThemNguyenLieu(NguyenLieu nguyenLieu)
{
try
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("ThemNguyenLieu");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaNL", nguyenLieu.MaNguyenLieu);
cmd.Parameters.AddWithValue("@TenNL", nguyenLieu.TenNguyenLieu);
cmd.Parameters.AddWithValue("@MaLoaiNL", nguyenLieu.MaLoai);
cmd.Parameters.AddWithValue("@NangLuong", nguyenLieu.NangLuong);
cmd.Parameters.AddWithValue("@DonViTinh", nguyenLieu.DonViTinh);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
}
catch (Exception e)
{
MessageBox.Show("Phát sinh lỗi khi lưu nguyên liệu, vui lòng kiểm tra nguyên liệu và thử lại", "Thông báo", MessageBoxButtons.OK);
}
}
public static string GetLastBienLaiID()
{
DataAccessHelper.GetInstance().Open();
DataTable dt = DataAccessHelper.GetInstance().GetDataTable("Select top 1 MaBienLai from BIENLAITHUHOCPHI order by MaBienLai desc");
foreach (DataRow row in dt.Rows)
{
DataAccessHelper.GetInstance().Close();
return(row.ItemArray[0].ToString());
}
DataAccessHelper.GetInstance().Close();
return("");
}
public static bool KiemTraMonAn(string maMonAn)
{
DataAccessHelper.GetInstance().Open();
DataTable dt = DataAccessHelper.GetInstance().GetDataTable("select * from MONAN where MaMonAn = '" + maMonAn.Trim() + "'");
foreach (DataRow row in dt.Rows)
{
DataAccessHelper.GetInstance().Close();
return(true);
}
DataAccessHelper.GetInstance().Close();
return(false);
}
public static string GetLastIDNienKhoa()
{
DataAccessHelper.GetInstance().Open();
DataTable dt = DataAccessHelper.GetInstance().GetDataTable("Select top 1 MaNamHoc from NAMHOC order by MaNamHoc desc");
foreach (DataRow row in dt.Rows)
{
DataAccessHelper.GetInstance().Close();
return(row.ItemArray[0].ToString());
}
DataAccessHelper.GetInstance().Close();
return("");
}
public static bool KiemTraMaNL(string maMon, string maNL)
{
DataAccessHelper.GetInstance().Open();
DataTable dt = DataAccessHelper.GetInstance().GetDataTable("select * from CHITIET_MONAN where MaMonAn = '" + maMon + "' and MaNguyenLieu = '" + maNL + "'");
foreach (DataRow row in dt.Rows)
{
DataAccessHelper.GetInstance().Close();
return(true);
}
DataAccessHelper.GetInstance().Close();
return(false);
}
public static int GetSiSoToiDa()
{
DataAccessHelper.GetInstance().Open();
DataTable dt = DataAccessHelper.GetInstance().GetDataTable("SELECT SiSoToiDaCuaLop from QUYDINH");
foreach (DataRow row in dt.Rows)
{
DataAccessHelper.GetInstance().Close();
return(Convert.ToInt32(row.ItemArray[0].ToString()));
}
DataAccessHelper.GetInstance().Close();
return(0);
}
public static string GetLastLoaiLopID()
{
DataAccessHelper.GetInstance().Open();
DataTable dt = DataAccessHelper.GetInstance().GetDataTable("Select top 1 MaLoaiLop from LOAILOP order by MaLoaiLop desc");
foreach (DataRow row in dt.Rows)
{
DataAccessHelper.GetInstance().Close();
return(row.ItemArray[0].ToString());
}
DataAccessHelper.GetInstance().Close();
return("");
}
public static string GetLastID()
{
DataAccessHelper.GetInstance().Open();
DataTable dt = DataAccessHelper.GetInstance().GetDataTable("Select top 1 MaPhieu from PHIEUTIEPNHANTRE order by MaPhieu desc");
foreach (DataRow row in dt.Rows)
{
DataAccessHelper.GetInstance().Close();
return(row.ItemArray[0].ToString());
}
DataAccessHelper.GetInstance().Close();
return("");
}
public static string LayMaCuoi()
{
DataAccessHelper.GetInstance().Open();
DataTable dt = DataAccessHelper.GetInstance().GetDataTable("select top 1 MaNguyenLieu from NGUYENLIEU order by MaNguyenLieu desc");
foreach (DataRow row in dt.Rows)
{
DataAccessHelper.GetInstance().Close();
return(row.ItemArray[0].ToString());
}
DataAccessHelper.GetInstance().Close();
return("");
}
public static string GetLastID()
{
DataAccessHelper.GetInstance().Open();
DataTable dt = DataAccessHelper.GetInstance().GetDataTable("Select top 1 MaDanhMuc from DANHMUCCHIPHI order by MaDanhMuc desc");
foreach (DataRow row in dt.Rows)
{
DataAccessHelper.GetInstance().Close();
return(row.ItemArray[0].ToString());
}
DataAccessHelper.GetInstance().Close();
return("");
}
public static void XoaDanhMucChiPhi(string maDanhMuc)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("XoaDanhMucChiPhi");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaDanhMuc", maDanhMuc);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
}
public static void CapNhatSiSo(string maLop, int siSo)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("CapNhatSiSoLop");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaLop", maLop);
cmd.Parameters.AddWithValue("@SiSo", siSo);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
}
public static DataTable LayDanhSachNguyenLieu()
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("LayDanhSachThongTinNguyenLieu");
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
return(DataAccessHelper.GetInstance().GetDataTable());
}
public static DataTable GetListDanhMucChiPhi()
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("GetListDanhMucChiPhi");
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
return(DataAccessHelper.GetInstance().GetDataTable());
}
public static void CapNhatNienKhoa(string maNienKhoa, string tenNienKhoa)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("CapNhatNienKhoa");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaNamHoc", maNienKhoa);
cmd.Parameters.AddWithValue("@NamHoc", tenNienKhoa);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
}
public static void ThemLoaiLop(string maLoaiLop, string tenLoaiLop)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("ThemLoaiLop");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaLoaiLop", maLoaiLop);
cmd.Parameters.AddWithValue("@TenLoaiLop", tenLoaiLop);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
}
public static DataTable LayDanhSachNguyenLieuTheoNgay(DateTime ngayAD)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("LayDanhSachNguyenLieuTheoNgay");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@NgayApDung", ngayAD);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
return(DataAccessHelper.GetInstance().GetDataTable());
}
public static DataTable GetInfoNamHoc(string maNamHoc)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("GetInfoNamHoc");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaNamHoc", maNamHoc);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
return(DataAccessHelper.GetInstance().GetDataTable());
}
public static void ChuyenLop(string maTre, string maLopMoi)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("ChuyenLop");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaTre", maTre);
cmd.Parameters.AddWithValue("@MaLopMoi", maLopMoi);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
}
public static void CapNhatSiSoToiDa(int siSoCu, int siSoMoi)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("CapNhatSiSoToiDa");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SiSoCu", siSoCu);
cmd.Parameters.AddWithValue("@SiSo", siSoMoi);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
}
public static DataTable layDanhSachLoaiNguyenLieu()
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("LayDanhSachLoaiNguyenLieu");
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
//DataTable dt = db.GetDataTable("SELECT * FROM NGUYENLIEU");
return(DataAccessHelper.GetInstance().GetDataTable());
}
public static DataTable GetThongTinNguoiDung(string tenDangNhap)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("GETTHONGTINUSER");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TENDANGNHAP", tenDangNhap);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
return(DataAccessHelper.GetInstance().GetDataTable());
}
public static DataTable XemQuyen(string user)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("LAYQUYENTAIKHOAN");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TENDANGNHAP", user);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
return(DataAccessHelper.GetInstance().GetDataTable());
}
public static DataTable LayDanhSachNguyenLieu(string tuKhoa)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("TimKiemNguyenLieu");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TuKhoa", tuKhoa);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
return(DataAccessHelper.GetInstance().GetDataTable());
}
//public static void XoaDanhSachChiTietPhieuMuaNL(string maPhieuMua)
//{
// DataAccessHelper.GetInstance().Open();
// SqlCommand cmd = DataAccessHelper.GetInstance().Command("XOA_DANH_SACH_CHI_TIET_PHIEU_MUA");
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@MaPhieu", maPhieuMua);
// SqlDataAdapter da = new SqlDataAdapter(cmd);
// DataAccessHelper.GetInstance().SetDataTable(new DataTable());
// da.Fill(DataAccessHelper.GetInstance().GetDataTable());
//}
public static DataTable LayDanhSachChiTietMonAn(string maMon)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("LayDanhSachNguyenLieuTheoMaMon");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaMonAn", maMon);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
return(DataAccessHelper.GetInstance().GetDataTable());
}
public static void XoaChiTietMonAn(string maMon, string maNL)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("XoaNguyenLieuTungMon");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaMon", maMon);
cmd.Parameters.AddWithValue("@MaNL", maNL);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
}
public static DataTable LayThongTinTre(string maTre)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("GETTHONGTINTRE");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaTre", maTre);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
return(DataAccessHelper.GetInstance().GetDataTable());
}
public static DataTable GetListTreChuaCoLop(int tuoiMin, int tuoiMax)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("GetListTreChuaCoLop");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TuoiMin", tuoiMin);
cmd.Parameters.AddWithValue("@TuoiMax", tuoiMax);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
return(DataAccessHelper.GetInstance().GetDataTable());
}
