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