public static void PerformDatabaseOperations(string reminder, string date, string time) { CultureInfo provider = CultureInfo.InvariantCulture; using (var db = new ReminderDbContext()) { var Reminder = new ReminderModel { Reminder = reminder, Date = DateTime.ParseExact(date, "mm/dd/yyyy", provider), Time = DateTime.ParseExact( time, "HH.mm.ss", CultureInfo.InvariantCulture ).TimeOfDay }; db.Reminders.Add(Reminder); db.SaveChanges(); } }
public static void UpdateReminder() { Console.WriteLine("Enter the Reminder Id you want to update"); int id = Int32.Parse(Console.ReadLine()); ReminderDbContext reminderDbContext = new ReminderDbContext(); var reminderData = reminderDbContext.Reminders.Find(id); if (reminderData != null) { CultureInfo provider = CultureInfo.InvariantCulture; Console.WriteLine("Enter Reminder..if you dont want to change just give enter"); var reminder = Console.ReadLine(); if (reminder != "") { reminderData.Reminder = reminder; } Console.WriteLine("Enter Reminder Date in the format mm/dd/yyyy..if you dont want to change just give enter"); var date = Console.ReadLine(); if (date != "") { reminderData.Date = DateTime.ParseExact(date, "mm/dd/yyyy", provider); } Console.WriteLine("Enter Reminder Time in the format hh.mm.ss ..if you dont want to change just give enter"); var time = Console.ReadLine(); if (time != "") { reminderData.Time = DateTime.ParseExact( time, "HH.mm.ss", CultureInfo.InvariantCulture ).TimeOfDay; } reminderDbContext.SaveChanges(); Console.WriteLine("Changes are Updated"); ViewReminders(); } else { Console.WriteLine("Id not Found"); } }