public IEnumerable <T> GetAll() { SqlCommand = $"SELECT * FROM {tableName}"; var result = new List <T>(); using (var SqlConnection = new SqlConnection(ConnectionString)) { SqlConnection.Open(); var command = new SqlCommand(SqlCommand, SqlConnection); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { var weilder = new AwardWeilder { AwardId = (int)reader["Id_Award"], UserId = (int)reader["Id_User"], Id = (int)reader["Id"] }; result.Add((T)weilder); } } } return(result); }
void ActionGiveToManyUsers() { ConsoleKey Key; int AwardId; int[] UserId; AwardWeilder WeilderInfo; do { AwardId = TextGetAwardId(); UserId = TextGetManyUserId(); try { foreach (var item in UserId) { WeilderInfo = new AwardWeilder(); WeilderInfo.AwardId = AwardId; WeilderInfo.UserId = item; WeilderInfo.Id = WeilderInfo.GetNewId(BLL.GetAllAwardWeilders()); BLL.AddAwardWeilder(WeilderInfo); } Console.WriteLine("Succsessfully added"); } catch (ArgumentException e) { Console.WriteLine(e.Message); } finally { Console.WriteLine("Try again? (Press <<Y>>)"); Key = Console.ReadKey().Key; } } while (Key != ConsoleKey.Escape); }
private static AwardWeilder ParseToAwardWeilder(int AwardId, int UserId) { var Weilder = new AwardWeilder { AwardId = AwardId, UserId = UserId }; Weilder.Id = Weilder.GetNewId(Connect().GetAllAwardWeilders()); return(Weilder); }
private AwardWeilder ParseToAwardWeilder(int AwardId, int UserId) { var a = new AwardWeilder { AwardId = AwardId, UserId = UserId }; a.Id = a.GetNewId(Application.GetAllAwardWeilders()); return(a); }
public void AddUser(User user, params Award[] Awards) { var WeilderInfo = new AwardWeilder(); WeilderInfo.UserId = user.Id; AddUser(user); foreach (var item in Awards) { WeilderInfo.AwardId = item.Id; WeilderInfo.Id = WeilderInfo.GetNewId(WeilderManager.GetAll()); AddAwardWeilder(WeilderInfo); } }
public void AddAward(Award award, params User[] Users) { var WeilderInfo = new AwardWeilder(); WeilderInfo.AwardId = award.Id; AddAward(award); foreach (var item in Users) { WeilderInfo.UserId = item.Id; WeilderInfo.Id = WeilderInfo.GetNewId(WeilderManager.GetAll()); AddAwardWeilder(WeilderInfo); } }
public void EditWeilder(AwardWeilder EditedVer) { WeilderManager.Edit(EditedVer); }
public void AddAwardWeilder(AwardWeilder data) { WeilderManager.AddData(data); }