public bool update(NV_Document_ChiTiet model)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_Document_update", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@DocumentID", SqlDbType.Int);
pID.Value = model.DocumentID;
myCommand.Parameters.Add(pID);
SqlParameter pTenAnh = new SqlParameter("@TenTaiLieu", SqlDbType.NVarChar, 300);
pTenAnh.Value = model.TenTaiLieu;
myCommand.Parameters.Add(pTenAnh);
SqlParameter pDanhMuc = new SqlParameter("@DanhMuc", SqlDbType.Int);
pDanhMuc.Value = model.DanhMuc;
myCommand.Parameters.Add(pDanhMuc);
SqlParameter pNgayTao = new SqlParameter("@NgayTao", SqlDbType.DateTime);
pNgayTao.Value = model.NgayTao;
myCommand.Parameters.Add(pNgayTao);
SqlParameter pFile = new SqlParameter("@File", SqlDbType.NVarChar, 300);
pFile.Value = model.File;
myCommand.Parameters.Add(pFile);
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}
}
}
public NV_Document_ChiTiet GetById(int id)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_Document_getByID", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@id", SqlDbType.Int);
pID.Value = id;
myCommand.Parameters.Add(pID);
NV_Document_ChiTiet model = new NV_Document_ChiTiet();
DataTable dt;
myConnection.Open();
using (SqlDataAdapter mData = new SqlDataAdapter(myCommand))
{
dt = new DataTable();
mData.Fill(dt);
}
if (dt != null && dt.Rows.Count > 0)
{
model.DocumentID = id;
model.TenTaiLieu = dt.Rows[0]["TenTaiLieu"].ToString();
try
{
model.NgayTao = Convert.ToDateTime(dt.Rows[0]["NgayTao"].ToString());
}
catch { }
model.DanhMuc = int.Parse(dt.Rows[0]["DanhMuc"].ToString());
model.File = dt.Rows[0]["File"].ToString();
}
return(model);
}
}
}
