public NV_AnPham_ChiTiet GetById(int id)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_AnPham_getByID", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@ID", SqlDbType.Int);
pID.Value = id;
myCommand.Parameters.Add(pID);
DataTable dt;
NV_AnPham_ChiTiet model = new NV_AnPham_ChiTiet();
myConnection.Open();
using (SqlDataAdapter mData = new SqlDataAdapter(myCommand))
{
dt = new DataTable();
mData.Fill(dt);
}
if (dt != null && dt.Rows.Count > 0)
{
model = new NV_AnPham_ChiTiet(dt);
}
return(model);
}
}
}
public NV_AnPham_ChiTiet GetByUrl(string url)
{
string sql = "select top 1 * from AnPham where Url='" + url + "'";
DataTable dt = Sys_Common.getDataByQuery(sql);
NV_AnPham_ChiTiet bv = new NV_AnPham_ChiTiet();
if (dt != null && dt.Rows.Count > 0)
{
bv = new NV_AnPham_ChiTiet(dt);
}
return(bv);
}
public bool Update(NV_AnPham_ChiTiet model)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_AnPham_update", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@ID", SqlDbType.Int);
pID.Value = model.ID;
myCommand.Parameters.Add(pID);
SqlParameter pLang = new SqlParameter("@Lang", SqlDbType.VarChar, 10);
pLang.Value = model.Lang;
myCommand.Parameters.Add(pLang);
SqlParameter pTenSach = new SqlParameter("@TenSach", SqlDbType.NVarChar, 500);
pTenSach.Value = model.TenSach;
myCommand.Parameters.Add(pTenSach);
SqlParameter pDanhMucID = new SqlParameter("@DanhMucID", SqlDbType.Int);
pDanhMucID.Value = model.DanhMucID;
myCommand.Parameters.Add(pDanhMucID);
SqlParameter pMaSach = new SqlParameter("@MaSach", SqlDbType.VarChar, 20);
pMaSach.Value = model.MaSach;
myCommand.Parameters.Add(pMaSach);
SqlParameter pTacGia = new SqlParameter("@TacGia", SqlDbType.NVarChar, 500);
pTacGia.Value = model.TacGia;
myCommand.Parameters.Add(pTacGia);
SqlParameter pDiSanID = new SqlParameter("@DiSanID", SqlDbType.Int);
pDiSanID.Value = model.DiSanID;
myCommand.Parameters.Add(pDiSanID);
SqlParameter pSoTrang = new SqlParameter("@SoTrang", SqlDbType.Int);
pSoTrang.Value = model.SoTrang;
myCommand.Parameters.Add(pSoTrang);
SqlParameter pGioiThieu = new SqlParameter("@GioiThieu", SqlDbType.NText);
pGioiThieu.Value = model.GioiThieu;
myCommand.Parameters.Add(pGioiThieu);
SqlParameter pKichCo = new SqlParameter("@KichCo", SqlDbType.NVarChar, 50);
pKichCo.Value = model.KichCo;
myCommand.Parameters.Add(pKichCo);
SqlParameter pFileDinhKem = new SqlParameter("@FileDinhKem", SqlDbType.NVarChar, 500);
pFileDinhKem.Value = model.FileDinhKem;
myCommand.Parameters.Add(pFileDinhKem);
SqlParameter pAnhDaiDien = new SqlParameter("@AnhDaiDien", SqlDbType.NVarChar, 200);
pAnhDaiDien.Value = model.AnhDaiDien;
myCommand.Parameters.Add(pAnhDaiDien);
SqlParameter pNhaXB = new SqlParameter("@NhaXB", SqlDbType.NVarChar, 4000);
pNhaXB.Value = model.NhaXB;
myCommand.Parameters.Add(pNhaXB);
SqlParameter pTomTatNoiDung = new SqlParameter("@TomTatNoiDung", SqlDbType.NText);
pTomTatNoiDung.Value = model.TomTatNoiDung;
myCommand.Parameters.Add(pTomTatNoiDung);
SqlParameter pNamXB = new SqlParameter("@NamXB", SqlDbType.Int);
pNamXB.Value = model.NamXB;
myCommand.Parameters.Add(pNamXB);
SqlParameter pUrl = new SqlParameter("@Url", SqlDbType.NVarChar, 200);
pUrl.Value = model.Url;
myCommand.Parameters.Add(pUrl);
SqlParameter pDuyet = new SqlParameter("@Duyet", SqlDbType.Bit);
pDuyet.Value = model.Duyet;
myCommand.Parameters.Add(pDuyet);
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}
}
}