public int Insert(TransactionLogsEntity transactionlogs) { int res = 0; bool flag = false; try { var p = Param(transactionlogs); flag = (bool)unitOfWork.ProcedureExecute("ptgroup_InsertTransactionLog", p); if (flag) { res = p.Get <int>("@Id"); } else { res = 0; } } catch (Exception ex) { Logging.PutError(ex.Message, ex); throw; } return(res); }
///Update public bool Update(TransactionLogsEntity transactionlogs) { bool res = false; try { var p = Param(transactionlogs, "edit"); res = (bool)unitOfWork.ProcedureExecute("ptgroup_TransactionLogs_Update", p); return(res); } catch (Exception ex) { Logging.PutError(ex.Message, ex); throw; } }
/// <summary> /// Saves a record to the Employee table. /// </summary> private DynamicParameters Param(TransactionLogsEntity transactionlogs, string action = "add") { var p = new DynamicParameters(); if (action == "add") { p.Add("@Id", dbType: DbType.Int32, direction: ParameterDirection.Output); } else { p.Add("@Id", transactionlogs.Id); } p.Add("@UserId", transactionlogs.UserId); p.Add("@Action", transactionlogs.Action); p.Add("@Link", transactionlogs.Link); p.Add("@Description", transactionlogs.Description); p.Add("@LogDate", transactionlogs.LogDate); return(p); }