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