public static void storeEmployee(string employeeName, String employeeEmail)
{
using (var db = new PhoneLog.Models.PhoneLogContext())
{
var employee = new PhoneLog.Models.Employee
{
EmployeeName = employeeName,
EmployeeEmail = employeeEmail
};
db.Employees.Add(employee);
try
{
int result = db.SaveChanges();
Console.WriteLine(result);
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
}
public static void storeCallType(string callType)
{
using (var db = new PhoneLog.Models.PhoneLogContext())
{
var call = new PhoneLog.Models.CallType
{
CallType1 = callType
};
db.CallTypes.Add(call);
try
{
int result = db.SaveChanges();
Console.WriteLine(result);
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
}
public static void deleteEmployee(int id)
{
using (var db = new PhoneLog.Models.PhoneLogContext())
{
var employee = db.Employees.Where(item => item.Id == id).Single();
db.Employees.Remove(employee);
db.SaveChanges();
}
}
public static void deleteCallType(int id)
{
using (var db = new PhoneLog.Models.PhoneLogContext())
{
var callType = db.CallTypes.Where(item => item.Id == id).Single();
db.CallTypes.Remove(callType);
db.SaveChanges();
}
}
public static Models.CallType getCallTypeById(int id)
{
using (var db = new PhoneLog.Models.PhoneLogContext())
{
var callType = db.CallTypes.Where(item => item.Id == id).Single();
return new Models.CallType
{
Id = callType.Id,
CallType1 = callType.CallType1
};
}
}
public static Models.Employee getEmployeeById(int id)
{
using (var db = new PhoneLog.Models.PhoneLogContext())
{
var employee = db.Employees.Where(item => item.Id == id).Single();
return new Models.Employee
{
Id = employee.Id,
EmployeeName = employee.EmployeeName,
EmployeeEmail = employee.EmployeeEmail
};
}
}
public static List<PhoneLog.Models.CallType> getAllCallTypes()
{
List<Models.CallType> allCallTypes = new List<Models.CallType>();
using (var db = new PhoneLog.Models.PhoneLogContext())
{
var query = from l in db.CallTypes
orderby l.CallType1
select l;
Console.WriteLine("All calltypes in the database:");
foreach (var item in query)
{
allCallTypes.Add(new Models.CallType
{
Id = item.Id,
CallType1 = item.CallType1
});
}
}
return allCallTypes;
}
public static List<PhoneLog.Models.Employee> getAllEmployees()
{
List<Models.Employee> allEmployees = new List<Models.Employee>();
using (var db = new PhoneLog.Models.PhoneLogContext())
{
var query = from l in db.Employees
orderby l.EmployeeName
select l;
Console.WriteLine("All employees in the database:");
foreach (var item in query)
{
allEmployees.Add(new Models.Employee
{
Id = item.Id,
EmployeeName = item.EmployeeName,
EmployeeEmail = item.EmployeeEmail
});
}
}
return allEmployees;
}
