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