public decimal Update(ToDoInfo todo) { var todoDa = new ToDoDA(); decimal _result = -1; try { _result = todoDa.Update(todo); } catch (Exception ex) { Common.log.Error(ex.ToString()); } return(_result); }
public decimal Update(ToDoInfo todo) { try { OracleParameter paramReturn = new OracleParameter("p_result", OracleDbType.Decimal, ParameterDirection.Output); OracleHelper.ExecuteNonQuery(Common.gConnectString, CommandType.StoredProcedure, "pkg_todo.proc_todo_insert", new OracleParameter("p_type", OracleDbType.Decimal, todo.Type, ParameterDirection.Input), new OracleParameter("p_code", OracleDbType.Decimal, todo.Code, ParameterDirection.Input), new OracleParameter("p_processor_by", OracleDbType.Varchar2, todo.Processor_By, ParameterDirection.Input), new OracleParameter("p_processor_date", OracleDbType.Date, DateTime.Now, ParameterDirection.Input), new OracleParameter("p_status", OracleDbType.Decimal, todo.Status, ParameterDirection.Input), paramReturn); return(Convert.ToDecimal(paramReturn.Value.ToString())); } catch (Exception ex) { NaviCommon.Common.log.Error(ex.ToString()); return(-1); } }