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