public List <Vendor> AllVendors() { using (var db = new FixAssetDBEntities()) { return(db.Vendors.ToList()); } }
public bool HasThisEmployee(int empId) { using (var db = new FixAssetDBEntities()) { bool hasEmp = db.Employees.Any(x => x.EmployeeId == empId); return(hasEmp); } }
public void SaveEmployeeInfo(Employee newEmployee) { using (var db = new FixAssetDBEntities()) { db.Employees.Add(newEmployee); db.SaveChanges(); } }
public static void SaveEmployeeInfo(Employee newEmployee) { using (var db = new FixAssetDBEntities()) { db.Employees.Add(newEmployee); db.SaveChanges(); } }
public Vendor FindVendor(int vendorId) { using (var DB = new FixAssetDBEntities()) { Vendor aVendor = DB.Vendors.Find(vendorId); return(aVendor); } }
public void UpdateEmployee(Employee anEmployee) { using (var db = new FixAssetDBEntities()) { //int empId = Int16.Parse(employeeId); db.SaveChanges(); } }
public Employee FindAnEmployee(int employeeId) { //List<EmployeeUI> employees = new List<EmployeeUI>(); using (var db = new FixAssetDBEntities()) { //int empId = Int16.Parse(employeeId); var anEmployee = (from emp in db.Employees where emp.EmployeeId == employeeId select emp).FirstOrDefault(); return(anEmployee); } }
public string Update(int vendorId, string name, string email, string address, string phone) { using (var DB = new FixAssetDBEntities()) { var vendr = DB.Vendors.SingleOrDefault(x => x.VendorId == vendorId); vendr.Name = name; vendr.Email = email; vendr.Address = address; vendr.Phone = phone; DB.SaveChanges(); return("Success"); } }
public static List <Employee> GetAllUsers() { try { using (var db = new FixAssetDBEntities()) { return(db.Employees.ToList()); } } catch (Exception e) { return(new List <Employee>()); } }
public static void DeleteAnEmployee(string employeeId) { if (employeeId != null) { using (var db = new FixAssetDBEntities()) { int empId = Int16.Parse(employeeId); var anemployee = (from emp in db.Employees where emp.EmployeeId == empId select emp).FirstOrDefault(); db.Employees.Remove(anemployee); db.SaveChanges(); } } }
public static List<Employee> GetAllUsers() { try { using (var db = new FixAssetDBEntities()) { return db.Employees.ToList(); } } catch (Exception aException) { throw new Exception(aException.Message); } }
public static void DeleteAnEmployee(string employeeId) { if (employeeId!=null) { using (var db = new FixAssetDBEntities()) { int empId = Int16.Parse(employeeId); var anemployee = (from emp in db.Employees where emp.EmployeeId == empId select emp).FirstOrDefault(); db.Employees.Remove(anemployee); db.SaveChanges(); } } }
public string AddVendor(Vendor vendor) { using (var db = new FixAssetDBEntities()) { try { db.Vendors.Add(vendor); db.SaveChanges(); return("New Vendor Saved Succesfully"); } catch (Exception exception) { return(exception.Message); } } }
public string DeleteVendor(int vendorId) { try { using (var DB = new FixAssetDBEntities()) { var vdr = DB.Vendors.SingleOrDefault(x => x.VendorId == vendorId); DB.Vendors.Remove(vdr); DB.SaveChanges(); return("Vendor Deleted!!"); } } catch (Exception exp) { return(exp.Message); } }