public NV_BaiViet_AnPham_ChiTiet GetById(int id)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_BaiViet_AnPham_getByID", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@id", SqlDbType.VarChar, 10);
pID.Value = id;
myCommand.Parameters.Add(pID);
DataTable dt;
NV_BaiViet_AnPham_ChiTiet model = new NV_BaiViet_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_BaiViet_AnPham_ChiTiet(dt);
}
return(model);
}
}
}
public NV_BaiViet_AnPham_ChiTiet GetByUrl(string url)
{
string sql = "select top 1 *,(select TenAnh from Image i where i.ImageID=bv.HinhAnh) as AnhDaiDien from BaiViet_AnPham bv where Duyet=1 and Url='" + url + "'";
DataTable dt = Sys_Common.getDataByQuery(sql);
NV_BaiViet_AnPham_ChiTiet bv = new NV_BaiViet_AnPham_ChiTiet();
if (dt != null && dt.Rows.Count > 0)
{
bv = new NV_BaiViet_AnPham_ChiTiet(dt);
}
return(bv);
}
public bool Update(NV_BaiViet_AnPham_ChiTiet model)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_BaiViet_AnPham_update", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@BaiVietID", SqlDbType.Int);
pID.Value = model.ID;
myCommand.Parameters.Add(pID);
SqlParameter pTieude = new SqlParameter("@TieuDe", SqlDbType.NVarChar, 500);
pTieude.Value = model.TieuDe;
myCommand.Parameters.Add(pTieude);
SqlParameter pDanhMucChinh = new SqlParameter("@DanhMucChinh", SqlDbType.Int);
pDanhMucChinh.Value = model.DanhMucChinh;
myCommand.Parameters.Add(pDanhMucChinh);
SqlParameter pDanhMuc = new SqlParameter("@DanhMuc", SqlDbType.NVarChar, 500);
pDanhMuc.Value = model.DanhMuc;
myCommand.Parameters.Add(pDanhMuc);
//SqlParameter pNgayxuatban = new SqlParameter("@NgayXuatBan", SqlDbType.DateTime);
//pNgayxuatban.Value = model.NgayXuatBan;
//myCommand.Parameters.Add(pNgayxuatban);
SqlParameter pNoidung = new SqlParameter("@NoiDung", SqlDbType.NText);
pNoidung.Value = model.NoiDung;
myCommand.Parameters.Add(pNoidung);
SqlParameter pFile = new SqlParameter("@File", SqlDbType.NVarChar, 500);
pFile.Value = model.File;
myCommand.Parameters.Add(pFile);
SqlParameter pHinhanh = new SqlParameter("@HinhAnh", SqlDbType.NVarChar, 250);
pHinhanh.Value = model.HinhAnh;
myCommand.Parameters.Add(pHinhanh);
SqlParameter pMetaKeyword = new SqlParameter("@MetaKeyword", SqlDbType.NVarChar, 200);
pMetaKeyword.Value = model.MetaKeyword;
myCommand.Parameters.Add(pMetaKeyword);
SqlParameter pMetadescription = new SqlParameter("@MetaDescription", SqlDbType.NVarChar, 500);
pMetadescription.Value = model.MetaDescription;
myCommand.Parameters.Add(pMetadescription);
SqlParameter pPagetitle = new SqlParameter("@PageTitle", SqlDbType.NVarChar, 200);
pPagetitle.Value = model.PageTitle;
myCommand.Parameters.Add(pPagetitle);
SqlParameter pGioiThieu = new SqlParameter("@GioiThieu", SqlDbType.NText);
pGioiThieu.Value = model.GioiThieu;
myCommand.Parameters.Add(pGioiThieu);
SqlParameter pDisanID = new SqlParameter("@DiSanID", SqlDbType.Int);
pDisanID.Value = model.DiSanID;
myCommand.Parameters.Add(pDisanID);
SqlParameter pHoatDongID = new SqlParameter("@HoatDongID", SqlDbType.Int);
pHoatDongID.Value = model.HoatDongID;
myCommand.Parameters.Add(pHoatDongID);
SqlParameter pUrl = new SqlParameter("@Url", SqlDbType.NVarChar, 250);
pUrl.Value = model.Url;
myCommand.Parameters.Add(pUrl);
SqlParameter pDuyet = new SqlParameter("@Duyet", SqlDbType.Bit);
pDuyet.Value = model.Duyet;
myCommand.Parameters.Add(pDuyet);
SqlParameter pNoiBat = new SqlParameter("@NoiBat", SqlDbType.Bit);
pNoiBat.Value = model.NoiBat;
myCommand.Parameters.Add(pNoiBat);
SqlParameter pStt = new SqlParameter("@Stt", SqlDbType.Int);
pStt.Value = model.Stt;
myCommand.Parameters.Add(pStt);
SqlParameter pTonTai = new SqlParameter("@TonTai", SqlDbType.Bit);
pTonTai.Value = model.TonTai;
myCommand.Parameters.Add(pTonTai);
SqlParameter pLang = new SqlParameter("@Lang", SqlDbType.VarChar, 10);
pLang.Value = model.Lang;
myCommand.Parameters.Add(pLang);
//SqlParameter pNguoiTao = new SqlParameter("@NguoiTao", SqlDbType.Int);
//pNguoiTao.Value = model.NguoiTao;
//myCommand.Parameters.Add(pNguoiTao);
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}
}
}