public async override Task <string> HandleMessage(WebSocketConnection connection, BinaryReader reader) { if (!connection.avatarRequestRateLimiter.TryTakePoints(1)) { connection.SendMessage(new ErrorMessageSender(ErrorMessageSender.AVATAR_REQUEST_RATE_LIMIT)); return(string.Empty); } await base.HandleMessage(connection, reader); Guid userID = ReadMinecraftUUIDFromBinaryReader(reader); byte[] data; using (DatabaseAccessor accessor = new DatabaseAccessor()) { data = await accessor.GetAvatarDataForUser(userID); } if (data == null) { return(string.Empty); } connection.SendMessage(new UserAvatarProvideResponse(userID, data)); return(String.Empty); }
private static bool Prepare() { string CONFIG_JSON_FILE_NAME = @"config\configuration.json"; Config.Instance.Load(new FileInfo(Path.Combine(Config.RootDir, CONFIG_JSON_FILE_NAME))); if (!Config.Instance.IsReady) { Console.WriteLine("Config file loading ng."); return(false); } //Create Database Accessor var settings = Config.Instance.INFO.DBSetting; var accessor = new DatabaseAccessor(settings.Host, settings.DBName, settings.User, settings.Password); //Create Tables string message = string.Empty; if (!CreateTables(accessor, out message)) { Console.WriteLine(message); } TaskManager.Instance.Initial(); if (!TaskManager.Instance.IsReady) { Console.WriteLine("Tasks creating ng."); return(false); } return(true); }
public static void AddTransactionInfo(Payment payment) { if (payment != null && !string.IsNullOrEmpty(payment.transactionid)) { DatabaseAccessor.WriteRecord(payment); } }
public void InitializeEntries_InvalidFile_ReturnsEmptyList() { const string pathToTestFile = "NullOrEmptyFile.json"; var databaseAccessor = new DatabaseAccessor(pathToTestFile); Assert.AreEqual(new List <CalendarEntry>(), databaseAccessor.FetchEntries()); }
protected override RESULT Initial(StringBuilder messager) { var settings = Config.Instance.INFO.DBSetting; accessor = new DatabaseAccessor(settings.Host, settings.DBName, settings.User, settings.Password); logger.Write(TYPE.INFO, "initializing is ok."); return(RESULT.OK); }
public static string[] FindApprovers(KeyValuePair <string, object>[] parameters) { string dbcnn = @"E:\01_Workspace\01_VS\05_WorkFlow\99_Temp\WorkFlow.s3db"; var accessor = new DatabaseAccessor(dbcnn); var dbcontext = new DBContext(accessor); var list = dbcontext.Retrieve <WF_MST_Users>(); return(list.Entities.Select(e => e.ID).ToArray()); }
public void ReturnOneThousandWhenUnitNameIsKilogram() { Mock.Arrange(() => mockedUnitRatio.Ratio).Returns(1000); Mock.Arrange(() => mockedContext.UnitRatio.Find("kilogram")).Returns(mockedUnitRatio); var databaseAccessor = new DatabaseAccessor(mockedContext); var unitRatio = databaseAccessor.GetBaseUnitRatioFromUnitName("kilogram"); Assert.AreEqual(1000, unitRatio); }
public void ReturnPointZeroOneWhenUnitNameIsCentimeter() { Mock.Arrange(() => mockedUnitRatio.Ratio).Returns(.001); Mock.Arrange(() => mockedContext.UnitRatio.Find("centimeter")).Returns(mockedUnitRatio); var databaseAccessor = new DatabaseAccessor(mockedContext); var unitRatio = databaseAccessor.GetBaseUnitRatioFromUnitName("centimeter"); Assert.AreEqual(.001, unitRatio); }
protected Task(string id, Action <string, RESULT> progress) { this.id = id.Trim().ToUpper(); logger = new Logger(this.id, string.Empty); tables = new List <string>(); FProgress = progress; var settings = Config.Instance.INFO.DBSetting; accessor = new DatabaseAccessor(settings.Host, settings.DBName, settings.User, settings.Password); }
//Tries to add an avatar via this user. public async Task <(sbyte, Guid)> TryAddAvatar(byte[] data) { //Max avatars a person can have is 100, no matter what. if (ownedAvatars.Count >= 100) { return(1, Guid.Empty); } //If the avatar is 0 bytes long, ignore it. if (data.Length == 0) { return(2, Guid.Empty); } //If the avatar would be too large to fit into the userdata, cancel. if (totalAvatarSize + data.Length > MAX_USER_DATA_SIZE) { return(3, Guid.Empty); } //Generate new avatar using the data the user provided. Guid newId = Guid.NewGuid(); Avatar newAvatar = new Avatar() { id = newId, nbt = data, hash = Encoding.UTF8.GetString(hasher.ComputeHash(data)), tags = string.Empty }; //Add the avatar to the list of owned avatars ownedAvatars.Add(newId); //Increase avatar size totalAvatarSize += data.Length; using (DatabaseAccessor accessor = new DatabaseAccessor()) { //Build the user update table Dictionary <string, object> userUpdate = new Dictionary <string, object>() { { "total_avatar_size", totalAvatarSize }, { "owned_avatars", GuidListToString(ownedAvatars) } }; //Update the user with the new info for the posted avatar int userUpdateResponse = await accessor.UpdateUser(id, userUpdate); //Post the avatar int avatarPostResponse = await accessor.PostAvatar(newAvatar); } return(0, newId); }
public TableEntityPage(Clause clause, Sort sort, int count, DatabaseAccessor accessor) { if (accessor == null) { throw new Exception("DatabaseAccessor is null."); } Accessor = accessor; PageCount = count > 0 ? count : pagecount; Clause = clause == null ? new Clause(string.Empty) : clause; Sort = sort == null ? new Sort() : sort; }
public override void Initialize() { try { base.Initialize(); ConsoleInterface = new AuthConsole(); ConsoleBase.SetTitle($"#Stump Authentification Server - {Version}"); logger.Info("Initializing Database..."); DBAccessor = new DatabaseAccessor(DatabaseConfiguration); DBAccessor.RegisterMappingAssembly(Assembly.GetExecutingAssembly()); InitializationManager.Initialize(InitializationPass.Database); DBAccessor.Initialize(); logger.Info("Opening Database..."); DBAccessor.OpenConnection(); DataManager.DefaultDatabase = DBAccessor.Database; DataManagerAllocator.Assembly = Assembly.GetExecutingAssembly(); logger.Info("Register Messages..."); MessageReceiver.Initialize(); ProtocolTypeManager.Initialize(); logger.Info("Register Packets Handlers..."); HandlerManager = AuthPacketHandler.Instance; HandlerManager.RegisterAll(Assembly.GetExecutingAssembly()); logger.Info("Register Commands..."); CommandManager.RegisterAll(Assembly.GetExecutingAssembly()); logger.Info("Start World Servers Manager"); WorldServerManager.Instance.Initialize(); logger.Info("Initialize Account Manager"); AccountManager.Instance.Initialize(); logger.Info("Initialize IPC Server.."); IpcHost = new IPCHost(IpcAddress, IpcPort); InitializationManager.InitializeAll(); IsInitialized = true; if (Environment.GetCommandLineArgs().Contains("-maintenance")) { m_maintenanceMode = true; } } catch (Exception ex) { HandleCrashException(ex); Shutdown(); } }
private void btn0_Click(object sender, EventArgs e) { DatabaseAccessor dba = new DatabaseAccessor(); List <SubjectEntry> subjects = dba.BuildSubjectEntryList(); for (int i = 0; i < subjects.Count; i++) { subjects[i].print(); } Form2 Graphs = new Form2(); Graphs.Show(); //this.Close(); }
public async Task SetCurrentAvatar(Guid avatarID) { currentAvatarID = avatarID; using (DatabaseAccessor accessor = new DatabaseAccessor()) { //Build the user update table Dictionary <string, object> userUpdate = new Dictionary <string, object>() { { "current_avatar", currentAvatarID.ToString("N") }, }; //Update the user with the new info for the posted avatar int userUpdateResponse = await accessor.UpdateUser(id, userUpdate); } }
public NailSalonHome() { InitializeComponent(); buttonState = ButtonState.MAIN_PANEL_STATE; serviceButtonList = new List <Button>(); manicureButtonList = new List <Button>(); pedicureButtonList = new List <Button>(); waxButtonList = new List <Button>(); otherButtonList = new List <Button>(); this.Topmost = false; this.Loaded += new RoutedEventHandler(window_Loaded); databaseAccessor = new DatabaseAccessor(); pm = new PrinterConnector(databaseAccessor); mainClass = new BusinessLogic(databaseAccessor, pm); currentEmployee = null; showMainButtonPanel(); }
public static void Initialize() { NLogHelper.DefineLogProfile(true, true); NLogHelper.EnableLogging(); ConnectedClients = new List <SimpleClient>(); logger.Info("Initializing Configuration !"); Config = new XmlConfig(configFilePath); Config.AddAssemblies(AppDomain.CurrentDomain.GetAssemblies().ToDictionary(entry => entry.GetName().Name).Values.ToArray()); if (!File.Exists(configFilePath)) { Config.Create(); logger.Info("Config file created !"); } else { Config.Load(); //Config.Save(); } logger.Info("Loading protocol messages !"); MessageReceiver.Initialize(); logger.Info("Loading handlers !"); PacketManager.Initialize(Assembly.GetExecutingAssembly()); logger.Info("Loading Database !"); DBAccessor = new DatabaseAccessor(DatabaseConfiguration); DBAccessor.RegisterMappingAssembly(Assembly.GetExecutingAssembly()); DBAccessor.Initialize(); DBAccessor.OpenConnection(); DataManagerAllocator.Assembly = System.Reflection.Assembly.GetExecutingAssembly(); DatabaseManager.DefaultDatabase = DBAccessor.Database; logger.Info("Loading database features !"); InitManager = Singleton <InitializationManager> .Instance; InitManager.AddAssemblies(AppDomain.CurrentDomain.GetAssemblies()); InitManager.Initialize(InitializationPass.Database); InitManager.InitializeAll(); }
private void button1_Click(object sender, EventArgs e) { chart1.Show(); DatabaseAccessor dba = new DatabaseAccessor(); List <SubjectEntry> subjects = dba.BuildSubjectEntryList(); List <double> xAxis = new List <double>(); List <double> yAxis = new List <double>(); for (int i = 0; i < subjects.Count; i++) { xAxis.Add(double.Parse(subjects[i].citricAcid)); yAxis.Add(double.Parse(subjects[i].quality)); } chart1.Series.Remove(chart1.Series[0]); chart1.Series.Add(new Series()); chart1.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Point; chart1.Series[0].Name = "Citric Acid"; chart1.Series[0].Points.DataBindXY(xAxis.ToArray(), yAxis.ToArray()); /* * chart1.Show(); * DatabaseAccessor dba = new DatabaseAccessor(); * List<SubjectEntry> subjects = dba.BuildSubjectEntryList(); * * chart1.Series.Remove(chart1.Series[0]); * chart1.Series.Add(new Series()); * for (int i = 0; i < subjects.Count; i++) * { * chart1.Series[0].Points.Add(float.Parse(subjects[i].citricAcid)); * } * * chart1.Series[0].XValueMember = "ID"; * chart1.Series[0].YValueMembers = "Citric Acid"; * chart1.Series[0].Name = "Citric Acid"; * * chart1.ChartAreas[0].RecalculateAxesScale(); */ }
public void Initialize() { Instance = this; GCSettings.LatencyMode = GCSettings.IsServerGC ? GCLatencyMode.Batch : GCLatencyMode.Interactive; NLogHelper.DefineLogProfile(true, true); NLogHelper.EnableLogging(); logger.Info("Initializing Database..."); DBAccessor = new DatabaseAccessor(DatabaseConfiguration); DBAccessor.RegisterMappingAssembly(Assembly.GetExecutingAssembly()); DBAccessor.Initialize(); logger.Info("Opening Database..."); DBAccessor.OpenConnection(); DBAccessor.Database.ExecutingCommand += OnExecutingDBCommand; MessageReceiver.Initialize(); ProtocolTypeManager.Initialize(); HandlerManager = ServerPacketHandler.Instance; HandlerManager.RegisterAll(Assembly.GetExecutingAssembly()); ClientManager.Instance.Initialize(CreateClient); ClientManager.Instance.Start("x.x.x.x", 9250); WebServer.Initialize(); IOTaskPool = new SelfRunningTaskPool(50, "Main TaskPool"); IOTaskPool.CallPeriodically((int)TimeSpan.FromSeconds(10).TotalMilliseconds, KeepSQLConnectionAlive); IOTaskPool.CallPeriodically((int)TimeSpan.FromSeconds(10).TotalMilliseconds, WriteBufferLogs); IOTaskPool.Start(); logger.Info("Server listening at port 9250"); logger.Info("WebServer listening at port 9251"); // TeknoServer server = new TeknoServer("test", "test"); }
public ActionResult Index(ServerLoginDetail detail) { try { if (ModelState.IsValid) { string constr = $"server={detail.ServerName};database=QuanLySinhVien;user id={detail.Username};pwd={detail.Password}"; SqlConnection testConn = new SqlConnection(constr); testConn.Open(); testConn.Close(); DatabaseAccessor.InitDatabase(constr); return(new RedirectResult("/Home")); } } catch (Exception) { ViewBag.ErrorMessage = "Không thể kết nối với server, hãy kiểm tra lại."; } return(View(detail)); }
public void SaveChanges_FileNotExists_CreatesNewFile() { const string pathToTestFile = "TestCalendarEntries.json"; File.Delete(pathToTestFile); var databaseAccessor = new DatabaseAccessor(pathToTestFile); databaseAccessor.SaveChanges(new List <CalendarEntry> { new CalendarEntry { Date = "09/09/20 15:15", Description = "Test" } }); var fileExists = File.Exists(pathToTestFile); Assert.AreEqual(true, fileExists); }
public async override Task <string> HandleMessage(WebSocketConnection connection, BinaryReader reader) { if (!connection.avatarRequestRateLimiter.TryTakePoints(1)) { connection.SendMessage(new ErrorMessageSender(ErrorMessageSender.AVATAR_REQUEST_RATE_LIMIT)); return(string.Empty); } await base.HandleMessage(connection, reader); //Get GUID Guid id = ReadMinecraftUUIDFromBinaryReader(reader); try { //Open connection to database using (DatabaseAccessor dba = new DatabaseAccessor()) { //Get avatar data from the database byte[] avatarData = await dba.GetAvatarData(id); //If the array is empty, there is no data for this avatar. if (avatarData == null) { return("NO AVATAR"); } //Reply with avatar data connection.SendMessage(new AvatarProvideResponse(avatarData)); return("SUCCESS"); } } catch (Exception e) { Logger.LogMessage(e.ToString()); } return("N/A"); }
public override void Initialize() { base.Initialize(); ConsoleInterface = new WorldConsole(); VirtualConsoleInterface = new WorldVirtualConsole(); ConsoleBase.SetTitle($"#Stump World Server - {Version} : {ServerInformation.Name}"); logger.Info("Initializing Database..."); DBAccessor = new DatabaseAccessor(DatabaseConfiguration); DBAccessor.RegisterMappingAssembly(Assembly.GetExecutingAssembly()); foreach (var plugin in PluginManager.Instance.GetPlugins()) { DBAccessor.RegisterMappingAssembly(plugin.PluginAssembly); } InitializationManager.Initialize(InitializationPass.Database); DBAccessor.Initialize(); logger.Info("Opening Database..."); DBAccessor.OpenConnection(); DataManager.DefaultDatabase = DBAccessor.Database; DataManagerAllocator.Assembly = Assembly.GetExecutingAssembly(); DBAccessor.Database.ExecutingCommand += OnExecutingDBCommand; logger.Info("Register Messages..."); MessageReceiver.Initialize(); ProtocolTypeManager.Initialize(); logger.Info("Register Packet Handlers..."); HandlerManager = WorldPacketHandler.Instance; HandlerManager.RegisterAll(Assembly.GetExecutingAssembly()); logger.Info("Register Commands..."); CommandManager.RegisterAll(Assembly.GetExecutingAssembly()); InitializationManager.InitializeAll(); CommandManager.LoadOrCreateCommandsInfo(CommandsInfoFilePath); IsInitialized = true; }
static ReferralCore() { paidIdsMd5 = new HashSet <string>(StringComparer.InvariantCultureIgnoreCase); //add cydia records HashSet <string> paidIds = DatabaseAccessor.GetPaidCydiaCodes(); foreach (string id in paidIds) { string md5 = GetMD5Hash(id); if (!paidIdsMd5.Contains(md5)) { paidIdsMd5.Add(md5); } } //add paypal records foreach (Payment pay in DatabaseAccessor.Mapping.Values) { if (string.Compare(pay.paymentstatus, Constants.successPaymentSatus, true) == 0) { string md5 = GetMD5Hash(pay.code); if (!paidIdsMd5.Contains(md5)) { paidIdsMd5.Add(md5); } } } //add static records foreach (string id in V2Handler.paidDevieIds) { string md5 = GetMD5Hash(id); if (!paidIdsMd5.Contains(md5)) { paidIdsMd5.Add(md5); } } }
public async Task <sbyte> TryDeleteAvatar(Guid avatarID) { //Attempt to remove avatar. if (!ownedAvatars.Remove(avatarID)) { return(1); } //If the avatar is the current avatar ID, clear current avatar. if (avatarID == currentAvatarID) { currentAvatarID = Guid.Empty; } //Push to database. using (DatabaseAccessor accessor = new DatabaseAccessor()) { //Detract from avatar size. int avatarSize = await accessor.GetAvatarSize(avatarID); totalAvatarSize -= avatarSize; //Build the user update table Dictionary <string, object> userUpdate = new Dictionary <string, object>() { { "total_avatar_size", totalAvatarSize }, { "owned_avatars", GuidListToString(ownedAvatars) }, { "current_avatar", currentAvatarID.ToString("N") }, }; //Update the user with the new info after the avatar was deleted int userUpdateResponse = await accessor.UpdateUser(id, userUpdate); //Delete the avatar off the database await accessor.DeleteAvatar(avatarID); } return(0); }
void frm_trade_Load(object sender, EventArgs e) { this.MaximizeBox = false; this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; string ls_msg = string.Empty; var DBAgent = new DatabaseAccessor(); if (DBAgent.ConfigSetting( TaskManager.Instance.Configuration.DatabaseInfoEntity.GetInfoDict(), ref ls_msg) < CoreLib.Foundation.Status.STATUS_READY) { return; } helper = new DBHelper(DBAgent); Fresh(); btn_F1.Click += new EventHandler(btn_F1_Click); btn_F2.Click += new EventHandler(btn_F2_Click); btn_F5.Click += new EventHandler(btn_F5_Click); btn_F10.Click += new EventHandler(btn_F10_Click); }
public void ProcessRequest(HttpContext context) { string msg = ""; TransactionStatus myStatus = TransactionStatus.None; TransactionStatus ourFriendStatus = TransactionStatus.None; string responseMsg = ""; int count = 0; try { string myCode = context.Request.QueryString["code"]; if (!string.IsNullOrEmpty(myCode)) { IphonePackers.AppVerifier verifier = new IphonePackers.AppVerifier(true, false); responseMsg += verifier.GetResponseString(Constants.DefaultAppId, myCode, "", false, out myStatus); if (myStatus == TransactionStatus.Completed) {//save it string md5Hash = ReferralCore.GetMD5Hash(myCode); md5Hash = md5Hash.ToUpper(); count = DatabaseAccessor.GetReferralCount(myCode, md5Hash); } } } catch (Exception e) { msg = e.Message; } context.Response.Write(count); context.Response.StatusCode = 200; context.Response.Cache.SetCacheability(HttpCacheability.NoCache); context.Response.Cache.SetExpires(DateTime.UtcNow); }
public void Initialize() { ConsoleUtils.WriteMessageInfo("Initializing Configuration !"); Config = new XmlConfig(configFilePath); Config.AddAssemblies(AppDomain.CurrentDomain.GetAssemblies().ToDictionary(entry => entry.GetName().Name).Values.ToArray()); if (!File.Exists(configFilePath)) { Config.Create(); ConsoleUtils.WriteMessageInfo("Config file created !"); } else { Config.Load(); } ConsoleUtils.WriteMessageInfo("Loading protocol messages !"); MessageReceiver.Initialize(); ConsoleUtils.WriteMessageInfo("Loading handlers !"); PacketManager.Initialize(Assembly.GetExecutingAssembly()); ConsoleUtils.WriteMessageInfo("Loading Database !"); DBAccessor = new DatabaseAccessor(DatabaseConfiguration); DBAccessor.RegisterMappingAssembly(Assembly.GetExecutingAssembly()); DBAccessor.Initialize(); DBAccessor.OpenConnection(); DataManagerAllocator.Assembly = System.Reflection.Assembly.GetExecutingAssembly(); DatabaseManager.DefaultDatabase = DBAccessor.Database; ConsoleUtils.WriteMessageInfo("Loading database features !"); this.InitManager = Singleton <InitializationManager> .Instance; this.InitManager.AddAssemblies(AppDomain.CurrentDomain.GetAssemblies()); this.InitManager.Initialize(InitializationPass.Database); InitManager.InitializeAll(); }
public async override Task <string> HandleMessage(WebSocketConnection connection, BinaryReader reader) { await base.HandleMessage(connection, reader); Guid id = ReadMinecraftUUIDFromBinaryReader(reader); byte[] getHash; using (DatabaseAccessor accessor = new DatabaseAccessor()) { string s = await accessor.GetAvatarHashForUser(id); if (s == null) { return(string.Empty); } getHash = Encoding.UTF8.GetBytes(s); } connection.SendMessage(new UserAvatarHashProvideResponse(id, getHash)); return(string.Empty); }
protected void Page_Load(object sender, EventArgs e) { //DatabaseAccessor.ReadRecords(); DatabaseAccessor.AddRandomMapping("g", "b"); string urlStr = "http://" + HttpContext.Current.Request.Url.Authority + "/TestSite/PaymentCallBack"; //string urlStr = "http://iphonepackers.info/autosilent1/PaymentCallBack"; HttpWebRequest request = (HttpWebRequest)WebRequest.Create(urlStr); request.Method = "POST"; Stream stream = request.GetRequestStream(); StreamWriter writer = new StreamWriter(stream); writer.Write("mc_gross=3.00&protection_eligibility=Eligible&address_status=unconfirmed&payer_id=QJJ8JA3ED4ZMN&tax=0.00&address_street=VIA+GIULIO+VERITA+N.6&payment_date=09%3A01%3A30+Aug+04%2C+2009+PDT&payment_status=Completed&charset=windows-1252&address_zip=47100&first_name=Ivan&option_selection1=123456789012345678901234567890&mc_fee=0.42&address_country_code=IT&address_name=Ivan+Barrea¬ify_version=2.8&custom=&payer_status=verified&business=ne_hits_luver%40yahoo.co.in&address_country=Italy&address_city=FORLI&quantity=1&verify_sign=AFd.erwt7VoeoUMr85yut0RloHozARtMMo0dpk2w7tZFVZ3PX1DQ83x.&payer_email=info%40alientuning.it&option_name1=purCode&txn_id=27447439TW689393C&payment_type=instant&btn_id=7173571&last_name=Barrea&address_state=Forli&receiver_email=ne_hits_luver%40yahoo.co.in&payment_fee=0.42&shipping_discount=0.00&insurance_amount=0.00&receiver_id=SK4EKN8ZBFQB6&txn_type=web_accept&item_name=Auto+Silent&discount=0.0&mc_currency=USD&item_number=&residence_country=IT&shipping_method=Default&handling_amount=0.00&transaction_subject=Auto+Silent&payment_gross=3.00&shipping=0.00&cmd=_notify-validate"); writer.Close(); stream.Close(); request.GetResponse(); }
public DBTIdxRealtimeDetailEntity(string code, DatabaseAccessor accessor = null) : base(TableName(code), accessor) { }