public bool Insert(string maSP, string manHinh, string ram, string oCung, string chip, string heDieuHanh, string dungLuongPin, ref string err)
{
string sqlString = "Insert Into CHITIET_LAPTOP Values(" + "N'" + maSP + "',N'" + manHinh + "',N'"
+ ram + "','" + oCung + "','" + chip + "','" + heDieuHanh + "','" + dungLuongPin + "')";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool Insert(string maSP, string khachHang, DateTime ngayMua, int soLuong, ref string err)
{
string sqlString = "Insert Into CHITIET_HOADON Values(" + "N'" + maSP + "','" + khachHang + "','"
+ ngayMua + "','" + soLuong + "')";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool Insert(string maSP, string nxb, DateTime ngayXB, int soTrang, string loaiBia, string dichGia, ref string err)
{
string sqlString = "Insert Into CHITIET_SACH Values(" + "N'" + maSP + "',N'" + nxb + "',N'"
+ ngayXB + "','" + soTrang + "','" + loaiBia + "','" + dichGia + "')";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool Insert(string maSP, string khachHang, DateTime ngayComment, string noiDung, int rate, ref string err)
{
string sqlString = "Insert Into COMMENT Values(" + "N'" + maSP + "','" + khachHang + "','"
+ ngayComment + "','" + noiDung + "','" + rate + "')";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool Insert(string maSP, string mau, float dungTichxang, int dungTichXilanh, string loai, ref string err)
{
string sqlString = "Insert Into CHITIET_XE Values(" + "N'" + maSP + "',N'" + mau + "',N'"
+ dungTichxang + "','" + dungTichXilanh + "','" + loai + "')";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool Insert(string maSP, string mauSac, string size, string kieuDang, string chatLieu, ref string err)
{
string sqlString = "Insert Into CHITIET_THOITRANG Values(" + "N'" + maSP + "',N'" + mauSac + "',N'"
+ size + "','" + kieuDang + "','" + chatLieu + "')";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool Insert(string loai, byte[] img, ref string err)
{
string sqlString = "Insert Into CATEGORY_SACH(Loai, Image) VALUES (@id,@img)";
db.AddParameters("@id", SqlDbType.NChar, loai);
db.AddParameters("@img", SqlDbType.Image, img);
return(db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool Insert(string hoTen, string soDT, string email, string password, bool gioitinh,
DateTime ngaySinh, string thanhPho, string quanHuyen, string diaChi, ref string err)
{
string sqlString = "Insert Into CUSTOMER Values(" + "N'" + hoTen + "','" + soDT + "',N'" + email + "','" +
password + "','" + gioitinh + "','" + ngaySinh + "',N'" + thanhPho + "',N'" + quanHuyen + "',N'" + diaChi + "')";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool Insert(string maSP, float manHinh, string camTruoc, string camSau,
bool flash, string ram, string chip, string heDieuHanh,
string dungLuongPin, string sim, string ketNoi, bool NFC, bool FM, ref string err)
{
string sqlString = "Insert Into CHITIET_DIENTHOAI Values(" + "N'" + maSP + "',N'" + manHinh + "',N'" + camTruoc + "','" + camSau
+ "','" + flash + "','" + ram + "','" + chip + "','" + heDieuHanh + "','" + dungLuongPin + "','" + sim + "','"
+ ketNoi + "','" + NFC + "','" + FM + "')";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
public bool Insert(string maSP, string tenSP, string thuongHieu, string loai,
float giaSP, float giaTT, int rate, string idImage,
byte[] image1, byte[] image2, byte[] image3, byte[] image4, DateTime ngayThem, ref string err)
{
//Inert image
string sqlStringImg = "Insert Into HINHANH_XE(IdImage, Image1, Image2, Image3, Image4) VALUES (@id,@img1,@img2,@img3,@img4)";
db.AddParameters("@id", SqlDbType.NChar, maSP);
db.AddParameters("@img1", SqlDbType.Image, image1);
db.AddParameters("@img2", SqlDbType.Image, image2);
db.AddParameters("@img3", SqlDbType.Image, image3);
db.AddParameters("@img4", SqlDbType.Image, image4);
if (!db.MyExecuteNonQuery(sqlStringImg, CommandType.Text, ref err))
{
return(false);
}
string sqlString = "Insert Into XE Values(" + "N'" + maSP + "',N'" + tenSP + "',N'" + thuongHieu + "','" + loai
+ "','" + giaSP + "','" + giaTT + "','" + rate + "','" + idImage + "','" + ngayThem + "')";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err));
}
