public GoodDTO UpdateProd(GoodDTO productToUpdate)
{
using (var db = new companyEntities())
{
var prod = db.tblGoods.FirstOrDefault(u => u.id == productToUpdate.id);
return(_mapper.Map <GoodDTO>(prod));
}
}
public UserDTO GetUserById(int id)
{
using (var entities = new companyEntities())
{
var us = entities.tblUsers.FirstOrDefault(c => c.id == id);
return(_mapper.Map <UserDTO>(us));
}
}
public List <UserDTO> GetUsers()
{
List <UserDTO> users = new List <UserDTO>();
using (var entities = new companyEntities())
{
users = _mapper.Map <List <UserDTO> >(entities.tblUsers).ToList();
}
return(users);
}
/// <summary>
/// 创建EF上下文对象,已存在就直接取,不存在就创建,保证线程内是唯一。
/// </summary>
/// <returns></returns>
public static DbContext Create()
{
DbContext dbContext = CallContext.GetData("DbContext") as DbContext;
if (dbContext == null)
{
dbContext = new companyEntities();
CallContext.SetData("DbContext", dbContext);
}
return(dbContext);
}
static void Main(string[] args)
{
companyEntities entites = new companyEntities();
List <Employee> employees = entites.Employees.ToList();
foreach (var item in employees)
{
Console.WriteLine($"{item.EmpID},{item.EmpName}");
}
Console.ReadKey();
}
public UserDTO UpdateUser(UserDTO userToupdate)
{
using (var db = new companyEntities())
{
var user = db.tblUsers.FirstOrDefault(u => u.id == userToupdate.id);
user.email = userToupdate.email;
user.first_name = userToupdate.first_name;
user.last_name = userToupdate.last_name;
user.Is_Login = true;
user.password = userToupdate.password;
return(_mapper.Map <UserDTO>(user));
}
}
public int DeleteUserById(int id)
{
using (var db = new companyEntities())
{
tblUser user = _mapper.Map <tblUser>(GetUserById(id));
if (user != null)
{
db.Entry(user).State = EntityState.Deleted;
db.SaveChanges();
return(1);
}
return(0);
}
}
public int AddUser(UserDTO user)
{
if (user != null)
{
using (var db = new companyEntities())
{
db.tblUsers.Add(_mapper.Map <tblUser>(user));
db.SaveChanges();
return(user.id);
}
}
return(0);
}
public int AddProd(GoodDTO prod)
{
if (prod != null)
{
using (var db = new companyEntities())
{
db.tblGoods.Add(_mapper.Map <tblGood>(prod));
db.SaveChanges();
return(prod.id);
}
}
return(0);
}
public int Login(string email, string pass)
{
int res = -1;
string passHash = GetHash(pass);
using (var entities = new companyEntities())
{
var user = entities.tblUsers.Where(u => u.email == email && u.password == passHash).FirstOrDefault();
if (user != null)
{
res = user.id;
user.Is_Login = true;
SaveChanges();
return(res);
}
}
return(res);
}