public NV_VanBan_ChiTiet GetById(int id)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_VanBan_getByID", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@id", SqlDbType.VarChar, 10);
pID.Value = id;
myCommand.Parameters.Add(pID);
DataTable dt;
NV_VanBan_ChiTiet model = new NV_VanBan_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_VanBan_ChiTiet(dt.Rows[0]);
}
return(model);
}
}
}
public bool update(NV_VanBan_ChiTiet model)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_VanBan_update", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@VanBanID", SqlDbType.Int);
pID.Value = model.VanBanID;
myCommand.Parameters.Add(pID);
SqlParameter pTenVanBan = new SqlParameter("@TenVanBan", SqlDbType.NVarChar, 250);
pTenVanBan.Value = model.TenVanBan;
myCommand.Parameters.Add(pTenVanBan);
SqlParameter pLoaiVanBan = new SqlParameter("@LoaiVanBan", SqlDbType.Int);
pLoaiVanBan.Value = model.LoaiVanBan;
myCommand.Parameters.Add(pLoaiVanBan);
SqlParameter pDonViBanHanh = new SqlParameter("@DonViBanHanh", SqlDbType.NVarChar, 200);
pDonViBanHanh.Value = model.DonViBanHanh;
myCommand.Parameters.Add(pDonViBanHanh);
SqlParameter pNgayBanHanh = new SqlParameter("@NgayBanHanh", SqlDbType.DateTime);
pNgayBanHanh.Value = model.NgayBanHanh;
myCommand.Parameters.Add(pNgayBanHanh);
SqlParameter pMoTa = new SqlParameter("@MoTa", SqlDbType.NText);
pMoTa.Value = model.MoTa;
myCommand.Parameters.Add(pMoTa);
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 pDuyet = new SqlParameter("@Duyet", SqlDbType.Bit);
pDuyet.Value = model.Duyet;
myCommand.Parameters.Add(pDuyet);
SqlParameter pTonTai = new SqlParameter("@TonTai", SqlDbType.Bit);
pTonTai.Value = model.TonTai;
myCommand.Parameters.Add(pTonTai);
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}
}
}