public static void NormalizeDescriptions(List <ExpensesIncomes> e) { for (int i = 0; i < e.Count; i++) { ExpensesIncomes expenseNormalize = e[i]; while (expenseNormalize.description.Contains(" ")) { expenseNormalize.description = e[i].description.Replace( " ", " "); } expenseNormalize.description = expenseNormalize.description.Trim(); if (expenseNormalize.description.CompareTo( expenseNormalize.description.ToUpper()) == 0) { expenseNormalize.description = expenseNormalize.description.ToLower(); StringBuilder description = new StringBuilder( expenseNormalize.description); description[0] = Char.ToUpper(description[0]); expenseNormalize.description = Convert.ToString( description); } e[i] = expenseNormalize; } Console.WriteLine("Descriptions are normalized"); }
public static void Main() { List <ExpensesIncomes> e = new List <ExpensesIncomes>(); string[] options = { "Add new Expense", "Show records for category and dates","Search Expense", "Modify record", "Delete record", "Sort records", "Normalize descriptions" }; char option; SQLiteCommand cmd; SQLiteConnection conexion; if (!File.Exists("home.sqlite")) { conexion = new SQLiteConnection ("Data Source=home.sqlite;Version=3;New=True;Compress=True;"); conexion.Open(); string creacion = "create table home (" + "id int primary key, fecha varchar(30),descripcion varchar(50),categoria varchar(25),cantidad int);"; cmd = new SQLiteCommand(creacion, conexion); int cantidad = cmd.ExecuteNonQuery(); } else { conexion = new SQLiteConnection ("Data Source=home.sqlite;Version=3;New=True;Compress=True;"); conexion.Open(); string selectAll = "select * from home"; cmd = new SQLiteCommand(selectAll, conexion); SQLiteDataReader leer = cmd.ExecuteReader(); while (leer.Read()) { ExpensesIncomes ee = new ExpensesIncomes(); ee.id = Convert.ToInt32(leer[0]); ee.date = leer[1].ToString(); ee.description = leer[2].ToString(); ee.category = leer[3].ToString(); ee.amount = Convert.ToInt32(leer[4]); e.Add(ee); } } do { Console.WriteLine("MENU"); for (int i = 0; i < options.Length; i++) { Console.WriteLine("{0}. {1}", i + 1, options[i]); } Console.WriteLine("T. Exit"); Console.Write("Select Option: "); option = Convert.ToChar(Console.ReadLine()); switch (option) { case 'T': Console.WriteLine("Good Bye!!!"); break; case '1': AddExpense(e); break; case '2': ShowRecords(e); break; case '3': SearchExpense(e); break; case '4': ModifyRecord(e); break; case '5': DeleteRecord(e); break; case '6': SortRecord(e); break; case '7': NormalizeDescriptions(e); break; default: Console.WriteLine("Unknown option"); break; } Console.WriteLine(); } while (option != 'T'); string clearDB = "delete from home;"; cmd = new SQLiteCommand(clearDB, conexion); cmd.ExecuteNonQuery(); foreach (ExpensesIncomes ee in e) { string insertar = "insert into home " + "values (" + ee.id + ",'" + ee.date + "','" + ee.description + "','" + ee.category + "'," + ee.amount + ");"; cmd = new SQLiteCommand(insertar, conexion); cmd.ExecuteNonQuery(); } conexion.Close(); }