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