public NV_NoiLuuTru_ChiTiet GetById(int id)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_NoiLuuTru_getByID", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@ID", SqlDbType.Int);
pID.Value = id;
myCommand.Parameters.Add(pID);
DataTable dt;
NV_NoiLuuTru_ChiTiet model = new NV_NoiLuuTru_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_NoiLuuTru_ChiTiet(dt.Rows[0]);
}
return(model);
}
}
}
public bool update(NV_NoiLuuTru_ChiTiet model)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_NoiLuuTru_update", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@ID", SqlDbType.Int);
pID.Value = model.ID;
myCommand.Parameters.Add(pID);
SqlParameter pTen = new SqlParameter("@Ten", SqlDbType.NVarChar, 200);
pTen.Value = model.Ten;
myCommand.Parameters.Add(pTen);
SqlParameter pEngName = new SqlParameter("@EngName", SqlDbType.NVarChar, 200);
pEngName.Value = model.EngName;
myCommand.Parameters.Add(pEngName);
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);
SqlParameter pThuocXa = new SqlParameter("@ThuocXa", SqlDbType.VarChar, 10);
pThuocXa.Value = model.ThuocXa;
myCommand.Parameters.Add(pThuocXa);
SqlParameter pDienThoai = new SqlParameter("@DienThoai", SqlDbType.NVarChar, 50);
pDienThoai.Value = model.DienThoai;
myCommand.Parameters.Add(pDienThoai);
SqlParameter pFax = new SqlParameter("@Fax", SqlDbType.NVarChar, 50);
pFax.Value = model.Fax;
myCommand.Parameters.Add(pFax);
SqlParameter pWebsite = new SqlParameter("@Website", SqlDbType.NVarChar, 200);
pWebsite.Value = model.Website;
myCommand.Parameters.Add(pWebsite);
SqlParameter pDiaChiCuThe = new SqlParameter("@DiaChiCuThe", SqlDbType.NVarChar, 200);
pDiaChiCuThe.Value = model.DiaChiCuThe;
myCommand.Parameters.Add(pDiaChiCuThe);
SqlParameter pEmail = new SqlParameter("@Email", SqlDbType.NVarChar, 50);
pEmail.Value = model.Email;
myCommand.Parameters.Add(pEmail);
SqlParameter pAnhDaiDien = new SqlParameter("@AnhDaiDien", SqlDbType.Int);
pAnhDaiDien.Value = model.AnhDaiDien;
myCommand.Parameters.Add(pAnhDaiDien);
SqlParameter pMoTa = new SqlParameter("@MoTa", SqlDbType.NVarChar, 2000);
pMoTa.Value = model.MoTa;
myCommand.Parameters.Add(pMoTa);
SqlParameter pUrl = new SqlParameter("@Url", SqlDbType.NVarChar, 200);
pUrl.Value = model.Url;
myCommand.Parameters.Add(pUrl);
SqlParameter pLoaiBaoTang = new SqlParameter("@LoaiBaoTang", SqlDbType.Int);
pLoaiBaoTang.Value = model.LoaiBaoTang;
myCommand.Parameters.Add(pLoaiBaoTang);
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}
}
}