public static Job GetJob(Guid id)
{
try
{
MyConn.Open();
MySqlCommand cmd =
new MySqlCommand("SELECT j.id, i.title, j.description FROM jobs j WHERE j.id = '" + MySql.Data.MySqlClient.MySqlHelper.EscapeString(id.ToString()) + "'", MyConn);
Job job = null;
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
job = new Job
{
Id = rdr.GetGuid(0),
Title = rdr.GetString(1),
Description = rdr.GetString(2)
};
}
return(job);
}
catch (Exception e)
{
Console.WriteLine($"Oooppss {e.Message}");
return(null);
}
finally
{
MyConn.Close();
}
}
public override Task OnDisconnected()
{
if (Context.User.Identity.IsAuthenticated)
{
string userId = Context.User.Identity.Name;
MyConn conn = new MyConn(userId, MyHubType, Context.ConnectionId);
UserCache.RemoveUserConn(conn);
}
return(base.OnDisconnected());
}
public void Dispose()
{
if (MyTrans != null)
{
MyTrans.Dispose();
MyTrans = null;
}
if (MyConn != null)
{
MyConn.Close();
MyConn.Dispose();
MyConn = null;
}
}
public static Account GetAccount(string username)
{
try
{
MyConn.Open();
MySqlCommand cmd =
new MySqlCommand("SELECT a.id, a.username, a.password, u.id, u.name, u.email FROM account a INNER JOIN user u ON a.fk_user_id = u.id WHERE a.username = '******'", MyConn);
Account account = null;
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
account = new Account
{
Id = rdr.GetGuid(0),
Username = rdr.GetString(1),
Password = rdr.GetString(2),
User = new User
{
Id = rdr.GetGuid(3),
Name = rdr.GetString(4),
Email = rdr.GetString(5)
}
};
}
return(account);
}
catch (Exception e)
{
Console.WriteLine($"Oooppss {e.Message}");
return(null);
}
finally
{
MyConn.Close();
}
}
public static IList <Account> GetAccounts()
{
try
{
MyConn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT a.id, a.username, a.password, u.id, u.name, u.email FROM account a INNER JOIN user u ON a.fk_user_id = u.id", MyConn);
var accounts = new List <Account>();
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
accounts.Add(new Account
{
Id = rdr.GetGuid(0),
Username = rdr.GetString(1),
Password = rdr.GetString(2),
User = new User
{
Id = rdr.GetGuid(3),
Name = rdr.GetString(4),
Email = rdr.GetString(5)
}
});
}
return(accounts);
}
catch (Exception e)
{
Console.WriteLine($"Oooppss {e.Message}");
return(null);
}
finally
{
MyConn.Close();
}
}
public CustomerMySqlTransaction(MySqlConnection connection)
{
this.MyConn = connection;
this.MyConn.Open();
this.MyTrans = MyConn.BeginTransaction();
}
