/// <summary> /// Split lines into better strings to use and adds them to the currDay /// </summary> /// <param name="line"></param> private void SplitAndAddLoadedEntry(string line) { if (line != null) { string[] splittedLine = line.Split(';'); foreach (Product p in Products) { if (Convert.ToString(p.Id) == splittedLine[0]) { Entry e = new Entry(p, Convert.ToInt32(splittedLine[1]), Convert.ToInt32(splittedLine[2]), Convert.ToInt32(splittedLine[1]) * p.Price); CurrWeek.GetCurrentDayAndAddEntry(e); break; } } } }
/// <summary> /// Loads the entrys of the database /// </summary> /// <param name="weekName">Week name</param> /// <param name="dayId">Id of the day</param> public void LoadEntry(string weekName, string dayId) { try { string query = "SELECT * FROM entry WHERE 'WeekId' LIKE " + weekName + " AND 'DayId' LIKE " + dayId; CreateConnection(); MySqlCommand commandDatabase = new MySqlCommand(query, _connection) { CommandTimeout = 60 }; _connection.Open(); MySqlDataReader reader = commandDatabase.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { string id = reader.GetString(0); string weekId = reader.GetString(1); //string dayId = reader.GetString(2); //todo check if works with given dayId string productForEntryId = reader.GetString(3); string amount = reader.GetString(4); string amountOnTheHouse = reader.GetString(5); string price = reader.GetString(6); CurrWeek.GetCurrentDayAndAddEntry(new Entry(Convert.ToInt32(id), Convert.ToInt32(weekId), Convert.ToInt32(dayId), Convert.ToInt32(productForEntryId), Convert.ToInt32(amount), Convert.ToInt32(amountOnTheHouse), Convert.ToDouble(price))); } } CloseConnection(); } catch (Exception ex) { SaveErrorMsg(ex); Log(ex.Message); } }