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