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 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;
}
}
