public NV_DanhMucDuong_ChiTiet GetById(int id)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_DanhMucDuong_getByID", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@ID", SqlDbType.Int);
pID.Value = id;
myCommand.Parameters.Add(pID);
DataTable dt;
NV_DanhMucDuong_ChiTiet model = new NV_DanhMucDuong_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_DanhMucDuong_ChiTiet(dt);
}
return(model);
}
}
}
public NV_DanhMucDuong_ChiTiet GetByUrl(string url)
{
string sql = "select top 1 * from DanhMucDuong where Url='" + url + "'";
DataTable dt = Sys_Common.getDataByQuery(sql);
NV_DanhMucDuong_ChiTiet menu = new NV_DanhMucDuong_ChiTiet();
if (dt != null && dt.Rows.Count > 0)
{
menu = new NV_DanhMucDuong_ChiTiet(dt);
}
return(menu);
}
public bool update(NV_DanhMucDuong_ChiTiet model)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_DanhMucDuong_update", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@ID", SqlDbType.Int);
pID.Value = model.ID;
myCommand.Parameters.Add(pID);
SqlParameter pTenDuong = new SqlParameter("@TenDuong", SqlDbType.NVarChar, 250);
pTenDuong.Value = model.TenDuong;
myCommand.Parameters.Add(pTenDuong);
SqlParameter pSoHieuDuongBo = new SqlParameter("@SoHieuDuongBo", SqlDbType.NVarChar, 250);
pSoHieuDuongBo.Value = model.SoHieuDuongBo;
myCommand.Parameters.Add(pSoHieuDuongBo);
SqlParameter pChieuDai = new SqlParameter("@ChieuDai", SqlDbType.NVarChar, 250);
pChieuDai.Value = model.ChieuDai;
myCommand.Parameters.Add(pChieuDai);
SqlParameter pDiemDau = new SqlParameter("@DiemDau", SqlDbType.NVarChar, 250);
pDiemDau.Value = model.DiemDau;
myCommand.Parameters.Add(pDiemDau);
SqlParameter pDiemCuoi = new SqlParameter("@DiemCuoi", SqlDbType.NVarChar, 250);
pDiemCuoi.Value = model.DiemCuoi;
myCommand.Parameters.Add(pDiemCuoi);
SqlParameter pMatDuong = new SqlParameter("@MatDuong", SqlDbType.NVarChar, 250);
pMatDuong.Value = model.MatDuong;
myCommand.Parameters.Add(pMatDuong);
SqlParameter pQuyetDinh = new SqlParameter("@QuyetDinh", SqlDbType.NText);
pQuyetDinh.Value = model.QuyetDinh;
myCommand.Parameters.Add(pQuyetDinh);
SqlParameter pDanhNhan = new SqlParameter("@DanhNhan", SqlDbType.NVarChar, 250);
pDanhNhan.Value = model.DanhNhan;
myCommand.Parameters.Add(pDanhNhan);
SqlParameter pTieuSu = new SqlParameter("@TieuSu", SqlDbType.NText);
pTieuSu.Value = model.TieuSu;
myCommand.Parameters.Add(pTieuSu);
SqlParameter pThayDoi = new SqlParameter("@ThayDoi", SqlDbType.NText);
pThayDoi.Value = model.ThayDoi;
myCommand.Parameters.Add(pThayDoi);
SqlParameter pUrl = new SqlParameter("@Url", SqlDbType.NVarChar, 250);
pUrl.Value = model.Url;
myCommand.Parameters.Add(pUrl);
SqlParameter pThuocTinh = new SqlParameter("@ThuocTinh", SqlDbType.VarChar, 10);
pThuocTinh.Value = model.ThuocTinh;
myCommand.Parameters.Add(pThuocTinh);
SqlParameter pThuocHuyen = new SqlParameter("@ThuocHuyen", SqlDbType.VarChar, 10);
pThuocHuyen.Value = model.ThuocHuyen;
myCommand.Parameters.Add(pThuocHuyen);
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}
}
}
