| public static CreateConnectionString ( string host, string user, string password, string database, int port, int minPoolSize, int maxPoolSize, DatabaseType dbType ) : string | ||
| host | string | |
| user | string | |
| password | string | |
| database | string | |
| port | int | |
| minPoolSize | int | |
| maxPoolSize | int | |
| dbType | DatabaseType | |
| return | string | |
private static ConnectionStringSettings CreateConnectionString(IEnumerable <Claim> claims)
{
string dblogin = claims.FirstOrDefault(c => c.Type == "dblogin").Value;
string dbpass = claims.FirstOrDefault(c => c.Type == "dbpass").Value;
string dbname = claims.FirstOrDefault(c => c.Type == "dbname").Value;
return(Database.CreateConnectionString("System.Data.SqlClient", @"MCT-NIELS\DATAMANAGEMENT", dbname, dblogin, dbpass));
}
private static ConnectionStringSettings CreateConnectionString(IEnumerable <Claim> claims)
{
string dblogin = claims.FirstOrDefault(c => c.Type == "dblogin").Value;
string dbpass = claims.FirstOrDefault(c => c.Type == "dbpass").Value;
string dbname = claims.FirstOrDefault(c => c.Type == "dbname").Value;
return(Database.CreateConnectionString("System.Data.SqlClient", @"JONA\DATAMANAGEMENT", Cryptography.Decrypt(dbname), Cryptography.Decrypt(dblogin), Cryptography.Decrypt(dbpass)));
}
private static DbConnection GetConnection(IEnumerable <Claim> claims)
{
string dblogin = claims.FirstOrDefault(c => c.Type == "dblogin").Value;
string dbpass = claims.FirstOrDefault(c => c.Type == "dbpass").Value;
string dbname = claims.FirstOrDefault(c => c.Type == "dbname").Value;
return(Database.GetConnection(Database.CreateConnectionString("System.Data.SqlClient", @"MICHIEL\PROJECT", Cryptography.Decrypt(dbname), Cryptography.Decrypt(dblogin), Cryptography.Decrypt(dbpass))));
}
public static int UpdateAccounts(Transfer t)
{
int rowsaffected = 0;
DbTransaction trans = null;
ConnectionStringSettings con = Database.CreateConnectionString("System.Data.SqlClient", @"MCT-NIELS\DATAMANAGEMENT", DBNAME, DBLOGIN, DBPASS);
try
{
trans = Database.BeginTransaction(con);
string sql = "UPDATE Customer SET Balance=Balance-@Amount WHERE Barcode=@ID";
DbParameter par1 = Database.addParameter(con, "@Amount", t.Receiver.TotalPrice);
DbParameter par2 = Database.addParameter(con, "@ID", t.Sender.Barcode);
rowsaffected += Database.ModifyData(trans, sql, par1, par2);
string sql2 = "INSERT INTO Sales VALUES(@Timestamp,@CustomerID,@RegisterID,@ProductID,@Amount,@TotalPrice)";
DbParameter par3 = Database.addParameter(con, "@Amount", t.Receiver.Amount);
DbParameter par4 = Database.addParameter(con, "@Timestamp", DateConverter.DateTimeToUnixTimestamp(DateTime.Now));
DbParameter par5 = Database.addParameter(con, "@CustomerID", t.Sender.Barcode);
DbParameter par6 = Database.addParameter(con, "@RegisterID", t.Receiver.RegisterId);
DbParameter par7 = Database.addParameter(con, "@ProductID", t.Receiver.ProductId);
DbParameter par8 = Database.addParameter(con, "@TotalPrice", t.Receiver.TotalPrice);
rowsaffected += Database.InsertData(trans, sql2, par3, par4, par5, par6, par7, par8);
trans.Commit();
}
catch (Exception ex)
{
if (trans != null)
{
trans.Rollback();
}
Errorlog er = new Errorlog()
{
Message = "Could not complete transaction",
RegisterId = 5,
Stacktrace = ex.StackTrace,
Timestamp = DateTime.Now,
};
ErrorlogDA.InsertErrorlog(er);
}
finally
{
if (trans != null)
{
Database.ReleaseConnection(trans.Connection);
}
}
return(rowsaffected);
}
public static List <Product> GetProducts()
{
List <Product> lijst = new List <Product>();
string sql = "SELECT * FROM Product";
DbDataReader reader = Database.GetData(Database.GetConnection(Database.CreateConnectionString("System.Data.SqlClient", @"MCT-NIELS\DATAMANAGEMENT", DBNAME, DBLOGIN, DBPASS)), sql);
while (reader.Read())
{
lijst.Add(Create(reader));
}
reader.Close();
return(lijst);
}
public static int InsertErrorlog(Errorlog e)
{
string sql = "INSERT INTO Errorlog VALUES(@RegisterID,@Timestamp,@Message,@Stacktrace)";
DbParameter par1 = Database.addParameter("AdminDB", "@RegisterID", e.RegisterId);
DbParameter par2 = Database.addParameter("AdminDB", "@Timestamp", e.Timestamp.ToString("yyyy-MM-dd HH:mm:ss"));
DbParameter par3 = Database.addParameter("AdminDB", "@Message", e.Message);
DbParameter par4 = Database.addParameter("AdminDB", "@Stacktrace", e.Stacktrace);
try
{
return(Database.InsertData(Database.GetConnection(Database.CreateConnectionString("System.Data.SqlClient", @"MCT-NIELS\DATAMANAGEMENT", DBNAME, DBLOGIN, DBPASS)), sql, par1, par2, par3, par4));
}
catch (Exception)
{
return(0);
}
}
public static int InsertEmployeeRegister(EmployeeRegister er)
{
ConnectionStringSettings con = Database.CreateConnectionString("System.Data.SqlClient", @"MCT-NIELS\DATAMANAGEMENT", DBNAME, DBLOGIN, DBPASS);
string sql = "INSERT INTO Register_Employee VALUES(@RegisterID,@EmployeeID,@From,@Untill)";
DbParameter par1 = Database.addParameter("AdminDB", "@RegisterID", er.RegisterID);
DbParameter par2 = Database.addParameter("AdminDB", "@From", er.From.ToString("yyyy-MM-dd HH:mm:ss"));
DbParameter par3 = Database.addParameter("AdminDB", "@Untill", er.Untill.ToString("yyyy-MM-dd HH:mm:ss"));
DbParameter par4 = Database.addParameter("AdminDB", "@EmployeeID", er.EmployeeID);
try
{
return(Database.InsertData(Database.GetConnection(con), sql, par1, par2, par3, par4));
}
catch (Exception)
{
return(0);
}
}
public static int InsertCustomer(Customer c)
{
string sql = "INSERT INTO Customer VALUES(@CustomerName,@Address,@Picture,@Balance,@Barcode,@Active)";
DbParameter par1 = Database.addParameter("AdminDB", "@CustomerName", c.CustomerName);
DbParameter par2 = Database.addParameter("AdminDB", "@Address", c.Address);
DbParameter par3 = Database.addParameter("AdminDB", "@Picture", c.Picture);
DbParameter par4 = Database.addParameter("AdminDB", "@Balance", c.Balance);
DbParameter par5 = Database.addParameter("AdminDB", "@Barcode", c.Barcode);
DbParameter par6 = Database.addParameter("AdminDB", "@Active", 1);
try
{
return(Database.InsertData(Database.GetConnection(Database.CreateConnectionString("System.Data.SqlClient", @"MCT-NIELS\DATAMANAGEMENT", DBNAME, DBLOGIN, DBPASS)), sql, par1, par2, par3, par4, par5, par6));
}
catch (Exception)
{
return(0);
}
}
private void db_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e)
{
Database db = (Database)sender;
if (db.DBType != Database.eDBTypes.Cassandra && db.DBType != Database.eDBTypes.Couchbase && db.DBType != Database.eDBTypes.MongoDb)
{
if (e.PropertyName == Database.Fields.TNS)
{
if (db.CheckUserCredentialsInTNS())
{
db.SplitUserIdPassFromTNS();
}
}
if (e.PropertyName == Database.Fields.TNS || e.PropertyName == Database.Fields.User || e.PropertyName == Database.Fields.Pass)
{
db.CreateConnectionString();
}
}
}
public static Employee GetEmployeeByName(string name, Organisation org)
{
Employee result = null;
ConnectionStringSettings cs = Database.CreateConnectionString("System.Data.SqlClient", @"IKORE\SQLEXPRESS", Cryptography.Decrypt(org.DbName), Cryptography.Decrypt(org.DbLogin), Cryptography.Decrypt(org.DbPassword));
string sql = "SELECT ID FROM Employee WHERE EmployeeName = @Name";
DbParameter par1 = Database.AddParameter("AdminDB", "@Name", name);
DbDataReader reader = Database.GetData(Database.GetConnection(cs), sql, par1);
while (reader.Read())
{
result = new Employee()
{
ID = Int32.Parse(reader["ID"].ToString())
};
}
reader.Close();
return(result);
}
public static List <Employee> GetEmployees()
{
string DBNAME = Properties.Settings.Default.DBNAME;
string DBLOGIN = Properties.Settings.Default.DBLOGIN;
string DBPASS = Properties.Settings.Default.DBPASS;
List <Employee> lijst = new List <Employee>();
string sql = "SELECT * FROM Employee";
try
{
DbDataReader reader = Database.GetData(Database.GetConnection(Database.CreateConnectionString("System.Data.SqlClient", @"MCT-NIELS\DATAMANAGEMENT", DBNAME, DBLOGIN, DBPASS)), sql);
while (reader.Read())
{
Employee c = new Employee();
c.Id = c.Id = int.Parse(reader["ID"].ToString());
c.EmployeeName = reader["EmployeeName"].ToString();
c.Address = reader["Address"].ToString();
c.Email = reader["Email"].ToString();
c.Phone = reader["Phone"].ToString();
c.Active = bool.Parse(reader["Active"].ToString());
//if (!DBNull.Value.Equals(reader["Picture"]))
// c.Picture = (byte[])reader["Picture"];
//else
// c.Picture = new byte[0];
c.Barcode = Int64.Parse(reader["Barcode"].ToString());
lijst.Add(c);
}
reader.Close();
return(lijst);
}
catch (Exception)
{
return(null);
}
}
public static List <Customer> GetCustomers()
{
//ConfigurationManager.ConnectionStrings.Add(CreateConnectionString(claims));
List <Customer> list = new List <Customer>();
string sql = "SELECT * FROM Customer";
try
{ DbDataReader reader = Database.GetData(Database.GetConnection(Database.CreateConnectionString("System.Data.SqlClient", @"MCT-NIELS\DATAMANAGEMENT", DBNAME, DBLOGIN, DBPASS)), sql);
//ConnectionStringSettingsCollection ConnectionStrings = ConfigurationManager.ConnectionStrings;
while (reader.Read())
{
Customer c = new Customer();
c.CustomerName = reader["CustomerName"].ToString();
c.Address = reader["Address"].ToString();
if (!DBNull.Value.Equals(reader["Picture"]))
{
c.Picture = (byte[])reader["Picture"];
}
else
{
c.Picture = new byte[0];
}
c.Balance = Double.Parse(reader["Balance"].ToString());
c.Barcode = Int64.Parse(reader["BarCode"].ToString());
c.Active = bool.Parse(reader["Active"].ToString());
list.Add(c);
}
reader.Close();
return(list); }
catch (Exception)
{
return(null);
}
}
public static void Main(string[] args)
{
var startParams = Helper.ParseArgs(args);
// We need an alias here.
if (!startParams.ContainsKey("alias") || startParams["alias"] == null)
{
Shutdown();
}
Alias = startParams["alias"].ToString();
BnetConfig.Initialize("Configs/BnetServer.conf");
Helper.PrintHeader(serverName);
var ServiceDbConnectionString = Database.CreateConnectionString(BnetConfig.BnetServiceDatabaseHost, BnetConfig.BnetServiceDatabaseUser, BnetConfig.BnetServiceDatabasePassword,
BnetConfig.BnetServiceDatabaseDataBase, BnetConfig.BnetServiceDatabasePort, BnetConfig.BnetServiceDatabaseMinPoolSize, BnetConfig.BnetServiceDatabaseMaxPoolSize,
BnetConfig.BnetServiceDatabaseType);
if (!Database.Bnet.Initialize(ServiceDbConnectionString, BnetConfig.BnetServiceDatabaseType))
{
Log.Message(LogTypes.Error, $"Can't connect to Bnet database.");
Shutdown();
}
var dbLogger = new DBLogger();
dbLogger.Initialize(BnetConfig.LogLevel, BnetConfig.LogDatabaseFile != "" ? new LogFile(BnetConfig.LogDirectory, BnetConfig.LogDatabaseFile) : null);
Database.Bnet.SetLogger(dbLogger);
using (ConsoleClient = new ConsolePipeClient(BnetConfig.ConsoleBnetServer, BnetConfig.ConsoleServiceName))
{
IPCPacketManager.DefineMessageHandler();
// Register console to ServerManager and start listening for incoming ipc packets.
ConsoleClient.Send(new RegisterConsole {
Alias = Alias
}).GetAwaiter().GetResult();
ConsoleClient.Process();
using (var BnetServer = new BnetServiceSocketServer(BnetConfig.BnetServiceBindHost, BnetConfig.BnetServiceBindPort, BnetConfig.BnetServiceMaxConnections, 0x4000))
using (var restBnetServer = new RestServiceSocketServer(BnetConfig.RestServiceBindHost, BnetConfig.RestServiceBindPort, BnetConfig.RestServiceMaxConnections, 0x4000))
{
if (BnetServer.Start())
{
Log.Message(LogTypes.Info, $"Bnet connection listening on '{BnetConfig.BnetServiceBindHost}:{BnetConfig.BnetServiceBindPort}'.");
}
if (restBnetServer.Start())
{
Log.Message(LogTypes.Info, $"Bnet challenge connection listening on '{BnetConfig.RestServiceBindHost}:{BnetConfig.RestServiceBindPort}'.");
}
if (BnetServer.IsListening && restBnetServer.IsListening)
{
Manager.ServicePacket.Initialize();
Manager.RestPacket.Initialize();
CommandManager.InitializeCommands();
Log.Message(LogTypes.Success, $"{serverName} successfully started.");
CommandManager.StartCommandHandler();
}
}
}
}
private static DbConnection GetConnection()
{
return(Database.GetConnection(Database.CreateConnectionString("System.Data.SqlClient", @"MICHIEL\PROJECT", "Admin", "AdminConnection", "P@ssw0rd")));
}
public static void ChangeConnectionString(string provider, string server, string database, string username, string password)
{
ConnectionString = Database.CreateConnectionString(provider, server, database, username, password);
}
