public List <AreaModel> GetAreaInfo() { System.Diagnostics.Debug.WriteLine("here333"); SalesERPDAL salesDal = new SalesERPDAL(); return(salesDal.AreaInfo.ToList()); }
public IEnumerable <Employee> Querys(string searchString) { using (SalesERPDAL dal = new SalesERPDAL()) { return(dal.Employees.Where(e => e.Name.Contains(searchString)).ToList()); } }
public IEnumerable <Employee> Select(string name) { using (var db = new SalesERPDAL()) { return(db.MyEmployees.Where(e => e.Name.Contains(name)).ToList()); } }
public List <Employee> GetEmployeeList() { SalesERPDAL dal = new SalesERPDAL(); var list = dal.Employee.ToList(); return(list); }
public List<Employee> GetEmployees() { SalesERPDAL sdal = new SalesERPDAL(); return sdal.employees.ToList(); //List<Employee> emplist = new List<Employee>(); //Employee emp1 = new Employee(); //Employee emp2 = new Employee(); //Employee emp3 = new Employee(); //emp1.FirstName = "Vikas"; //emp1.LastName = "Pinnuri"; //emp1.Salary = 10000; //emplist.Add(emp1); //emp2.FirstName = "Siva"; //emp2.LastName = "Chamarthi"; //emp2.Salary = 20000; //emplist.Add(emp2); //emp3.FirstName = "Praveen"; //emp3.LastName = "Rajuri"; //emp3.Salary = 30000; //emplist.Add(emp3); //return emplist; }
public bool SetAdmin(Employee e) { try { if (e.Authentication == 1) { return(true); } using (SalesERPDAL salesERPDAL = new SalesERPDAL()) { foreach (var v in salesERPDAL.Employees) { if (e.UserID == v.UserID) { v.Authentication = 1; } else { v.Authentication = 0; } } salesERPDAL.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
public List <Employee> GetEmployees() { SalesERPDAL salesDal = new SalesERPDAL(); return(salesDal.Employees.ToList()); var employees = new List <Employee>(); Employee emp = new Employee(); emp.FirstName = "johnson"; emp.LastName = "fernandes"; emp.Salary = 140000; employees.Add(emp); Employee emp1 = new Employee(); emp1.FirstName = "johnson1"; emp1.LastName = "fernandes1"; emp1.Salary = 1400001; employees.Add(emp1); Employee emp2 = new Employee(); emp2.FirstName = "johnson2"; emp2.LastName = "fernandes2"; emp2.Salary = 1400001; employees.Add(emp2); return(employees); }
public List <Employee> GetEmployees() { /* List<Employee> employees = new List<Employee>(); * Employee emp = new Employee(); * emp.FirstName = "Johnson"; * emp.LastName = "Fernandes"; * emp.Salary = 14000; * employees.Add(emp); * * emp = new Employee(); * emp.FirstName = "Michael"; * emp.LastName = "Jackson"; * emp.Salary = 16000; * employees.Add(emp); * * emp = new Employee(); * emp.FirstName = "Robert"; * emp.LastName = "Pattinson"; * emp.Salary = 20000; * employees.Add(emp); * * return employees;*/ return(SalesERPDAL.GetEmployees()); }
public List <Employee> GetEmployee() { //List<Employee> employees = new List<Employee>(); //Employee emp = new Employee(); //emp.Name = "阿1"; //emp.Salary = 20000; //employees.Add(emp); //emp = new Employee(); //emp.Name = "阿2"; //emp.Salary = 10000; //employees.Add(emp); //emp = new Employee(); //emp.Name = "阿3"; //emp.Salary = 2000; //employees.Add(emp); //return employees; //SalesERPDAL salesDal = new SalesERPDAL(); //return salesDal.Employees.ToList(); using (SalesERPDAL dal = new SalesERPDAL()) { var list = dal.Employees.ToList(); return(list); } }
public List <Employee> GetEmployees() { #region Using the list to return the data //List<Employee> employees = new List<Employee>(); //Employee emp = new Employee(); //emp.FirstName = "Sabique"; //emp.LastName = "Khan"; //emp.Salary = 10000; //employees.Add(emp); //emp = new Employee(); //emp.FirstName = "John"; //emp.LastName = "Doe"; //emp.Salary = 50000; //employees.Add(emp); //emp = new Employee(); //emp.FirstName = "Jenny"; //emp.LastName = "Doe"; //emp.Salary = 60000; //employees.Add(emp); //return employees; #endregion #region Returning the data from the database SalesERPDAL salesDAL = new SalesERPDAL(); return(salesDAL.Employees.ToList()); #endregion }
public List<Employee> GetEmployees() { SalesERPDAL salesDal = new SalesERPDAL(); return salesDal.Employees.ToList(); //var list = new List<Employee>(); //Employee emp = new Employee(); //emp.Name = "张三"; //emp.Salary = 10000; //list.Add(emp); //emp = new Employee(); //emp.Name = "李四"; //emp.Salary = 100000; //list.Add(emp); //emp = new Employee(); //emp.Name = "王五"; //emp.Salary = 100000; //list.Add(emp); //return list; }
public List <Employee> GetEmployees() { //return MockData(); SalesERPDAL dal = new SalesERPDAL(); return(dal.Employees.ToList()); }
public void SaveEmployee(Employee e) { SalesERPDAL salesDal = new SalesERPDAL(); salesDal.Employees.Add(e); salesDal.SaveChanges(); }
public EmployeeListViewFromDBModel(string userName) { SalesERPDAL salesDal = new SalesERPDAL(); GetEmployeesFromDB(); this.UserName = userName; }
public void UploadEmployeesRegionInfo(List <AreaModel> areaInfo) { SalesERPDAL salesDal = new SalesERPDAL(); salesDal.AreaInfo.AddRange(areaInfo); salesDal.SaveChanges(); }
public List <Employee> GetEmployees() { SalesERPDAL salesDal = new SalesERPDAL(); return(salesDal.Employees.ToList()); /*List<Employee> employees = new List<Employee> (); * Employee emp = new Employee(); * emp.FirstName = "johnson"; * emp.LastName = " fernandes"; * emp.Salary = 14000; * employees.Add(emp); * * emp = new Employee(); * emp.FirstName = "michael"; * emp.LastName = "jackson"; * emp.Salary = 16000; * employees.Add(emp); * * emp = new Employee(); * emp.FirstName = "robert"; * emp.LastName = " pattinson"; * emp.Salary = 20000; * employees.Add(emp); * * return employees;*/ }
public List <Employee> GetEmployees() { //List<Employee> employees = new List<Employee>(); //Employee emp = new Employee(); //emp.FirstName = "Johnson"; //emp.LastName = "Fernandes"; //emp.Salary = 120000; //employees.Add(emp); //Employee emp2 = new Employee //{ // FirstName = "Mark", // LastName = "Raduenzel", // Salary = 200000 //}; //employees.Add(emp2); //return employees; SalesERPDAL sales = new SalesERPDAL(); return(sales.Employees.ToList()); }
public List <Employee> GetEmployees() { SalesERPDAL sales = new SalesERPDAL(); return(sales.Employees.ToList()); }
//public List<Employee> GetEmployees() //{ // List<Employee> employees = new List<Employee>(); // Employee emp = new Employee(); // emp.FirstName = "johnson"; // emp.LastName = " fernandes"; // emp.Salary = 14000; // employees.Add(emp); // emp = new Employee(); // emp.FirstName = "michael"; // emp.LastName = "jackson"; // emp.Salary = 16000; // employees.Add(emp); // emp = new Employee(); // emp.FirstName = "robert"; // emp.LastName = " pattinson"; // emp.Salary = 20000; // employees.Add(emp); // return employees; //} // 获得数据库Employee数据 public List <Employee> GetEmployees() { SalesERPDAL salesDal = new SalesERPDAL(); // 将全部Employee转为List return(salesDal.Employees.ToList()); }
public void UploadEmployees(List <Employee> employees) { var salesDal = new SalesERPDAL(); salesDal.Employees.AddRange(employees); salesDal.SaveChanges(); }
public List <Employee> GetEmployeeList() { using (SalesERPDAL salesDal = new SalesERPDAL()) { var list = salesDal.Employees.ToList(); //return salesDal.Employees.ToList(); return(list); } //var list = new List<Employee>(); //Employee emp = new Employee(); //emp.Name = "杨"; //emp.Salary = 15000; //list.Add(emp); //emp = new Employee(); //emp.Name = "天"; //emp.Salary = 2000; //list.Add(emp); //emp = new Employee(); //emp.Name = "敏"; //emp.Salary = 2500; //list.Add(emp); //return list; }
public Employee Query(int id) { using (SalesERPDAL dal = new SalesERPDAL()) { return(dal.Employee.Find(id)); } }
public void UploadEmployees(List <Employee> employees) { SalesERPDAL salesDAL = new SalesERPDAL(); salesDAL.Employees.AddRange(employees); salesDAL.SaveChanges(); }
//员工信息业务层 public List <Employee> GetEmployeesList() { //SalesERPDAL salesDal = new SalesERPDAL(); //return salesDal.Employee.ToList(); using (SalesERPDAL dal = new SalesERPDAL()) { var list = dal.Employee.ToList(); return(list); } //List<Employee> employeesList = new List<Employee>(); //Employee emp = new Employee(); //emp.Name = "张三"; //emp.Salary = 500; //employeesList.Add(emp); //emp = new Employee(); //emp.Name = "张四"; //emp.Salary = 1200; //employeesList.Add(emp); //emp = new Employee(); //emp.Name = "李三"; //emp.Salary = 1600; //employeesList.Add(emp); //return employeesList; }
public IEnumerable <Employee> Search(string searchStirng) { using (var db = new SalesERPDAL()) { return(db.Employees.Where(e => e.Name.Contains(searchStirng)).ToList()); } }
public List <Empleado> GetEmpleados() { //List<Empleado> Empleados = new List<Empleado>(); //Empleado emp = new Empleado(); //emp.FirstName = "Jonh"; //emp.LastName = "Doe"; //emp.Salario = 178000; //Empleados.Add(emp); //emp = new Empleado(); //emp.FirstName = "Michael"; //emp.LastName = "Jackson"; //emp.Salario = 10000000; //Empleados.Add(emp); //emp = new Empleado(); //emp.FirstName = "Mariel"; //emp.LastName = "Rodríguez"; //emp.Salario = 10000; //Empleados.Add(emp); SalesERPDAL salesDal = new SalesERPDAL(); return(salesDal.empleados.ToList()); }
public List <employee> GetEmployees() { SalesERPDAL salesDal = new SalesERPDAL(); return(salesDal.Employees.ToList()); //List<employee> employees = new List<employee>(); //employee emp = new employee(); //emp.FirstName = "johnson"; //emp.LastName = " fernandes"; //emp.Salary = 14000; //employees.Add(emp); //emp = new employee(); //emp.FirstName = "michael"; //emp.LastName = "jackson"; //emp.Salary = 1600000; //employees.Add(emp); //emp = new employee(); //emp.FirstName = "robert"; //emp.LastName = " pattinson"; //emp.Salary = 20000; //employees.Add(emp); //emp = new employee(); //emp.FirstName = "jack"; //emp.LastName = " sparrow"; //emp.Salary = 2000; //employees.Add(emp); //return employees; }
public Employee SaveEmployee(Employee e) { SalesERPDAL salesDal = new SalesERPDAL(); salesDal.Employees.Add(e); salesDal.SaveChanges(); return e; }
//更新 public void UpdateSaveEmployee(Employee emp) { using (SalesERPDAL dal = new SalesERPDAL()) { dal.Entry(emp).State = EntityState.Modified; dal.SaveChanges(); } }
//更新方法 public void Update(Employee emp) { using (var db = new SalesERPDAL()) { db.Entry(emp).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
//查询方法 public Employee Query(int id) { using (var db = new SalesERPDAL()) { Employee emp = db.Employees.Find(id); return(emp); } }
public List <Employee> GetEmployeeList() { using (SalesERPDAL dal = new SalesERPDAL()) { var list = dal.Employees.ToList(); return(list); } }
public void UploadEmployees(List<Employee> employees) { SalesERPDAL salesDal = new SalesERPDAL(); salesDal.Employees.AddRange(employees); salesDal.SaveChanges(); }
public List<Employee> GetEmployees() { SalesERPDAL salesDal = new SalesERPDAL(); return salesDal.Employees.ToList(); }