private ApiLogFile ConvertDataRowToDataModel(DataRow row) { var apiLog = new ApiLogFile(); apiLog.Id = row["log_id"] == DBNull.Value ? 0 : int.Parse(row["log_id"].ToString()); apiLog.Level = row["log_level"] == DBNull.Value ? 0 : int.Parse(row["log_level"].ToString()); apiLog.CreatedOn = row["createdon"] == DBNull.Value ? DateTime.MinValue : DateTime.Parse(row["createdon"].ToString()); apiLog.Data = row["log_data"] == DBNull.Value ? string.Empty : row["log_data"].ToString(); apiLog.User = row["log_user"] == DBNull.Value ? string.Empty : row["log_user"].ToString(); apiLog.Ip = row["log_ip"] == DBNull.Value ? string.Empty : row["log_ip"].ToString(); apiLog.Action = row["log_action"] == DBNull.Value ? string.Empty : row["log_action"].ToString(); return(apiLog); }
public OpertionResult Create(ApiLogFile obj) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_log_data", OracleDbType = OracleDbType.NVarchar2, Value = obj.Data }, new OracleParameter { ParameterName = "v_log_user", OracleDbType = OracleDbType.Varchar2, Value = obj.User }, new OracleParameter { ParameterName = "v_log_ip", OracleDbType = OracleDbType.Varchar2, Value = obj.Ip }, new OracleParameter { ParameterName = "v_log_level", OracleDbType = OracleDbType.Int32, Value = obj.Level }, new OracleParameter { ParameterName = "v_log_action", OracleDbType = OracleDbType.Varchar2, Value = obj.Action } }; #endregion _db.ExecuteStoredProc("pk_infra.fn_create_api_log", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }