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