/// <summary> /// Readers to error descriptor. /// </summary> /// <param name="Reader">The reader.</param> /// <returns>get ErrorDescriptor from reader and return it</returns> private _s_Utils_ErrosHandling.ErrorDescriptor ReaderToErrorDescriptor(SQLiteDataReader Reader) { _s_Utils_ErrosHandling.ErrorDescriptor suee = new _s_Utils_ErrosHandling.ErrorDescriptor(); suee.MethodName = Reader["MethodName"].ToString(); suee.ExeptionMessage = Reader["ExeptionMessage"].ToString(); suee.DateOfError = DateTime.Parse(Reader["DateOfError"].ToString()); return(suee); }
/// <summary> /// Adds the error to database. /// </summary> /// <param name="ErrorDescriptor">The error descriptor.</param> public void AddErrorToDB(_s_Utils_ErrosHandling.ErrorDescriptor ErrorDescriptor) { SQLiteCommand cmd = new SQLiteCommand(dbConnection); cmd.CommandType = CommandType.Text; cmd.CommandText = "insert into ErrorList (MethodName,ExeptionMessage,DateOfError) values (@MethodName,@ExeptionMessage,@DateOfError)"; cmd.Parameters.Add("MethodName", DbType.String).Value = ErrorDescriptor.MethodName; cmd.Parameters.Add("ExeptionMessage", DbType.String).Value = ErrorDescriptor.ExeptionMessage; cmd.Parameters.Add("DateOfError", DbType.DateTime).Value = ErrorDescriptor.DateOfError; cmd.ExecuteNonQuery(); }