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);
}
static void Main(string[] args)
{
// sample 1 : use static ErrorMessageEvent
ErrorMessageEvent.Raise("Error Message Event", 1, "CODE"); // msg, severity, error code
// sample 2 : create a Trace Message Event instance, fill it then raise from the event source
TraceMessageEvent messageEvent1 = new TraceMessageEvent();
messageEvent1.Message = "Costly Message";
myEventSource.Raise(messageEvent1);
// sample 3 : static one line (which wraps the above code sequence)
TraceMessageEvent.Raise(myEventSource, "Static One Line Message");
// sample 4 : static one line which is raised through the EventSource.Application EventSource.
TraceMessageEvent.Raise("Static One Line Message through the Application event source");
}
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));
}
