//list Statuss
public List <Statuss> Status()
{
var query = "SELECT * FROM tb_status";
List <Statuss> status = new List <Statuss>();
SqlConnection con = new SqlConnection(Startup.ConnectionString);
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Statuss sta = new Statuss();
if (reader["id"] != DBNull.Value)
{
sta.id = int.Parse(reader["id"].ToString());
}
if (reader["status"] != DBNull.Value)
{
sta.status = reader["status"].ToString();
}
status.Add(sta);
}
return(status);
}
public User getByUserName(string theUserName, Statuss lsStatus)
{
User u = null;
string query = "SELECT user_id, user_name, user_status FROM melenchbot_user WHERE user_name = '" + theUserName + "'";
var reader = this.executeQuery(query);
while (reader != null && reader.Read())
{
u = new User(reader.GetString(1), reader.GetInt32(0), lsStatus.getStatus(reader.GetInt32(2)));
}
if (reader != null)
{
reader.Close();
}
return(u);
}
public Statuss getStatuss()
{
Statuss lsStatus = new Statuss();
string query = "SELECT status_id, status_label FROM melenchbot_status";
var reader = this.executeQuery(query);
while (reader != null && reader.Read())
{
lsStatus.addStatus(new Status(reader.GetString(1), reader.GetInt32(0)));
}
if (reader != null)
{
reader.Close();
}
return(lsStatus);
}
public Users getUsers(Statuss lsStatus)
{
Users lsUsers = new Users();
string query = "SELECT user_id, user_name, user_status FROM melenchbot_user";
var reader = this.executeQuery(query);
while (reader != null && reader.Read())
{
lsUsers.addUser(
new User(
reader.GetString(1),
reader.GetInt32(0),
lsStatus.getStatus(reader.GetInt32(2))
)
);
}
if (reader != null)
{
reader.Close();
}
return(lsUsers);
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new AppDbContext(serviceProvider.GetRequiredService <DbContextOptions <AppDbContext> >())) {
if (!context.Teams.Any())
{
Team teamA = new Team();
teamA.TeamId = 1;
teamA.Name = "a";
teamA.NumeberOfPlayers = 6;
Team teamB = new Team();
teamB.TeamId = 2;
teamB.Name = "b";
teamB.NumeberOfPlayers = 6;
context.Teams.Add(teamA);
context.Teams.Add(teamB);
context.SaveChanges();
}
if (!context.Players.Any())
{
Player playerA = new Player();
playerA.PlayerId = 1;
playerA.Name = "A";
playerA.TeamId = 1;
Player playerA1 = new Player();
playerA1.PlayerId = 2;
playerA1.Name = "A1";
playerA1.TeamId = 1;
Player playerA2 = new Player();
playerA2.PlayerId = 3;
playerA2.Name = "A2";
playerA2.TeamId = 1;
Player playerA3 = new Player();
playerA3.PlayerId = 4;
playerA3.Name = "A3";
playerA3.TeamId = 1;
Player playerA4 = new Player();
playerA4.PlayerId = 5;
playerA4.Name = "A4";
playerA4.TeamId = 1;
Player playerA5 = new Player();
playerA5.PlayerId = 6;
playerA5.Name = "A5";
playerA5.TeamId = 1;
context.Players.Add(playerA);
context.Players.Add(playerA1);
context.Players.Add(playerA2);
context.Players.Add(playerA3);
context.Players.Add(playerA4);
context.Players.Add(playerA5);
Player playerB = new Player();
playerB.PlayerId = 7;
playerB.Name = "B";
playerB.TeamId = 2;
Player playerB1 = new Player();
playerB1.PlayerId = 8;
playerB1.Name = "B1";
playerB1.TeamId = 2;
Player playerB2 = new Player();
playerB2.PlayerId = 9;
playerB2.Name = "B2";
playerB2.TeamId = 2;
Player playerB3 = new Player();
playerB3.PlayerId = 10;
playerB3.Name = "B3";
playerB3.TeamId = 2;
Player playerB4 = new Player();
playerB4.PlayerId = 11;
playerB4.Name = "B4";
playerB4.TeamId = 2;
Player playerB5 = new Player();
playerB5.PlayerId = 12;
playerB5.Name = "B5";
playerB5.TeamId = 2;
context.Players.Add(playerB);
context.Players.Add(playerB1);
context.Players.Add(playerB2);
context.Players.Add(playerB3);
context.Players.Add(playerB4);
context.Players.Add(playerB5);
context.SaveChanges();
}
if (!context.Statusses.Any())
{
Statuss status1 = new Statuss();
status1.StatussId = 1;
status1.Name = "Not started";
Statuss status2 = new Statuss();
status2.StatussId = 2;
status2.Name = "Started";
Statuss status3 = new Statuss();
status3.StatussId = 3;
status3.Name = "Finished";
Statuss status4 = new Statuss();
status4.StatussId = 4;
status4.Name = "Canceled";
context.Statusses.Add(status1);
context.Statusses.Add(status2);
context.Statusses.Add(status3);
context.Statusses.Add(status4);
context.SaveChanges();
}
}
}
public Value GetStatus(Statuss status)
{
return(DataCounter.GetValue(new StringKey(status.ToString(), DataType_Charactor.Status.ToString())));
}
public bool ReduceStatusValue(Statuss status, IntValue value)
{
Key key = new StringKey(status.ToString(), DataType_Charactor.Status.ToString());
return(DataCounter.Reduce(key, value));
}
public void LoadStatus(Statuss status, Value value)
{
DataCounter.Add(new StringKey(status.ToString(), DataType_Charactor.Status.ToString()), value);
}
