public List <Employee> GetEmployeeByTeam(string teamName) { using (var context = new MesEntities()) { var query = from x in context.Employees where x.Team == teamName select x; return(query.ToList()); } }
public List <Employee> GetByPK(int employeeId) { using (var context = new MesEntities()) { var query = from x in context.Employees where x.EmployeeId == employeeId select x; return(query.ToList()); } }
public List <Resource_Quote> GetByDate(DateTime start, DateTime end) { using (var context = new MesEntities()) { var query = from x in context.Resource_Quotes where x.date >= start && x.date <= end select x; List <Resource_Quote> list = query.ToList(); return(query.ToList()); } }
public string GetName(string id) { using (var context = new MesEntities()) { var query = from x in context.Employees where x.EmployeeId.ToString() == id select x; List <Employee> list = query.ToList(); if (list.Count() == 1) { return(list[0].Name); } return(""); } }
public bool VerifyIdPassword(string id, string passwd) { using (var context = new MesEntities()) { var query = from x in context.Employees where x.EmployeeId.ToString() == id && x.Password == passwd select x; List <Employee> list = query.ToList(); if (list.Count() == 1) { return(true); } return(false); } }
public void InsertWareHouse(string[] strArray) { using (var context = new MesEntities()) { var WareHouses = context.Set <WareHouse>(); WareHouses.Add(new WareHouse { WareHouseId = Convert.ToInt32(strArray[0]), AreaSize = Convert.ToInt32(strArray[1]), EmployeeId = Convert.ToInt32(strArray[2]), PhoneNumber = strArray[3], }); context.SaveChanges(); } }
public List <Order> GetBySellerName(string sellerName) { sellerName.Trim(); if (sellerName == "") { return(null); } using (var context = new MesEntities()) { var query = from x in context.Orders where x.SellerName == sellerName select x; return(query.ToList()); } }
public void InsertOrder(string[] strArray) { // insert using (var context = new MesEntities()) { var orders = context.Set <Order>(); orders.Add(new Order { OrderId = Convert.ToInt32(strArray[0]), ResourceId = Convert.ToInt32(strArray[1]), Date = Convert.ToDateTime(strArray[2]), EmployeeId = Convert.ToInt32(strArray[3]), Quantity = Convert.ToInt32(strArray[4]), SellerName = strArray[5] }); context.SaveChanges(); } }
public void UpdateWareHouse(List <string> list) { int id = Convert.ToInt32(list[0]); using (var context = new MesEntities()) { var result = context.WareHouses.SingleOrDefault(x => x.WareHouseId == id); if (result != null) { result.WareHouseId = id; result.AreaSize = Convert.ToInt32(list[1]); result.EmployeeId = Convert.ToInt32(list[2]); result.PhoneNumber = list[3]; } context.SaveChanges(); } }
public List <Order> GetByPK(string orderId) { orderId.Trim(); if (orderId == "") { return(null); } int id = Convert.ToInt32(orderId); using (var context = new MesEntities()) { var query = from x in context.Orders where x.OrderId == id select x; return(query.ToList()); } }
public List <Resource> GetByPK(string Resource) { Resource.Trim(); if (Resource == "") { return(null); } int id = Convert.ToInt32(Resource); using (var context = new MesEntities()) { var query = from x in context.Resources where x.Category == id select x; return(query.ToList()); } }
public List <Expense> Search() { using (MesEntities context = DbContextCreator.Create()) { var query = from x in context.Expenses select new { Expense = x, CategoryName = x.ExpenseCategory.Name }; var list = query.ToList(); foreach (var item in list) { item.Expense.CategoryName = item.CategoryName; } return(list.Select(x => x.Expense).ToList()); } }
public void InsertEmployee(List <string> list) { // insert using (var context = new MesEntities()) { var orders = context.Set <Employee>(); orders.Add(new Employee { EmployeeId = Convert.ToInt32(list[0]), Name = list[1], Position = list[2], BossId = Convert.ToInt32(list[3]), Address = list[4], PhoneNumber = list[5], Team = list[6], Password = list[7] }); context.SaveChanges(); } }
public void UpdateOrder(List <string> list) { int id = Convert.ToInt32(list[0]); int rscId = Convert.ToInt32(list[1]); using (var context = new MesEntities()) { var result = context.Orders.SingleOrDefault(x => x.OrderId == id); if (result != null) { result.OrderId = Convert.ToInt32(list[0]); result.ResourceId = rscId; result.Date = Convert.ToDateTime(list[2]); result.EmployeeId = Convert.ToInt32(list[3]); result.Quantity = Convert.ToInt32(list[4]); result.SellerName = list[5]; } context.SaveChanges(); } }
public void UpdateEmployee(List <string> list) { int id = Convert.ToInt32(list[0]); using (var context = new MesEntities()) { var result = context.Employees.SingleOrDefault(x => x.EmployeeId == id); if (result != null) { result.EmployeeId = id; result.Name = list[1]; result.Position = list[2]; result.BossId = Convert.ToInt32(list[3]); result.Address = list[4]; result.PhoneNumber = list[5]; result.Team = list[6]; result.Password = list[7]; } context.SaveChanges(); } }