public static void UpdatePetFriendly(Animal animal, string update) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); var petFriendly = (from p in db.Animals where p.ID == animal.ID select p).FirstOrDefault(); bool isPetFriendly; if (update.ToLower() == "yes") { isPetFriendly = true; } else { isPetFriendly = false; } animal.kidFriendly = isPetFriendly; try { db.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } }
public static void AddNewClient(string firstName, string lastName, string username, string password, string email, string streetAddress, int zipCode, int state) { HumaneSocietyDataContext db = new HumaneSocietyDataContext("c:/Documents/HumaneSociety/HumaneSociety/HumaneSociety.dbml"); Client client = new Client(); client.firstName = firstName; client.lastName = lastName; client.userName = username; client.pass = password; client.email = email; UserAddress address = new UserAddress(); address.addessLine1 = streetAddress; address.zipcode = zipCode; address.USStates = state; client.userAddress = address.ID; db.Clients.InsertOnSubmit(client); try { db.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } }
public static void UpdateWeight(Animal animal, string update) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); var weight = (from w in db.Animals where w.ID == animal.ID select w).FirstOrDefault(); try { db.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } }
public static void UpdateDemeanor(Animal animal, string update) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); var demeanor = (from d in db.Animals where d.ID == animal.ID select d).FirstOrDefault(); demeanor.demeanor = update; try { db.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } }
public static void UpdateAge(Animal animal, string update) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); var age = (from a in db.Animals where a.ID == animal.ID select a).FirstOrDefault(); age.age = Int32.Parse(update); try { db.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } }
public static void CreateNewEmployee(Employee employee, string create) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); db.Employees.InsertOnSubmit(employee); try { db.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } }
public static void AddAnimal(Animal animal) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); db.Animals.InsertOnSubmit(animal); try { db.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } }
public static void UpdateEmail(Client client) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); var clientData = db.Clients.Where(c => c.ID == client.ID).Select(c => c).First(); clientData.email = client.email; try { db.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } }
public static void DeleteOldEmployee(Employee employee, string delete) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); var oldEmployee = (from o in db.Employees where o.employeeNumber == employee.employeeNumber && o.lastName == employee.lastName select o).FirstOrDefault(); db.Employees.DeleteOnSubmit(oldEmployee); try { db.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } }
public static void RemoveAnimal(Animal animal) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); var animalToRemove = (from a in db.Animals where a.ID == animal.ID select a).FirstOrDefault(); db.Animals.DeleteOnSubmit(animalToRemove); try { db.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } }
public static void AddUsernameAndPassword(Employee employee, string userName, string password) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); var addEmployee = (from e in db.Employees where e.ID == employee.ID select e).FirstOrDefault(); addEmployee.userName = userName; addEmployee.pass = password; try { db.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } }
public static Client GetClient(string userName, string password) { HumaneSocietyDataContext db = new HumaneSocietyDataContext("c:/Documents/HumaneSociety/HumaneSociety/HumaneSociety.dbml"); Table <Client> clients = db.GetTable <Client>(); var getClient = db.Clients.Where(c => c.userName == userName).Select(c => c).FirstOrDefault(); try { if (password == getClient.pass) { return(getClient); } } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } return(getClient); }
public static void UpdateEmployeeInfo(Employee employee, string update) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); int employeeNumber = int.Parse(UserInterface.GetStringData("employee number", "the employee's original")); Employee employeetoUpdate = GetEmployeeByEmployeeNumber(employeeNumber); var employeeInContext = (from u in db.Employees where employeetoUpdate.ID == u.ID select u).FirstOrDefault(); employeeInContext.email = employee.email; employeeInContext.lastName = employee.lastName; employeeInContext.employeeNumber = employee.employeeNumber; employeeInContext.firsttName = employee.firsttName; try { db.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } }
public static int GetBreedKey(string breed) { HumaneSocietyDataContext context = new HumaneSocietyDataContext(); var breedID = (from c in context.Breeds where c.breed1 == breed select c.ID).FirstOrDefault(); if (breedID < 0) { Breed newBreed = new Breed(); newBreed.breed1 = breed; context.Breeds.InsertOnSubmit(newBreed); try { context.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } return(newBreed.ID); } return(breedID); }
public static int GetShotID(string name) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); bool shotExist = db.Shots.Any(s => s.name == name); if (shotExist == false) { Shot shotToAdd = new Shot(); shotToAdd.name = name; db.Shots.InsertOnSubmit(shotToAdd); try { db.SubmitChanges(); } catch (Exception e) { UserInterface.DisplayExceptionMessage(e); } } var shotID = (from s in db.Shots where s.name == name select s.ID).FirstOrDefault(); return(shotID); }