public void Themdulieu() { Ketnoi ketnoi = new Ketnoi(); SqlConnection connect = new SqlConnection(ketnoi.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "ThongTinSanPham_Insert"; cmd.Parameters.Add("@MaNSX", SqlDbType.VarChar).Value = ttsanpham.MaNSX; cmd.Parameters.Add("@MaKieuDang", SqlDbType.VarChar).Value = ttsanpham.MaKieuDang; cmd.Parameters.Add("@MaPhongCach", SqlDbType.VarChar).Value = ttsanpham.MaPhongCach; cmd.Parameters.Add("@TenSanPham", SqlDbType.NVarChar).Value = ttsanpham.TenSanPham; cmd.Parameters.Add("@MoTa", SqlDbType.NVarChar).Value = ttsanpham.MoTa; cmd.Parameters.Add("@GiaSanPham", SqlDbType.Int).Value = ttsanpham.GiaSanPham; cmd.Parameters.Add("@ImageSP", SqlDbType.VarChar).Value = ttsanpham.ImageSP; cmd.Parameters.Add("@SoLuong", SqlDbType.Int).Value = ttsanpham.SoLuong; cmd.Parameters.Add("@TenHDH", SqlDbType.NVarChar).Value = ttsanpham.TenHDH; cmd.Parameters.Add("@RAM", SqlDbType.NVarChar).Value = ttsanpham.RAM; cmd.Parameters.Add("@Camera", SqlDbType.NVarChar).Value = ttsanpham.Camera; cmd.Parameters.Add("@Pin", SqlDbType.Int).Value = ttsanpham.Pin; cmd.ExecuteNonQuery(); }
public SqlDataSource Laydulieu() { Ketnoi kn = new Ketnoi(); SqlDataSource sqldata = new SqlDataSource(); sqldata.ConnectionString = kn.ConnectionString(); sqldata.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sqldata.SelectCommand = "NguoiDung_SelectAll"; return sqldata; }
public SqlDataSource Laydulieu() { SqlDataSource sqldata = new SqlDataSource(); Ketnoi stringconnect = new Ketnoi(); sqldata.ConnectionString = stringconnect.ConnectionString(); sqldata.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sqldata.SelectCommand = "NhaSX_SelectAll"; return sqldata; }
public SqlDataSource Table_Donhang() { Ketnoi kn = new Ketnoi(); SqlDataSource sql = new SqlDataSource(); sql.ConnectionString = kn.ConnectionString(); sql.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sql.SelectCommand = "ThongKeDonHang"; return sql; }
public string getstring() { SqlConnection con = new SqlConnection(kn.ConnectionString()); con.Open(); SqlCommand cmd = new SqlCommand("select MoTa from ThongTinSanPham where MaSanPham=41", con); string st = cmd.ExecuteScalar().ToString(); return(st); }
public SqlDataSource LaydulieuAdmin( string MaKieuNguoiDung) { SqlDataSource sqldata = new SqlDataSource(); Ketnoi connectString = new Ketnoi(); sqldata.ConnectionString = connectString.ConnectionString(); sqldata.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sqldata.SelectCommand = "NguoiDung_SelectByMaKND"; sqldata.SelectParameters.Add("MaKieuNguoiDung",MaKieuNguoiDung.ToString()); return sqldata; }
public SqlDataSource Laydulieu() { SqlDataSource sqldata = new SqlDataSource(); Ketnoi stringconnect = new Ketnoi(); sqldata.ConnectionString = stringconnect.ConnectionString(); sqldata.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sqldata.SelectCommand = "NhaSX_SelectAll"; return(sqldata); }
public SqlDataSource Get_Giohang() { Ketnoi kn = new Ketnoi(); SqlDataSource sql = new SqlDataSource(); sql.ConnectionString = kn.ConnectionString(); sql.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sql.SelectCommand = "ThongKeSPCuaNguoiMua"; sql.SelectParameters.Add("MaDonHang",Dh.MaDonHang.ToString()); return sql; }
public SqlDataSource Laydulieu() { Ketnoi kn = new Ketnoi(); SqlDataSource sqldata = new SqlDataSource(); sqldata.ConnectionString = kn.ConnectionString(); sqldata.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sqldata.SelectCommand = "NguoiDung_SelectAll"; return(sqldata); }
public SqlDataSource Table_Donhang() { Ketnoi kn = new Ketnoi(); SqlDataSource sql = new SqlDataSource(); sql.ConnectionString = kn.ConnectionString(); sql.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sql.SelectCommand = "ThongKeDonHang"; return(sql); }
public SqlDataSource Laydulieu() { SqlDataSource sqldata = new SqlDataSource(); Ketnoi connectString = new Ketnoi(); sqldata.ConnectionString = connectString.ConnectionString(); sqldata.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sqldata.SelectCommand = "ThongTinSanPham_SelectByID"; sqldata.SelectParameters.Add("MaSanPham",thongtinsanpham.MaSanPham.ToString()); return sqldata; }
public SqlDataSource LaydulieuAdmin(string MaKieuNguoiDung) { SqlDataSource sqldata = new SqlDataSource(); Ketnoi connectString = new Ketnoi(); sqldata.ConnectionString = connectString.ConnectionString(); sqldata.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sqldata.SelectCommand = "NguoiDung_SelectByMaKND"; sqldata.SelectParameters.Add("MaKieuNguoiDung", MaKieuNguoiDung.ToString()); return(sqldata); }
public SqlDataSource Get_Giohang() { Ketnoi kn = new Ketnoi(); SqlDataSource sql = new SqlDataSource(); sql.ConnectionString = kn.ConnectionString(); sql.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sql.SelectCommand = "ThongKeSPCuaNguoiMua"; sql.SelectParameters.Add("MaDonHang", Dh.MaDonHang.ToString()); return(sql); }
public SqlDataSource Laydulieu() { SqlDataSource sqldata = new SqlDataSource(); Ketnoi connectString = new Ketnoi(); sqldata.ConnectionString = connectString.ConnectionString(); sqldata.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sqldata.SelectCommand = "ThongTinSanPham_SelectByID"; sqldata.SelectParameters.Add("MaSanPham", thongtinsanpham.MaSanPham.ToString()); return(sqldata); }
public void XoaDuLieu() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "ThongTinSanPham_Delete"; cmd.Parameters.Add("@MaSanPham", SqlDbType.VarChar).Value = Thongtinsp.MaSanPham; cmd.ExecuteNonQuery(); }
public void XoaDuLieu() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "KieuDang_Delete"; cmd.Parameters.Add("@MaKieuDang", SqlDbType.VarChar).Value = Kdang.MaKieuDang; cmd.ExecuteNonQuery(); }
public void Delete_TinRaoVat() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "TinRaoVat_Delete"; cmd.Parameters.Add("@MaTin", SqlDbType.VarChar).Value = Tinraovat.MaTin; cmd.ExecuteNonQuery(); }
public void SuathongtinPhongcach() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PhongCach_Update"; cmd.Parameters.Add("@MaPhongCach",SqlDbType.VarChar).Value=Phongcach.MaPhongCach; cmd.Parameters.Add("@TenPhongCach", SqlDbType.NVarChar).Value = Phongcach.TenPhongCach ; cmd.ExecuteNonQuery(); }
public void suathongtinNSX() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "NhaSX_Update"; cmd.Parameters.Add("@MaNSX",SqlDbType.VarChar).Value=Nsx.MaNSX; cmd.Parameters.Add("@TenNSX",SqlDbType.NVarChar).Value=Nsx.TenNSX; cmd.ExecuteNonQuery(); }
public void Themdulieu() { Ketnoi connectString = new Ketnoi(); SqlConnection connect = new SqlConnection(connectString.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "NhaSX_Insert"; cmd.Parameters.Add("@MaNSX",SqlDbType.VarChar).Value=nhasx.MaNSX; cmd.Parameters.Add("@TenNSX",SqlDbType.NVarChar).Value=nhasx.TenNSX; cmd.ExecuteNonQuery(); }
public void XoaDuLieu() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PhongCach_Delete"; cmd.Parameters.Add("@MaPhongCach", SqlDbType.VarChar).Value = Phcach.MaPhongCach; cmd.ExecuteNonQuery(); }
public void Update_Donhang() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DonHang_Update"; cmd.Parameters.Add("@MaDonHang",SqlDbType.Int).Value=Donhang.MaDonHang; cmd.Parameters.Add("@NgayChuyen",SqlDbType.DateTime).Value=Donhang.NgayChuyen; cmd.Parameters.Add("@TinhTrang",SqlDbType.NVarChar).Value=Donhang.TinhTrang; cmd.ExecuteNonQuery(); }
public string Get_Pass() { string str=""; Ketnoi kn = new Ketnoi(); SqlConnection con = new SqlConnection(kn.ConnectionString()); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.CommandText = "GetPassByEmail"; cmd.Parameters.Add("@Email",SqlDbType.VarChar).Value=NgDung.Email; str = cmd.ExecuteScalar().ToString(); return str; }
public void Delete_Donhang() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DonHang_Delete"; cmd.Parameters.Add("@MaDonHang", SqlDbType.VarChar).Value = Donhang.MaDonHang; cmd.ExecuteNonQuery(); }
public void Them_TinRaoVat() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "TinRaoVat_Insert"; cmd.Parameters.Add("@TieuDe", SqlDbType.NVarChar).Value = Tinraovat.TieuDe; cmd.Parameters.Add("@Link", SqlDbType.VarChar).Value = Tinraovat.Link; cmd.Parameters.Add("@NgayDang", SqlDbType.DateTime).Value = Tinraovat.NgayDang; cmd.ExecuteNonQuery(); }
public void XoaDuLieu() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "NguoiDung_Delete"; cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = Nguoidung.Email; cmd.ExecuteNonQuery(); }
public void suathongtinNSX() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "NhaSX_Update"; cmd.Parameters.Add("@MaNSX", SqlDbType.VarChar).Value = Nsx.MaNSX; cmd.Parameters.Add("@TenNSX", SqlDbType.NVarChar).Value = Nsx.TenNSX; cmd.ExecuteNonQuery(); }
public DataTable Lay_table() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "ThongTinSanPham_SelectAll"; DataTable dt = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(dt); return dt; }
public DataTable Laydulieu() { DataTable dt = new DataTable(); Ketnoi kn = new Ketnoi(); SqlCommand cmd = new SqlCommand(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DangNhap_Select"; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(dt); return dt; }
public void SuaThongTin_KieuDang() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "KieuDang_Update"; cmd.Parameters.Add("@MaKieuDang", SqlDbType.VarChar).Value = Kieudang.MaKieuDang; cmd.Parameters.Add("@TenKieuDang", SqlDbType.NVarChar).Value = Kieudang.TenKieuDang; cmd.ExecuteNonQuery(); }
public string LayID() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DonHang_MaxID"; string st = cmd.ExecuteScalar().ToString(); return(st); }
public void Themdulieu() { Ketnoi connectString = new Ketnoi(); SqlConnection connect = new SqlConnection(connectString.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "NhaSX_Insert"; cmd.Parameters.Add("@MaNSX", SqlDbType.VarChar).Value = nhasx.MaNSX; cmd.Parameters.Add("@TenNSX", SqlDbType.NVarChar).Value = nhasx.TenNSX; cmd.ExecuteNonQuery(); }
public string Get_Pass() { string str = ""; Ketnoi kn = new Ketnoi(); SqlConnection con = new SqlConnection(kn.ConnectionString()); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.CommandText = "GetPassByEmail"; cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = NgDung.Email; str = cmd.ExecuteScalar().ToString(); return(str); }
public DataTable table_NguoiDung() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandText = "NguoiDung_SelectEmail_Hoten"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Email",SqlDbType.VarChar).Value=this.Nguoidung.Email; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; DataTable dt = new DataTable(); adapter.Fill(dt); return dt; }
public DataTable table() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "ThongTinSanPham_SelectPC"; cmd.Parameters.Add("@MaPhongCach",SqlDbType.VarChar).Value=thongtinsanpham.MaPhongCach; DataTable dt = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(dt); return dt; }
public DataTable ketqua() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandText = "SanPham_Search"; cmd.Parameters.Add("@Search",SqlDbType.NVarChar).Value=Ttsanpham.TenSanPham; cmd.CommandType = CommandType.StoredProcedure; DataTable dt = new DataTable(); SqlDataAdapter adpter = new SqlDataAdapter(); adpter.SelectCommand = cmd; adpter.Fill(dt); return dt; }
public void Update_Donhang() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DonHang_Update"; cmd.Parameters.Add("@MaDonHang", SqlDbType.Int).Value = Donhang.MaDonHang; cmd.Parameters.Add("@NgayChuyen", SqlDbType.DateTime).Value = Donhang.NgayChuyen; cmd.Parameters.Add("@TinhTrang", SqlDbType.NVarChar).Value = Donhang.TinhTrang; cmd.ExecuteNonQuery(); }
public DataTable GetTinRaoVat() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "TinRaoVat_SelectAll"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = connect; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; DataTable dt = new DataTable(); adapter.Fill(dt); return dt; }
public void Them_DonHang() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DonHang_Insert"; cmd.Parameters.Add("@Email",SqlDbType.VarChar).Value=Donhang.Email; cmd.Parameters.Add("@NgayDatHang",SqlDbType.DateTime).Value=Donhang.NgayDatHang; cmd.Parameters.Add("@NgayYeuCau",SqlDbType.DateTime).Value=Donhang.NgayYeuCau; //cmd.Parameters.Add("@NgayChuyen",SqlDbType.DateTime).Value=Donhang.NgayChuyen; cmd.Parameters.Add("@DiaChiNhan",SqlDbType.NVarChar).Value=Donhang.DiaChiNhan; cmd.ExecuteNonQuery(); }
public void Them_GioHang() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GioHang_Insert"; cmd.Parameters.Add("@MaSanPham",SqlDbType.Int).Value=Giohang.MaSanPham; cmd.Parameters.Add("@MaDonHang",SqlDbType.Int).Value=Giohang.MaDonHang; cmd.Parameters.Add("@DonGia",SqlDbType.Int).Value=Giohang.DonGia; cmd.Parameters.Add("@SoLuong",SqlDbType.Int).Value=Giohang.SoLuong; cmd.Parameters.Add("@TongTien",SqlDbType.Int).Value=Giohang.TongTien; cmd.ExecuteNonQuery(); }
public DataTable Laydulieu() { DataTable dt = new DataTable(); Ketnoi kn = new Ketnoi(); SqlCommand cmd = new SqlCommand(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DangNhap_Select"; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(dt); return(dt); }
public DataTable Lay_table() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "ThongTinSanPham_SelectAll"; DataTable dt = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(dt); return(dt); }
public DataTable table() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "ThongTinSanPham_SelectByMaNSX"; cmd.Parameters.Add("@MaNSX", SqlDbType.VarChar).Value = this.MaNSX.MaNSX; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; DataTable dt = new DataTable(); adapter.Fill(dt); connect.Close(); return dt; }
public void Themdulieu() { Ketnoi ketnoi = new Ketnoi(); SqlConnection connect = new SqlConnection(ketnoi.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "NguoiDung_Insert"; cmd.Parameters.Add("@MaKieuNguoiDung", SqlDbType.Int).Value = nguoidung.MaKieuNguoiDung; cmd.Parameters.Add("@HoTen",SqlDbType.NVarChar).Value=nguoidung.HoTen; cmd.Parameters.Add("@DiaChi", SqlDbType.NVarChar).Value = nguoidung.DiaChi; cmd.Parameters.Add("@SoDT", SqlDbType.VarChar).Value = nguoidung.SoDT; cmd.Parameters.Add("@SoFax", SqlDbType.VarChar).Value = nguoidung.SoFax; cmd.Parameters.Add("@Email",SqlDbType.VarChar).Value=nguoidung.Email; cmd.Parameters.Add("@MatKhau", SqlDbType.VarChar).Value = nguoidung.MatKhau; cmd.ExecuteNonQuery(); }
public void Suathongtin() { Ketnoi ketnoi = new Ketnoi(); SqlConnection connect = new SqlConnection(ketnoi.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "NguoiDung_Update"; cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = Nguoidung.Email.ToString(); cmd.Parameters.Add("@MatKhau",SqlDbType.VarChar).Value=Nguoidung.MatKhau.ToString(); cmd.Parameters.Add("@HoTen",SqlDbType.NVarChar).Value=Nguoidung.HoTen.ToString(); cmd.Parameters.Add("@DiaChi",SqlDbType.NVarChar).Value=Nguoidung.DiaChi.ToString(); cmd.Parameters.Add("@SoDT", SqlDbType.VarChar).Value = Nguoidung.SoDT.ToString(); cmd.Parameters.Add("@SoFax",SqlDbType.VarChar).Value=Nguoidung.SoFax.ToString(); cmd.Parameters.Add("@MaKieuNguoiDung",SqlDbType.Int).Value=Nguoidung.MaKieuNguoiDung; cmd.ExecuteNonQuery(); }
public DataTable ketqua() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandText = "SanPham_Search"; cmd.Parameters.Add("@Search", SqlDbType.NVarChar).Value = Ttsanpham.TenSanPham; cmd.CommandType = CommandType.StoredProcedure; DataTable dt = new DataTable(); SqlDataAdapter adpter = new SqlDataAdapter(); adpter.SelectCommand = cmd; adpter.Fill(dt); return(dt); }
public void Them_GioHang() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GioHang_Insert"; cmd.Parameters.Add("@MaSanPham", SqlDbType.Int).Value = Giohang.MaSanPham; cmd.Parameters.Add("@MaDonHang", SqlDbType.Int).Value = Giohang.MaDonHang; cmd.Parameters.Add("@DonGia", SqlDbType.Int).Value = Giohang.DonGia; cmd.Parameters.Add("@SoLuong", SqlDbType.Int).Value = Giohang.SoLuong; cmd.Parameters.Add("@TongTien", SqlDbType.Int).Value = Giohang.TongTien; cmd.ExecuteNonQuery(); }
public DataTable table() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "ThongTinSanPham_SelectTopn"; cmd.Parameters.Add("@Limit", SqlDbType.VarChar).Value = thongtinsanpham.top; DataTable dt = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; adapter.Fill(dt); return(dt); }
public void Them_DonHang() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DonHang_Insert"; cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = Donhang.Email; cmd.Parameters.Add("@NgayDatHang", SqlDbType.DateTime).Value = Donhang.NgayDatHang; cmd.Parameters.Add("@NgayYeuCau", SqlDbType.DateTime).Value = Donhang.NgayYeuCau; //cmd.Parameters.Add("@NgayChuyen",SqlDbType.DateTime).Value=Donhang.NgayChuyen; cmd.Parameters.Add("@DiaChiNhan", SqlDbType.NVarChar).Value = Donhang.DiaChiNhan; cmd.ExecuteNonQuery(); }
public DataTable table_NguoiDung() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandText = "NguoiDung_SelectEmail_Hoten"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = this.Nguoidung.Email; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; DataTable dt = new DataTable(); adapter.Fill(dt); return(dt); }
public DataTable GetTinRaoVat() { Ketnoi kn = new Ketnoi(); SqlConnection connect = new SqlConnection(kn.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "TinRaoVat_SelectAll"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = connect; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; DataTable dt = new DataTable(); adapter.Fill(dt); return(dt); }
public void Themdulieu() { Ketnoi ketnoi = new Ketnoi(); SqlConnection connect = new SqlConnection(ketnoi.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "NguoiDung_Insert"; cmd.Parameters.Add("@MaKieuNguoiDung", SqlDbType.Int).Value = nguoidung.MaKieuNguoiDung; cmd.Parameters.Add("@HoTen", SqlDbType.NVarChar).Value = nguoidung.HoTen; cmd.Parameters.Add("@DiaChi", SqlDbType.NVarChar).Value = nguoidung.DiaChi; cmd.Parameters.Add("@SoDT", SqlDbType.VarChar).Value = nguoidung.SoDT; cmd.Parameters.Add("@SoFax", SqlDbType.VarChar).Value = nguoidung.SoFax; cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = nguoidung.Email; cmd.Parameters.Add("@MatKhau", SqlDbType.VarChar).Value = nguoidung.MatKhau; cmd.ExecuteNonQuery(); }
public void Suathongtin() { Ketnoi ketnoi = new Ketnoi(); SqlConnection connect = new SqlConnection(ketnoi.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "NguoiDung_Update"; cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = Nguoidung.Email.ToString(); cmd.Parameters.Add("@MatKhau", SqlDbType.VarChar).Value = Nguoidung.MatKhau.ToString(); cmd.Parameters.Add("@HoTen", SqlDbType.NVarChar).Value = Nguoidung.HoTen.ToString(); cmd.Parameters.Add("@DiaChi", SqlDbType.NVarChar).Value = Nguoidung.DiaChi.ToString(); cmd.Parameters.Add("@SoDT", SqlDbType.VarChar).Value = Nguoidung.SoDT.ToString(); cmd.Parameters.Add("@SoFax", SqlDbType.VarChar).Value = Nguoidung.SoFax.ToString(); cmd.Parameters.Add("@MaKieuNguoiDung", SqlDbType.Int).Value = Nguoidung.MaKieuNguoiDung; cmd.ExecuteNonQuery(); }
public void Themdulieu() { Ketnoi ketnoi = new Ketnoi(); SqlConnection connect = new SqlConnection(ketnoi.ConnectionString()); connect.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connect; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "ThongTinSanPham_Insert"; cmd.Parameters.Add("@MaNSX", SqlDbType.VarChar).Value = ttsanpham.MaNSX; cmd.Parameters.Add("@MaKieuDang",SqlDbType.VarChar).Value=ttsanpham.MaKieuDang; cmd.Parameters.Add("@MaPhongCach",SqlDbType.VarChar).Value=ttsanpham.MaPhongCach; cmd.Parameters.Add("@TenSanPham",SqlDbType.NVarChar).Value=ttsanpham.TenSanPham; cmd.Parameters.Add("@MoTa",SqlDbType.NVarChar).Value=ttsanpham.MoTa; cmd.Parameters.Add("@GiaSanPham",SqlDbType.Int).Value=ttsanpham.GiaSanPham; cmd.Parameters.Add("@ImageSP",SqlDbType.VarChar).Value=ttsanpham.ImageSP; cmd.Parameters.Add("@SoLuong", SqlDbType.Int).Value = ttsanpham.SoLuong; cmd.Parameters.Add("@TenHDH", SqlDbType.NVarChar).Value = ttsanpham.TenHDH; cmd.Parameters.Add("@RAM", SqlDbType.NVarChar).Value = ttsanpham.RAM; cmd.Parameters.Add("@Camera", SqlDbType.NVarChar).Value = ttsanpham.Camera; cmd.Parameters.Add("@Pin", SqlDbType.Int).Value = ttsanpham.Pin; cmd.ExecuteNonQuery(); }