public static List <MonAn> XemMonAn(StoreProcEnum type = StoreProcEnum.XemMonAn) { List <MonAn> result = new List <MonAn>(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); using (SqlCommand cmd = new SqlCommand(type.ToString(), conn)) { cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { return(result); } while (reader.Read()) { MonAn row = new MonAn(); row.MaMonAn = (int)reader["MaMonAn"]; row.TenMonAn = (string)reader["TenMonAn"]; row.MaLoai = (int)reader["MaLoai"]; row.TenLoai = (string)reader["TenLoai"]; row.URLHinhMonAn = (string)reader["URLHinhMonAn"]; row.MoTa = (string)reader["MoTa"]; row.Gia = (long)reader["Gia"]; row.SoLuong = (int)reader["SoLuong"]; result.Add(row); } reader.Close(); } } return(result); }
public static List <ChuongTrinhKhuyenMai> XemChuongTrinhKhuyenMai(StoreProcEnum type = StoreProcEnum.XemChuongTrinhKhuyenMai) { List <ChuongTrinhKhuyenMai> result = new List <ChuongTrinhKhuyenMai>(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); using (SqlCommand cmd = new SqlCommand(type.ToString(), conn)) { cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { return(result); } while (reader.Read()) { ChuongTrinhKhuyenMai row = new ChuongTrinhKhuyenMai(); row.MaKhuyenMai = (int)reader["MaKhuyenMai"]; row.TenChuongTrinh = (string)reader["TenChuongTrinh"]; row.MaLoai = (int)reader["MaLoai"]; row.DoiTuongApDung = (int)reader["DoiTuongApDung"]; row.GiaTri = (long)reader["GiaTri"]; row.NgayBatDau = reader["NgayBatDau"].ToString(); row.NgayKetThuc = reader["NgayKetThuc"].ToString(); row.SoLuong = (int)reader["SoLuong"]; result.Add(row); } reader.Close(); } } return(result); }
public static DonHang XemMotDonHang(int MaDonHang, StoreProcEnum type = StoreProcEnum.XemMotDonHang) { DonHang result = null; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); using (SqlCommand cmd = new SqlCommand(type.ToString(), conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaDonHang", MaDonHang); SqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { return(result); } int lastMaDonHang = -1; result = new DonHang(); while (reader.Read()) { result.MaDonHang = (int)reader["MaDonHang"]; if (result.MaDonHang != lastMaDonHang) { lastMaDonHang = result.MaDonHang; result.TenChiNhanh = (string)reader["TenChiNhanh"]; result.TenThanhVien = (string)reader["TenThanhVien"]; result.ThoiGianTao = reader["ThoiGianTao"].ToString(); result.ThoiGianGiaoHang = reader["ThoiGianGiaoHang"].ToString(); result.TenTrangThai = (string)reader["TenTrangThai"]; result.TongTien = (long)reader["TongTien"]; result.PhiGiaoHang = (long)reader["PhiGiaoHang"]; result.PhuongThucThanhToan = reader["PhuongThucThanhToan"].ToString(); result.DiaChiGiaoHang = (string)reader["DiaChiGiaoHang"]; result.TenKenhDatHang = (string)reader["TenKenhDatHang"]; var MaMonAn = (int)reader["MaMonAn"]; var TenMonAn = (string)reader["TenMonAn"]; var SoLuong = (int)reader["SoLuong"]; var Gia = (long)reader["Gia"]; result.ChiTiet.Add(new ChiTietDonHang(MaMonAn, TenMonAn, SoLuong, Gia)); } else { var MaMonAn = (int)reader["MaMonAn"]; var TenMonAn = (string)reader["TenMonAn"]; var SoLuong = (int)reader["SoLuong"]; var Gia = (long)reader["Gia"]; result.ChiTiet.Add(new ChiTietDonHang(MaMonAn, TenMonAn, SoLuong, Gia)); } } reader.Close(); } } return(result); }
private static void CapNhatVoucher(int MaVoucher, string GiaTri, StoreProcEnum type) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); using (SqlCommand cmd = new SqlCommand(type.ToString(), conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaKhuyenMai", MaVoucher); cmd.Parameters.AddWithValue("@GiaTri", GiaTri); cmd.ExecuteNonQuery(); } } }
private static void UpdateSoLuongMonAn(int MaMonAn, int SoLuong, StoreProcEnum type) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); using (SqlCommand cmd = new SqlCommand(type.ToString(), conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaMonAn", MaMonAn); cmd.Parameters.AddWithValue("@SoLuong", SoLuong); cmd.ExecuteNonQuery(); } } }
private static List <DataTable> LocVoucher(int GiaTri, StoreProcEnum type) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); using (SqlCommand cmd = new SqlCommand(type.ToString(), conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@GiaTri", GiaTri); SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); da = new SqlDataAdapter(cmd); da.Fill(ds); List <DataTable> result = new List <DataTable>(); foreach (DataTable element in ds.Tables) { result.Add(element); } return(result); } } }
public static List <ThanhVien> XemThanhVien(StoreProcEnum type = StoreProcEnum.XemThanhVien) { List <ThanhVien> result = new List <ThanhVien>(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); using (SqlCommand cmd = new SqlCommand(type.ToString(), conn)) { cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { return(result); } while (reader.Read()) { ThanhVien row = new ThanhVien(); row.MaThanhVien = (int)reader["MaThanhVien"]; row.MaChiNhanh = (int)reader["MaChiNhanh"]; row.HoTen = (string)reader["HoTen"]; row.CMND = (string)reader["CMND"]; row.SoDienThoai = (string)reader["SoDienThoai"]; row.Email = (string)reader["Email"]; row.NgaySinh = reader["NgaySinh"].ToString(); row.DiaChi = (string)reader["DiaChi"]; row.QuyenHan = 0; row.DiemTichLuy = (long)reader["DiemTichLuy"]; result.Add(row); } reader.Close(); } } return(result); }
private static void ThemVoucher(int MaLoai, string TenChuongTrinh, int DoiTuongApDung, int GiaTri, string NgayBatDau, string NgayKetThuc, int SoLuong, StoreProcEnum type) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); using (SqlCommand cmd = new SqlCommand(type.ToString(), conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TenChuongTrinh", TenChuongTrinh); cmd.Parameters.AddWithValue("@MaLoai", MaLoai); cmd.Parameters.AddWithValue("@DoiTuongApDung", DoiTuongApDung); cmd.Parameters.AddWithValue("@GiaTri", GiaTri); cmd.Parameters.AddWithValue("@NgayBatDat", DateTime.ParseExact(NgayBatDau, "dd/MM/yyyy", null)); cmd.Parameters.AddWithValue("@NgayKetThuc", DateTime.ParseExact(NgayKetThuc, "dd/MM/yyyy", null)); cmd.Parameters.AddWithValue("@SoLuong", SoLuong); try { cmd.ExecuteNonQuery(); } catch { MessageBox.Show("Không thể thêm chương trình khuyến mãi có số lượng nhỏ hơn hoặc bằng 0"); } } } }
private static void ThemThanhVien(int MaChiNhanh, string TenThanhVien, string CMND, string SDT, string Email, string NgaySinh, string DiaChi, long DiemTichLuy, StoreProcEnum type) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); using (SqlCommand cmd = new SqlCommand(type.ToString(), conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaChiNhanh", MaChiNhanh); cmd.Parameters.AddWithValue("@HoTen", TenThanhVien); cmd.Parameters.AddWithValue("@CMND", CMND); cmd.Parameters.AddWithValue("@SoDienThoai", SDT); cmd.Parameters.AddWithValue("@Email", Email); cmd.Parameters.AddWithValue("@NgaySinh", DateTime.ParseExact(NgaySinh, "dd/MM/yyyy", null)); cmd.Parameters.AddWithValue("@DiaChi", DiaChi); cmd.Parameters.AddWithValue("@DiemTichLuy", DiemTichLuy); try { cmd.ExecuteNonQuery(); } catch { MessageBox.Show("Số CMND không hợp lệ"); } } } }
private static void CapNhatThanhVien(int MaThanhVien, int MaChiNhanh, string TenThanhVien, string CMND, string SDT, string Email, string NgaySinh, string DiaChi, long DiemTichLuy, StoreProcEnum type) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); using (SqlCommand cmd = new SqlCommand(type.ToString(), conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaThanhVien", MaThanhVien); cmd.Parameters.AddWithValue("@MaChiNhanh", MaChiNhanh); cmd.Parameters.AddWithValue("@TenThanhVien", TenThanhVien); cmd.Parameters.AddWithValue("@CMND", CMND); cmd.Parameters.AddWithValue("@SoDienThoai", SDT); cmd.Parameters.AddWithValue("@Email", Email); cmd.Parameters.AddWithValue("@NgaySinh", NgaySinh); cmd.Parameters.AddWithValue("@DiaChi", DiaChi); cmd.Parameters.AddWithValue("@DiemTichLuy", DiemTichLuy); cmd.ExecuteNonQuery(); } } }
private static void DoCommandOnFood(int MaMonAn = 0, string TenMonAn = "", string URLHinhMonAn = "", string MoTa = "", long Gia = 0, StoreProcEnum type = StoreProcEnum.CapNhapMonAn_Deadlock) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); using (SqlCommand cmd = new SqlCommand(type.ToString(), conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaMonAn", MaMonAn); cmd.Parameters.AddWithValue("@TenMonAn", TenMonAn); cmd.Parameters.AddWithValue("@URLHinhMonAn", URLHinhMonAn); cmd.Parameters.AddWithValue("@MoTa", MoTa); cmd.Parameters.AddWithValue("@Gia", Gia); cmd.ExecuteNonQuery(); } } }
public static List <DonHang> XemDonHang(StoreProcEnum type = StoreProcEnum.XemDonHang) { List <DonHang> result = new List <DonHang>(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); using (SqlCommand cmd = new SqlCommand(type.ToString(), conn)) { cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { return(result); } int lastMaDonHang = -1; while (reader.Read()) { DonHang row = new DonHang(); row.MaDonHang = (int)reader["MaDonHang"]; if (row.MaDonHang != lastMaDonHang) { lastMaDonHang = row.MaDonHang; row.TenChiNhanh = (string)reader["TenChiNhanh"]; row.TenThanhVien = (string)reader["TenThanhVien"]; row.ThoiGianTao = reader["ThoiGianTao"].ToString(); row.ThoiGianGiaoHang = reader["ThoiGianGiaoHang"].ToString(); row.TenTrangThai = (string)reader["TenTrangThai"]; row.TongTien = (long)reader["TongTien"]; row.PhiGiaoHang = (long)reader["PhiGiaoHang"]; row.PhuongThucThanhToan = reader["PhuongThucThanhToan"].ToString(); row.DiaChiGiaoHang = (string)reader["DiaChiGiaoHang"]; row.TenKenhDatHang = (string)reader["TenKenhDatHang"]; var MaMonAn = (int)reader["MaMonAn"]; var TenMonAn = (string)reader["TenMonAn"]; var SoLuong = (int)reader["SoLuong"]; var Gia = (long)reader["Gia"]; ChiTietDonHang donHang = new ChiTietDonHang(MaMonAn, TenMonAn, SoLuong, Gia); donHang.PropertyChanged += MainWindow.PropertyChanged; row.ChiTiet.Add(donHang); result.Add(row); } else { var MaMonAn = (int)reader["MaMonAn"]; var TenMonAn = (string)reader["TenMonAn"]; var SoLuong = (int)reader["SoLuong"]; var Gia = (long)reader["Gia"]; ChiTietDonHang donHang = new ChiTietDonHang(MaMonAn, TenMonAn, SoLuong, Gia); donHang.PropertyChanged += MainWindow.PropertyChanged; result[result.Count - 1].ChiTiet.Add(donHang); } } reader.Close(); } } return(result); }