public ServiceRecord GetServiceRecord(int serviceRecordID)
{
var serviceRecord = new ServiceRecord();
try
{
var pizzDB = new Entity.PizzaDBEntities();
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
var tempRecord = pizzDB.ServiceRecords.Where(node => node.ID == serviceRecordID).FirstOrDefault();
if (null != tempRecord)
{
serviceRecord = MapEntityToRecord(tempRecord);
}
else
{
serviceRecord = null;
}
}
catch (Exception e)
{
serviceRecord = null;
throw new Exception(e.Message);
}
return(serviceRecord);
}
//need to fix this
public Member GetMember(int memberID)
{
var member = new Member();
try
{
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
var tempMember = pizzaDB.Members
.Where(es => es.ID == memberID).FirstOrDefault();
if (null != tempMember)
{
member = MapEntityToMember(tempMember);
}
else
{
member = null;
}
}
catch (Exception e)
{
member = null;
//If we have time, record the exception
throw new Exception(e.Message);
}
return(member);
}
public Provider GetProvider(int providerID)
{
var provider = new Provider();
try
{
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
var eProvider = pizzaDB.Providers
.Where(es => es.ID == providerID).FirstOrDefault();
if (null != eProvider)
{
provider = MapEntityToProvider(eProvider);
}
else
{
provider = null;
}
}
catch (Exception e)
{
provider = null;
//If we have time, record the exception
throw new Exception(e.Message);
}
return(provider);
}
//delete member from link list
public Boolean DeleteMember(int memberID)
{
var success = false;
try
{
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
var tempMember = pizzaDB.Members
.Where(es => es.ID == memberID).FirstOrDefault();
if (null != tempMember)
{
pizzaDB.Members.Remove(tempMember);
pizzaDB.SaveChanges(); //Apply changes to DB
success = true;
}
else
{
success = false;
}
}
catch (Exception e)
{
success = false;
//If we have time, record the exception
throw new Exception(e.Message);
}
return(success);
}
//need to fix this
public Admin GetAdmin(int adminID)
{
var admin = new Admin();
try
{
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory",
PathFactory.DatabasePath());
var tempAdmin = pizzaDB.Admins
.Where(es => es.ID == adminID).FirstOrDefault();
if (null != tempAdmin)
{
admin = MapEntityToAdmin(tempAdmin);
}
else
{
admin = null;
}
}
catch (Exception e)
{
admin = null;
//If we have time, record the exception
throw new Exception(e.Message);
}
return(admin);
}
public bool DeleteSchedule(int reportType)
{
var success = false;
try
{
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
var eSchedule = pizzaDB.ReportSchedules
.Where(es => es.ReportType == reportType).FirstOrDefault();
if (null != eSchedule)
{
pizzaDB.ReportSchedules.Remove(eSchedule);
pizzaDB.SaveChanges(); //Apply changes to DB
success = true;
}
else
{
success = false;
}
}
catch (Exception e)
{
success = false;
//If we have time, record the exception
throw new Exception(e.Message);
}
return(success);
}
public Schedule GetSchedule(int reportType)
{
var schedule = new Schedule();
try
{
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
var eSchedule = pizzaDB.ReportSchedules
.Where(es => es.ReportType == reportType).FirstOrDefault();
if (null != eSchedule)
{
schedule = MapEntityToSchedule(eSchedule);
}
else
{
schedule = null;
}
}
catch (Exception e)
{
schedule = null;
//If we have time, record the exception
throw new Exception(e.Message);
}
return(schedule);
}
public Service GetService(int serviceCode)
{
var service = new Service();
try
{
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
var eService = pizzaDB.Services
.Where(es => es.ServiceCode == serviceCode).FirstOrDefault();
if (null != eService)
{
service = MapEntityToService(eService);
}
else
{
service = null;
}
}
catch (Exception e)
{
service = null;
//If we have time, record the exception
throw new Exception(e.Message);
}
return(service);
}
public bool VerifyServiceRecords(int providerID, DateTime startDate, DateTime endDate,
bool?verifyFee = true, bool?verifyService = true)
{
var success = false;
try
{
var pizzDB = new Entity.PizzaDBEntities();
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
if (null == startDate)
{
startDate = DateTime.Today;
}
if (null == endDate)
{
endDate = DateTime.Today.AddDays(1);
}
if (startDate < DBDate.MINDATE || endDate < DBDate.MINDATE)
{
throw new Exception("invalid date");
}
if (startDate > endDate)
{
throw new Exception("start date cannot exceed end date.");
}
var counter = 0;
foreach (var eServiceRecord in pizzDB.ServiceRecords
.Where(sr => sr.DateProvided >= startDate &&
sr.DateProvided <= endDate && sr.ProviderID == providerID))
{
if (verifyService.HasValue)
{
eServiceRecord.ServiceVerified = verifyService.Value;
}
if (verifyFee.HasValue)
{
eServiceRecord.FeeVerified = verifyFee.Value;
}
counter++;
}
pizzDB.SaveChanges();
if (counter == 0)
{
throw new Exception("no service record available");
}
success = true;
}
catch (Exception e)
{
success = false;
throw new Exception(e.Message);
}
return(success);
}
//add manager into list
public int?InsertManager(Manager manager)
{
Validator.ValidateManager(manager);
var managerId = new int?();
try
{
var pizzDB = new Entity.PizzaDBEntities();
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
if (manager != null)
{
if (manager.Name == null || manager.State == null || manager.StreetAddress == null || manager.ZipCode == null)
{
return(new int?());
}
if (manager.Name.Trim().Length == 0 || manager.State.Trim().Length == 0 || manager.StreetAddress.Trim().Length == 0 || manager.ZipCode.Trim().Length == 0)
{
return(new int?());
}
//validate all fields of the object
//Validator.ValidateAdmin(manager);
//first check if exist
Manager m2 = this.GetManager(manager.Name);
if (m2 != null)
{
return(new int?());
}
var tempmanager = pizzDB.Managers.Where(node => node.ID == manager.ID).FirstOrDefault();
if (tempmanager == null)
{
var eManager = MapManagerToEntity(manager);
pizzDB.Managers.Add(eManager);
pizzDB.SaveChanges();
managerId = eManager.ID;
}
else
{
managerId = new int?();
}
}
else
{
managerId = new int?();
}
}
catch (Exception e)
{
managerId = new int?();
throw new Exception(e.Message);
}
return(managerId);
}
public List <Service> GetServices()
{
List <Service> services = new List <Service>();
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
foreach (var es in pizzaDB.Services)
{
services.Add(MapEntityToService(es));
}
return(services);
}
public List <Provider> GetAllProviders()
{
List <Provider> providers = new List <Provider>();
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
foreach (var es in pizzaDB.Providers)
{
providers.Add(MapEntityToProvider(es));
}
return(providers);
}
public List <Member> GetAllMembers()
{
var member = new Member();
var pizzDB = new Entity.PizzaDBEntities();
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
foreach (var result in pizzDB.Members)
{
member = MapEntityToMember(result);
members.Add(member);
}
return(members);
}
//Update manager status
public Manager UpdateManager(string name, int managerID, string streetAddress,
string city, string state, string ZIPcode)
{
var manager = new Manager();
var currentManage = new Manager();
try
{
//first check if exist
currentManage.ID = managerID;
currentManage.Name = name;
currentManage.StreetAddress = streetAddress;
currentManage.City = city;
currentManage.State = state;
currentManage.ZipCode = ZIPcode;
Validator.ValidateManager(currentManage);
var pizzDB = new Entity.PizzaDBEntities();
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
var eMember = pizzDB.Managers.Where(node => node.ID == managerID).FirstOrDefault();
if (eMember != null)
{
foreach (var es in pizzDB.Managers.Where(es => es.ID == managerID))
{
es.Name = name != null && name != "" ? name : es.Name;;
es.StreetAddress = streetAddress != null && streetAddress != "" ? streetAddress : es.City;
es.City = city != null && city != "" ? city : es.City;
es.State = state != null && state != "" ? state : es.State;
es.ZipCode = ZIPcode != null && ZIPcode != "" ? ZIPcode : es.ZipCode;
}
pizzDB.SaveChanges();
manager = GetManager(managerID);
}
else
{
manager = null;
}
}
catch (Exception e)
{
manager = null;
throw new Exception(e.Message);
}
return(manager);
}
public Schedule UpdateSchedule(Schedule updatedSchedule)
{
var schedule = new Schedule();
try
{
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
if (null != updatedSchedule)
{
var eSchedule = pizzaDB.ReportSchedules
.Where(es => es.ReportType == updatedSchedule.ReportType).FirstOrDefault();
var updatedWeek = new byte();
if (null != eSchedule &&
byte.TryParse(updatedSchedule.Week.ToString(), out updatedWeek))
{
Validator.ValidateSchedule(updatedSchedule);
foreach (var es in pizzaDB.ReportSchedules
.Where(es => es.ReportType == updatedSchedule.ReportType))
{
es.WeekDay = updatedWeek;
es.Time = updatedSchedule.Time.Ticks;
}
pizzaDB.SaveChanges(); //Apply changes to DB
schedule = GetSchedule(updatedSchedule.ReportType);
}
else
{
schedule = null;
}
}
else
{
schedule = null;
}
}
catch (Exception e)
{
schedule = null;
//If we have time, record the exception
throw new Exception(e.Message);
}
return(schedule);
}
//add service record into list
public int?InsertServiceRecord(ServiceRecord _serviceRecord)
{
Validator.ValidateServiceRecord(_serviceRecord);
var serviceRecordId = new int?();
try
{
var pizzDB = new Entity.PizzaDBEntities();
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
var find = pizzDB.Services.Where(node => node.ServiceCode == _serviceRecord.ServiceCode).FirstOrDefault();
if (find != null)
{
if (_serviceRecord != null)
{
var tempRecord = pizzDB.ServiceRecords.Where(node => node.ID == _serviceRecord.ID).FirstOrDefault();
if (tempRecord == null)
{
_serviceRecord.TimeStamp = DateTime.Now;
var eServiceRecord = MapRecordToEntity(_serviceRecord);
pizzDB.ServiceRecords.Add(eServiceRecord);
pizzDB.SaveChanges();
serviceRecordId = eServiceRecord.ID;
}
else
{
serviceRecordId = new int?();
}
}
else
{
serviceRecordId = new int?();
}
}
else
{
serviceRecordId = new int?();
}
}
catch (Exception e)
{
serviceRecordId = new int?();
throw new Exception(e.Message);
}
return(serviceRecordId);
}
public List <ServiceRecord> GetAllServiceRecordForProvider(int providerID)
{
List <ServiceRecord> recordList = new List <ServiceRecord>();
var serviceRecord = new ServiceRecord();
var pizzDB = new Entity.PizzaDBEntities();
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
foreach (var result in pizzDB.ServiceRecords.Where(node => node.ProviderID == providerID))
{
serviceRecord = MapEntityToRecord(result);
recordList.Add(serviceRecord);
}
return(recordList);
}
//Update admin
public Admin UpdateAdmin(string name, int adminID, string streetAddress,
string city, string state, string ZIPcode)
{
var admin = new Admin();
var currentAdmin = new Admin();
try
{
currentAdmin.ID = adminID;
currentAdmin.Name = name;
currentAdmin.StreetAddress = streetAddress;
currentAdmin.City = city;
currentAdmin.State = state;
currentAdmin.ZipCode = ZIPcode;
Validator.ValidateAdmin(currentAdmin);
var pizzDB = new Entity.PizzaDBEntities();
AppDomain.CurrentDomain.SetData("DataDirectory",
PathFactory.DatabasePath());
var eAdmin = pizzDB.Admins.Where(node => node.ID == adminID).FirstOrDefault();
if (eAdmin != null)
{
foreach (var es in pizzDB.Admins.Where(es => es.ID == adminID))
{
es.Name = name != null && name != "" ? name : es.Name;;
es.StreetAddress = streetAddress != null && streetAddress != "" ? streetAddress : es.City;
es.City = city != null && city != "" ? city : es.City;
es.State = state != null && state != "" ? state : es.State;
es.ZipCode = ZIPcode != null && ZIPcode != "" ? ZIPcode : es.ZipCode;
}
pizzDB.SaveChanges();
admin = GetAdmin(adminID);
}
else
{
admin = null;
}
}
catch (Exception e)
{
admin = null;
throw new Exception(e.Message);
}
return(admin);
}
public Service UpdateService(Service newService)
{
Validator.ValidateService(newService);//check input data format
var service = new Service();
try
{
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
if (null != newService)
{
var eService = pizzaDB.Services
.Where(es => es.ServiceCode == newService.ServiceCode).FirstOrDefault();
if (null != eService)
{
foreach (var es in pizzaDB.Services
.Where(es => es.ServiceCode == newService.ServiceCode))
{
es.Name = newService.ServiceName;
es.Fee = newService.ServiceFee;
}
pizzaDB.SaveChanges(); //Apply changes to DB
service = GetService(newService.ServiceName);
}
else
{
service = null;
}
}
else
{
service = null;
}
}
catch (Exception e)
{
service = null;
//If we have time, record the exception
throw new Exception(e.Message);
}
return(service);
}
public Provider UpdateProvider(string name, int providerID, string streetAddress,
string city, string state, string ZIPcode, long bankAccount)
{
var provider = new Provider(name, streetAddress, city, state, ZIPcode, bankAccount);
Validator.ValidateProvider(provider); //validate the format
try
{
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
var eProvider = pizzaDB.Providers
.Where(es => es.ID == providerID).FirstOrDefault();
if (null != eProvider)
{
foreach (var es in pizzaDB.Providers
.Where(es => es.ID == providerID))
{
es.Name = name != null && name != "" ? name : es.Name;;
es.StreetAddress = streetAddress != null && streetAddress != "" ? streetAddress : es.City;
es.City = city != null && city != "" ? city : es.City;
es.State = state != null && state != "" ? state : es.State;
es.ZipCode = ZIPcode != null && ZIPcode != "" ? ZIPcode : es.ZipCode;
es.BankAccount = bankAccount != null ? bankAccount : es.BankAccount;
}
pizzaDB.SaveChanges(); //Apply changes to DB
provider = null;
provider = GetProvider(providerID);
}
else
{
provider = null;
}
}
catch (Exception e)
{
provider = null;
//If we have time, record the exception
throw new Exception(e.Message);
}
return(provider);
}
public int?AddService(Service newService)
{
Validator.ValidateService(newService); //check input data format
if (null != GetService(newService.ServiceCode))
{
throw new Exception("Service exists already.");
}
var serviceId = new int?();
try
{
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
if (null != newService)
{
var eService = pizzaDB.Services
.Where(es => es.ServiceCode == newService.ServiceCode).FirstOrDefault();
if (null == eService)
{
eService = MapServiceToEntity(newService);
pizzaDB.Services.Add(eService);
pizzaDB.SaveChanges();
serviceId = eService.ID;
}
else
{
serviceId = new int?();
}
}
else
{
serviceId = new int?();
}
}
catch (Exception e)
{
serviceId = new int?();
//If we have time, record the exception
throw new Exception(e.Message);
}
return(serviceId);
}
public bool AddSchedule(Schedule newSchedule)
{
var success = false;
try
{
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
if (null != newSchedule)
{
var eSchedule = pizzaDB.ReportSchedules
.Where(es => es.ReportType == newSchedule.ReportType).FirstOrDefault();
var newWeek = new byte();
if (null == eSchedule &&
byte.TryParse(newSchedule.Week.ToString(), out newWeek))
{
Validator.ValidateSchedule(newSchedule);
pizzaDB.ReportSchedules.Add(MapScheduleToEntity(newSchedule));
pizzaDB.SaveChanges(); //Apply changes to DB
success = true;
}
else
{
success = false;
}
}
else
{
success = false;
}
}
catch (Exception e)
{
success = false;
//If we have time, record the exception
throw new Exception(e.Message);
}
return(success);
}
public int?AddProvider(Provider newProvider)
{
Validator.ValidateProvider(newProvider);
var providerId = new int?();
try
{
var pizzaDB = new Entity.PizzaDBEntities();//EntitiesRepository
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
if (null != newProvider)
{
var eProvider = pizzaDB.Providers
.Where(es => es.ID == newProvider.ID).FirstOrDefault();
if (null == eProvider)
{
eProvider = MapProviderToEntity(newProvider);
pizzaDB.Providers.Add(eProvider);
pizzaDB.SaveChanges(); //Apply changes to DB
providerId = eProvider.ID;
}
else
{
providerId = new int?();
}
}
else
{
providerId = new int?();
}
}
catch (Exception e)
{
providerId = new int?();
//If we have time, record the exception
throw new Exception(e.Message);
}
return(providerId);
}
//add admin into list
public int?AddAdmin(Admin admin)
{
var adminId = new int?();
try
{
var pizzDB = new Entity.PizzaDBEntities();
AppDomain.CurrentDomain.SetData("DataDirectory",
PathFactory.DatabasePath());
if (admin != null)
{
Validator.ValidateAdmin(admin);
var tempadmin = pizzDB.Admins.Where(node => node.ID == admin.ID).FirstOrDefault();
if (tempadmin == null)
{
var eAdmin = MapAdminToEntity(admin);
pizzDB.Admins.Add(eAdmin);
pizzDB.SaveChanges();
adminId = eAdmin.ID;
}
else
{
adminId = new int?();
}
}
else
{
adminId = new int?();
}
}
catch (Exception e)
{
adminId = new int?();
throw new Exception(e.Message);
}
return(adminId);
}
//add member into list
public int?InsertMember(Member member)
{
Validator.ValidateMember(member);
var memberId = new int?();
try
{
var pizzDB = new Entity.PizzaDBEntities();
AppDomain.CurrentDomain.SetData("DataDirectory", PathFactory.DatabasePath());
if (member != null)
{
var tempmember = pizzDB.Members.Where(node => node.ID == member.ID).FirstOrDefault();
if (tempmember == null)
{
var eMember = MapMemberToEntity(member);
pizzDB.Members.Add(eMember);
pizzDB.SaveChanges();
memberId = eMember.ID;
}
else
{
memberId = new int?();
}
}
else
{
memberId = new int?();
}
}
catch (Exception e)
{
memberId = new int?();
throw new Exception(e.Message);
}
return(memberId);
}