public static List<PhoneLog.Models.PhoneLog> getAllPhoneLogsInRange(DateTime start, DateTime end) { List<PhoneLog.Models.PhoneLog> allLogs = new List<Models.PhoneLog>(); using (var db = new PhoneLog.Models.PhoneLogContext()) { var query = from l in db.PhoneLogs where (l.CallDate.Value.CompareTo(start) >= 0) && (l.CallDate.Value.CompareTo(end) < 0) orderby l.CallDate select l; Console.WriteLine("All logs in the database:"); foreach (var item in query) { allLogs.Add(new Models.PhoneLog { Id = item.Id, CallerName = item.CallerName, CallDate = item.CallDate, PhoneNumber = item.PhoneNumber, EmployeeEmail = item.EmployeeEmail, CallType = item.CallType, FollowedUp = item.FollowedUp, Message = item.Message }); } } return allLogs; }
public static void deletePhoneLog(int id) { using (var db = new PhoneLog.Models.PhoneLogContext()) { var log = db.PhoneLogs.Where(item => item.Id == id).Single(); db.PhoneLogs.Remove(log); db.SaveChanges(); } }
public static List<PhoneLog.Models.PhoneLog> getAllPhoneLogsNotFollowedUp() { List<PhoneLog.Models.PhoneLog> allLogs = new List<Models.PhoneLog>(); using (var db = new PhoneLog.Models.PhoneLogContext()) { var query = from l in db.PhoneLogs where (l.FollowedUp.Value.Equals(false)) orderby l.CallDate select l; Console.WriteLine("All logs in the database:"); foreach (var item in query) { allLogs.Add(new Models.PhoneLog { Id = item.Id, CallerName = item.CallerName, CallDate = item.CallDate, PhoneNumber = item.PhoneNumber, EmployeeEmail = item.EmployeeEmail, CallType = item.CallType, FollowedUp = item.FollowedUp, Message = item.Message }); } } return allLogs; }
public static void updatePhoneLog(int id, string name, DateTime date, string phoneNumber, string message, string employeeEmail, string callType, Boolean followedUp) { using (var db = new PhoneLog.Models.PhoneLogContext()) { Models.PhoneLog log = (from x in db.PhoneLogs where x.Id == id select x).First(); log.Id = id; log.CallerName = name; log.CallDate = date; log.CallType = callType; log.Message = message; log.PhoneNumber = phoneNumber; log.FollowedUp = followedUp; log.EmployeeEmail = employeeEmail; db.SaveChanges(); } }
public static int storePhoneLog(string name, DateTime date, string phoneNumber, string message, string employeeEmail, string callType, Boolean followedUp) { using (var db = new PhoneLog.Models.PhoneLogContext()) { var log = new PhoneLog.Models.PhoneLog{ CallerName = name, CallDate = date, PhoneNumber = phoneNumber, Message = message, EmployeeEmail = employeeEmail, CallType = callType, FollowedUp = followedUp }; db.PhoneLogs.Add(log); db.SaveChanges(); var savedLog = db.PhoneLogs.Where(item => item.CallerName == name && item.CallDate == date && item.PhoneNumber == phoneNumber && item.Message == message && item.CallType == callType && item.FollowedUp == followedUp).Single(); if (!followedUp) { EmailController.sendAnEmail(savedLog); } return savedLog.Id; } }
public static Models.PhoneLog getPhoneLogById(int id) { using (var db = new PhoneLog.Models.PhoneLogContext()) { var log = db.PhoneLogs.Where(item => item.Id == id).Single(); return new Models.PhoneLog { Id = log.Id, CallDate = log.CallDate, EmployeeEmail = log.EmployeeEmail, CallerName = log.CallerName, CallType = log.CallType, FollowedUp = log.FollowedUp, Message = log.Message, PhoneNumber = log.PhoneNumber }; } }