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); } } } }