public static bool HoneyHarwestAllTypesDownload(int selectedHoneyTypeID, int selectedYear, out List <HoneyHarwest> actualHarwest) { actualHarwest = new List <HoneyHarwest>(); MySqlConnection connection = ConnectionMaker(false); try { MySqlCommand command = new MySqlCommand(QueriesForHarwest(selectedHoneyTypeID, selectedYear), connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { actualHarwest.Add(new HoneyHarwest(Convert.ToInt32(reader[0]), Convert.ToInt32(reader[1]), Convert.ToDateTime(reader[2]), reader[3].ToString(), Convert.ToInt32(reader[4]))); } connection.Close(); } catch (Exception a) { if (ErrorMessageEvent != null) { ErrorMessageEvent.Invoke(ErrorMessageText(ErrorMessages.HoneyHarwestAllTypesDownload, a.Message)); } return(false); } return(true); }
public static bool HoneyTypesForHarwest(out List <int> honeyTypeIDs) { honeyTypeIDs = new List <int>(); MySqlConnection connection = ConnectionMaker(false); try { MySqlCommand command = new MySqlCommand(SQLQueries.HoneyTypeForHarwest, connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { honeyTypeIDs.Add(Convert.ToInt32(reader[0])); } connection.Close(); } catch (Exception a) { if (ErrorMessageEvent != null) { ErrorMessageEvent.Invoke(ErrorMessageText(ErrorMessages.HoneyTypesForHarwest, a.Message)); } return(false); } return(true); }
public static bool HoneySalesAllTypesDownload(int personID, int honeyTypeId, int selectedYear, int present, out List <HoneyPayment> actualPayments) { actualPayments = new List <HoneyPayment>(); MySqlConnection connection = ConnectionMaker(false); try { MySqlCommand command = new MySqlCommand(HPQueryForPayments(personID, honeyTypeId, selectedYear, present), connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { actualPayments.Add(new HoneyPayment(Convert.ToInt32(reader[0]), Convert.ToInt32(reader[1]), Convert.ToInt32(reader[2]), Convert.ToInt32(reader[3]), Convert.ToInt32(reader[4]), Convert.ToDateTime(reader[5]), Convert.ToInt32(reader[6]))); } connection.Close(); } catch (Exception a) { if (ErrorMessageEvent != null) { ErrorMessageEvent.Invoke(ErrorMessageText(ErrorMessages.HoneySalesAllTypesDownload, a.Message)); } return(false); } return(true); }
public static bool ActualSalesYears(int selectedPersonID, int selectedHoneyTypeID, int present, out List <int> years) { years = new List <int>(); MySqlConnection connection = ConnectionMaker(false); try { MySqlCommand command = new MySqlCommand(YearQueryForActualSalesYears(selectedPersonID, selectedHoneyTypeID, present), connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { years.Add(Convert.ToInt32(reader[0])); } connection.Close(); } catch (Exception a) { if (ErrorMessageEvent != null) { ErrorMessageEvent.Invoke(ErrorMessageText(ErrorMessages.ActualSalesYears, a.Message)); } return(false); } return(true); }
public static bool HoneyTypesForSales(int personID, int present, out List <int> honeyTypeIDs) { honeyTypeIDs = new List <int>(); MySqlConnection connection = ConnectionMaker(false); try { MySqlCommand command = new MySqlCommand(HoneyTypeQueryForPayments(personID, present), connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { honeyTypeIDs.Add(Convert.ToInt32(reader[0])); } connection.Close(); } catch (Exception a) { if (ErrorMessageEvent != null) { ErrorMessageEvent.Invoke(ErrorMessageText(ErrorMessages.HoneyTypesForSales, a.Message)); } return(false); } return(true); }
public static bool SQLPersonSave(string Firstname, string SecondName, string PersonLocation) { MySqlConnection connection = ConnectionMaker(false); try { MySqlCommand command = new MySqlCommand(SQLQueries.PersonSave, connection); connection.Open(); command.Parameters.Add("@FirstName", MySqlDbType.Text); command.Parameters[0].Value = Firstname; command.Parameters.Add("@SecondName", MySqlDbType.Text); command.Parameters[1].Value = SecondName; command.Parameters.Add("@PersonLocation", MySqlDbType.Text); command.Parameters[2].Value = PersonLocation; command.ExecuteNonQuery(); connection.Close(); } catch (Exception a) { if (ErrorMessageEvent != null) { ErrorMessageEvent.Invoke(ErrorMessageText(ErrorMessages.PersonSave, a.Message)); } return(false); } return(true); }
public static bool ActualHarwestYears(int selectedHoneyTypeID, out List <int> harwestYears) { harwestYears = new List <int>(); MySqlConnection connection = ConnectionMaker(false); try { MySqlCommand command = new MySqlCommand(string.Format(SQLQueries.YearHarwHappAll, (selectedHoneyTypeID == 0 ? "" : string.Format(SQLQueries.YearHarwHappByHoneyType, selectedHoneyTypeID))), connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { harwestYears.Add(Convert.ToInt32(reader[0])); } connection.Close(); } catch (Exception a) { if (ErrorMessageEvent != null) { ErrorMessageEvent.Invoke(ErrorMessageText(ErrorMessages.ActualHarwestYears, a.Message)); } return(false); } return(true); }
public static int TableCheck(int table) { Dictionary <int, string> tableNames = new Dictionary <int, string>() { { 0, "persons" }, { 1, "honeytypes" }, { 2, "honeyharwest" }, { 3, "honeypayment" } }; MySqlConnection connection = ConnectionMaker(false); int result = -1; try { using (MySqlCommand command = new MySqlCommand(SQLQueries.TableExist, connection)) { command.Parameters.Add("@DatabaseName", MySqlDbType.Text); command.Parameters[0].Value = Database; command.Parameters.Add("@TableName", MySqlDbType.Text); command.Parameters[1].Value = tableNames[table]; connection.Open(); result = Convert.ToInt32(command.ExecuteScalar()); } } catch (Exception a) { if (ErrorMessageEvent != null) { ErrorMessageEvent.Invoke(ErrorMessageText(ErrorMessages.DatabaseTableCheckConnection, a.Message)); } } return(result); }
public static bool SQLHoneyTypesDownload() { honeyTypes.Clear(); MySqlConnection connection = ConnectionMaker(false); try { MySqlCommand command = new MySqlCommand(SQLQueries.HoneyTypesDownload, connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { honeyTypes.Add(new HoneyType(Convert.ToInt32(reader[0]), reader[1].ToString())); } connection.Close(); } catch (Exception a) { if (ErrorMessageEvent != null) { ErrorMessageEvent.Invoke(ErrorMessageText(ErrorMessages.HoneyTypesDownload, a.Message)); } return(false); } return(true); }
public static int DatabaseCheck() { MySqlConnection connection = ConnectionMaker(true); int result = -1; try { using (MySqlCommand command = new MySqlCommand(SQLQueries.DatabaseExists, connection)) { command.Parameters.Add("@DatabaseName", MySqlDbType.Text); command.Parameters[0].Value = Database; connection.Open(); result = Convert.ToInt32(command.ExecuteScalar()); } } catch (Exception a) { if (ErrorMessageEvent != null) { ErrorMessageEvent.Invoke(ErrorMessageText(ErrorMessages.DatabaseConnection, a.Message)); } } return(result); }
public void RegisterEvents(DiscordRpcClient client) { client.OnReady += (s, args) => OnReady.Invoke(args); client.OnError += (s, args) => OnError.Invoke(args); client.OnPresenceUpdate += (s, args) => OnPresenceUpdate.Invoke(args); client.OnClose += (s, args) => OnClose.Invoke(args); client.OnJoin += (s, args) => OnJoin.Invoke(args); client.OnSpectate += (s, args) => OnSpectate.Invoke(args); client.OnSubscribe += (s, args) => OnSubscribe.Invoke(args); client.OnUnsubscribe += (s, args) => OnUnsubscribe.Invoke(args); client.OnConnectionEstablished += (s, args) => OnConnectionEstablished.Invoke(args); client.OnConnectionFailed += (s, args) => OnConnectionFailed.Invoke(args); }
public async Task Listening(IPAddress addr, int port, CancellationToken cancellationToken) { try { IPEndPoint endPoint = new IPEndPoint(addr, port); Socket listner = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp); listner.Bind(endPoint); listner.Listen(clientsNumber); while (true) { await Task.Run(() => AcceptAsync(listner, cancellationToken), cancellationToken); } } catch (Exception ex) { log.Error(ex.Message); ErrorMessageEvent?.Invoke(this, new ErrorMessageEventArgs(ex.Message)); } }
public static bool SQLHoneyPaymentSave(int PersonID, int HoneyTypeID, int SellingAmount, int SellingPrice, DateTime SellingDate, int Present) { MySqlConnection connection = ConnectionMaker(false); try { MySqlCommand command = new MySqlCommand(SQLQueries.HoneyPayentSave, connection); connection.Open(); command.Parameters.Add("@PersonID", MySqlDbType.Int32); command.Parameters[0].Value = PersonID; command.Parameters.Add("@HoneyTypeID", MySqlDbType.Int32); command.Parameters[1].Value = HoneyTypeID; command.Parameters.Add("@SellingAmount", MySqlDbType.Int32); command.Parameters[2].Value = SellingAmount; command.Parameters.Add("@SellingPrice", MySqlDbType.Int32); command.Parameters[3].Value = SellingPrice; command.Parameters.Add("@SellingDate", MySqlDbType.DateTime); command.Parameters[4].Value = SellingDate; command.Parameters.Add("@Present", MySqlDbType.Int32); command.Parameters[5].Value = Present; command.ExecuteNonQuery(); connection.Close(); } catch (Exception a) { if (ErrorMessageEvent != null) { ErrorMessageEvent.Invoke(ErrorMessageText(ErrorMessages.HoneyPaymentSave, a.Message)); } return(false); } return(true); }
public static bool SQLHoneyHarwestSave(int HoneyTypeID, DateTime HoneyHarwestDateTime, string HoneyHarwestLocation, int HoneyHarwestAmount) { MySqlConnection connection = ConnectionMaker(false); try { MySqlCommand command = new MySqlCommand(SQLQueries.HoneyHarwestSave, connection); connection.Open(); command.Parameters.Add("@HoneyTypeID", MySqlDbType.Int32); command.Parameters[0].Value = HoneyTypeID; command.Parameters.Add("@HoneyHarwestDateTime", MySqlDbType.DateTime); command.Parameters[1].Value = HoneyHarwestDateTime; command.Parameters.Add("@HoneyHarwestLocation", MySqlDbType.Text); command.Parameters[2].Value = HoneyHarwestLocation; command.Parameters.Add("@HoneyHarwestAmount", MySqlDbType.Int32); command.Parameters[3].Value = HoneyHarwestAmount; command.ExecuteNonQuery(); connection.Close(); } catch (Exception a) { if (ErrorMessageEvent != null) { ErrorMessageEvent.Invoke(ErrorMessageText(ErrorMessages.HoneyHarwestSave, a.Message)); } return(false); } return(true); }
private void OnErrorMessageEvent(ErrorMessageEventArgs eventArgs) { ErrorMessageEvent?.Invoke(this, eventArgs); }
private void RaiseErrorMessageEvent(string message) { ErrorMessageEvent?.Invoke(this, new StringEventArgs(message)); }