// dua vao ma nhan vien de lay ra image nhanvien
#region lấy image dạng byte từ manv
public static byte[] bingImageNV(string manv1)
{
DataTable dt = Ketnoi.getImage(manv1);
byte[] img = (Byte[])dt.Rows[0]["Anh"];
return(img);
}
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();
}
// lay thoi han hop dong tu ten hop dong
#region Lấy thời gian hợp đồng
public static int Laythoigianhopdong(string tenhopdong)
{
string sql = "select * from loaiHD where tenloai =N'" + tenhopdong + "'";
DataTable dt = Ketnoi.ExcecuteQuery(sql);
string thoihan = dt.Rows[0]["thoihan"].ToString();
return(int.Parse(thoihan));
}
public static void Cmb()
{
SqlConnection cs = Ketnoi.Cmb();
SqlDataAdapter da = new SqlDataAdapter("select * from BoPhan", cs);
DataTable dt = new DataTable();
da.Fill(dt);
}
public static DataTable CapMathe()
{
string sql = "select MaSV from DOCGIA";
Ketnoi db = new Ketnoi();
DataTable dt;
dt = db.Taobang(sql);
return(dt);
}
public static DataTable TenTheLoai()
{
string sql = "select TenTheLoai from Theloai";
Ketnoi db = new Ketnoi();
DataTable ds;
ds = db.Taobang(sql);
return(ds);
}
public static DataTable TenNXB()
{
string sql = "select TenNXB from Nhaxuatban";
Ketnoi db = new Ketnoi();
DataTable ds;
ds = db.Taobang(sql);
return(ds);
}
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 static DataTable TenSach()
{
string sql = "select TenSach from Sach";
Ketnoi db = new Ketnoi();
DataTable ds;
ds = db.Taobang(sql);
return(ds);
}
public static DataTable NgayHenTra()
{
string sql = "select NgayTra from Chitietphieumuon";
Ketnoi db = new Ketnoi();
DataTable ds;
ds = db.Taobang(sql);
return(ds);
}
public static DataTable MaSV()
{
string sql = "select MaSV from The";
Ketnoi db = new Ketnoi();
DataTable ds;
ds = db.Taobang(sql);
return(ds);
}
public static DataTable MatheMuon()
{
string sql = "select DISTINCT MaThe from Chitietphieumuon";
Ketnoi db = new Ketnoi();
DataTable ds;
ds = db.Taobang(sql);
return(ds);
}
public static DataTable Sophieu()
{
string sql = "select DISTINCT SoPhieu from Chitietphieumuon";
Ketnoi db = new Ketnoi();
DataTable ds;
ds = db.Taobang(sql);
return(ds);
}
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 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 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;
}
// kiem tra su ton tai
#region Kiểm tra tồn tại
public static bool kiemtraSoHopdongTontai(string sohopdong)
{
DataTable DT = Ketnoi.ExcecuteQuery("SELECT * FROM Hopdong where sohopdong='" + sohopdong + "'");
if (DT.Rows.Count > 0)
{
return(true);
}
return(false);
}
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);
}
// kiem tra su ton tai
#region Kiểm tra bảo hiểm có tồn tại hay không
public static bool kiemtraSobaohiemTontai(string sobaohiem)
{
DataTable DT = Ketnoi.ExcecuteQuery("SELECT * FROM DMBaohiem where sobaohiem='" + sobaohiem + "'");
if (DT.Rows.Count > 0)
{
return(true);
}
return(false);
}
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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_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 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 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_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 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 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 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 = "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 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();
}
