public IEnumerable <UserAwardDTO> Load() { using (StreamReader read = new StreamReader(file.FullName)) { string line = null; UserAwardDTO user_award = new UserAwardDTO(); while (true) { line = read.ReadLine(); if (line == "UserAward:") { user_award.UserId = Guid.Parse(read.ReadLine()); user_award.AwardId = Guid.Parse(read.ReadLine()); UsersAwards.Add(user_award); user_award = new UserAwardDTO(); } else { break; } } return(UsersAwards); } }
public UserAwardDTO Get(UserAwardDTO note) { try { return(dal_user_award.Get(note)); } catch (Exception e) { Logger.Logger.WriteLog(e); throw e; } }
public bool Delete(UserAwardDTO note) { try { return(dal_user_award.Delete(note)); } catch (Exception e) { Logger.Logger.WriteLog(e); throw e; } }
public bool Delete(UserAwardDTO note) { using (var connection = new SqlConnection(connectionString)) { var delete_user_award = connection.CreateCommand(); delete_user_award.CommandText = $"DELETE FROM dbo.UserAward WHERE UserId = @UserId AND AwardId = @AwardId"; delete_user_award.Parameters.AddWithValue("@UserId", note.UserId); delete_user_award.Parameters.AddWithValue("@AwardId", note.AwardId); connection.Open(); var result = delete_user_award.ExecuteNonQuery(); return(result > 0); } }
public bool Create(UserAwardDTO note) { using (var connection = new SqlConnection(connectionString)) { var add_award = connection.CreateCommand(); add_award.CommandText = $"INSERT INTO dbo.UserAward (UserId, AwardId) VALUES (@UserId, @AwardId)"; add_award.Parameters.AddWithValue("@UserId", note.UserId); add_award.Parameters.AddWithValue("@AwardId", note.AwardId); connection.Open(); var result = add_award.ExecuteNonQuery(); return(result > 0); } }
public bool Create(UserAwardDTO note) { try { UsersAwards.Add(note); return(true); } catch (Exception e) { Logger.Logger.WriteLog(e); throw new NullReferenceException("нет записи", e); } }
public UserAwardDTO Get(UserAwardDTO user_award) { try { UserAwardDTO temp = new UserAwardDTO(); foreach (var item in UsersAwards) { if (item == user_award) { temp = item; break; } } return(temp); } catch (Exception e) { Logger.Logger.WriteLog(e); throw e; } }
public bool Delete(UserAwardDTO user_award) { try { foreach (var item in UsersAwards) { if (item == user_award) { UsersAwards.Remove(item); break; } } return(true); } catch (Exception e) { Logger.Logger.WriteLog(e); throw new NullReferenceException("нет данной записи", e); } }