/// <summary>
/// Creates a new Log record using async
/// </summary>
public static async Task<int> CreateAsync(LogDO DO)
{
SqlParameter _Date = new SqlParameter("Date", SqlDbType.DateTime);
SqlParameter _Thread = new SqlParameter("Thread", SqlDbType.VarChar);
SqlParameter _Level = new SqlParameter("Level", SqlDbType.VarChar);
SqlParameter _Logger = new SqlParameter("Logger", SqlDbType.VarChar);
SqlParameter _Message = new SqlParameter("Message", SqlDbType.VarChar);
SqlParameter _Exception = new SqlParameter("Exception", SqlDbType.VarChar);
_Date.Value = DO.Date;
_Thread.Value = DO.Thread;
_Level.Value = DO.Level;
_Logger.Value = DO.Logger;
_Message.Value = DO.Message;
_Exception.Value = DO.Exception;
SqlParameter[] _params = new SqlParameter[] {
_Date,
_Thread,
_Level,
_Logger,
_Message,
_Exception
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return await DataCommon.ExecuteScalarAsync("[dbo].[Log_Insert]", _params, pid);
}
/// <summary>
/// Selects Log records by PK
/// </summary>
public static async Task<LogDO[]> GetByPKAsync(Int32 Id)
{
SqlParameter _Id = new SqlParameter("Id", SqlDbType.Int);
_Id.Value = Id;
SqlParameter[] _params = new SqlParameter[] {
_Id
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[Log_GetByPK]", _params, pid);
List<LogDO> objs = new List<LogDO>();
while(sr.Read())
{
LogDO obj = new LogDO();
obj.Id = sr.GetInt32(sr.GetOrdinal("Id"));
obj.Date = sr.GetDateTime(sr.GetOrdinal("Date"));
obj.Thread = sr.GetString(sr.GetOrdinal("Thread"));
obj.Level = sr.GetString(sr.GetOrdinal("Level"));
obj.Logger = sr.GetString(sr.GetOrdinal("Logger"));
obj.Message = sr.GetString(sr.GetOrdinal("Message"));
if (sr.IsDBNull(sr.GetOrdinal("Exception"))) { obj.Exception = null; } else { obj.Exception = sr.GetString(sr.GetOrdinal("Exception")); }
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Deletes a Log record
/// </summary>
public static async Task<int> DeleteAsync(LogDO DO)
{
SqlParameter _Id = new SqlParameter("Id", SqlDbType.Int);
_Id.Value = DO.Id;
SqlParameter[] _params = new SqlParameter[] {
_Id
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return await DataCommon.ExecuteScalarAsync("[dbo].[Log_Delete]", _params, pid);
}
/// <summary>
/// Gets all Log records
/// </summary>
public static LogDO[] GetAll()
{
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[Log_GetAll]", new SqlParameter[] { }, pid);
List<LogDO> objs = new List<LogDO>();
while(sr.Read()){
LogDO obj = new LogDO();
obj.Id = sr.GetInt32(sr.GetOrdinal("Id"));
obj.Date = sr.GetDateTime(sr.GetOrdinal("Date"));
obj.Thread = sr.GetString(sr.GetOrdinal("Thread"));
obj.Level = sr.GetString(sr.GetOrdinal("Level"));
obj.Logger = sr.GetString(sr.GetOrdinal("Logger"));
obj.Message = sr.GetString(sr.GetOrdinal("Message"));
if (sr.IsDBNull(sr.GetOrdinal("Exception"))) { obj.Exception = null; } else { obj.Exception = sr.GetString(sr.GetOrdinal("Exception")); }
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Updates a Log record and returns the number of records affected
/// </summary>
public static int Update(LogDO DO)
{
SqlParameter _Id = new SqlParameter("Id", SqlDbType.Int);
SqlParameter _Date = new SqlParameter("Date", SqlDbType.DateTime);
SqlParameter _Thread = new SqlParameter("Thread", SqlDbType.VarChar);
SqlParameter _Level = new SqlParameter("Level", SqlDbType.VarChar);
SqlParameter _Logger = new SqlParameter("Logger", SqlDbType.VarChar);
SqlParameter _Message = new SqlParameter("Message", SqlDbType.VarChar);
SqlParameter _Exception = new SqlParameter("Exception", SqlDbType.VarChar);
_Id.Value = DO.Id;
_Date.Value = DO.Date;
_Thread.Value = DO.Thread;
_Level.Value = DO.Level;
_Logger.Value = DO.Logger;
_Message.Value = DO.Message;
_Exception.Value = DO.Exception;
SqlParameter[] _params = new SqlParameter[] {
_Id,
_Date,
_Thread,
_Level,
_Logger,
_Message,
_Exception
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return DataCommon.ExecuteScalar("[dbo].[Log_Update]", _params, pid);
}
