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