public NV_PhanBoKinhPhi_ChiTiet GetById(int id)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_PhanBoKinhPhi_getByID", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@ID", SqlDbType.VarChar, 10);
pID.Value = id;
myCommand.Parameters.Add(pID);
DataTable dt;
NV_PhanBoKinhPhi_ChiTiet model = new NV_PhanBoKinhPhi_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_PhanBoKinhPhi_ChiTiet(dt.Rows[0]);
}
return(model);
}
}
}
public bool update(NV_PhanBoKinhPhi_ChiTiet model)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_PhanBoKinhPhi_update", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@ID", SqlDbType.Int);
pID.Value = model.ID;
myCommand.Parameters.Add(pID);
SqlParameter pTenDuAn = new SqlParameter("@TenDuAn", SqlDbType.NVarChar, 200);
pTenDuAn.Value = model.TenDuAn;
myCommand.Parameters.Add(pTenDuAn);
SqlParameter pNguonID = new SqlParameter("@NguonID", SqlDbType.Int);
pNguonID.Value = model.NguonID;
myCommand.Parameters.Add(pNguonID);
SqlParameter pDiSanID = new SqlParameter("@DiSanID", SqlDbType.Int);
pDiSanID.Value = model.DiSanID;
myCommand.Parameters.Add(pDiSanID);
SqlParameter pSoTien = new SqlParameter("@SoTien", SqlDbType.Decimal, 18);
pSoTien.Value = model.SoTien;
myCommand.Parameters.Add(pSoTien);
SqlParameter pNgayThucHien = new SqlParameter("@NgayThucHien", SqlDbType.DateTime);
pNgayThucHien.Value = model.NgayThucHien;
myCommand.Parameters.Add(pNgayThucHien);
SqlParameter pLyDo = new SqlParameter("@LyDo", SqlDbType.NVarChar, 500);
pLyDo.Value = model.LyDo;
myCommand.Parameters.Add(pLyDo);
SqlParameter pNoiDung = new SqlParameter("@NoiDung", SqlDbType.NText);
pNoiDung.Value = model.NoiDung;
myCommand.Parameters.Add(pNoiDung);
SqlParameter pTaiLieu = new SqlParameter("@TaiLieu", SqlDbType.NVarChar, 50);
pTaiLieu.Value = model.TaiLieu;
myCommand.Parameters.Add(pTaiLieu);
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}
}
}
