public void AddUser(userDTO user)
{
using (var db = new OnlineStoreEntities())
{
user_id target = mapper.Map <user_id>(user);
db.user_id.Add(target);
db.SaveChanges();
}
}
public userDTO GetUserByID(int Id)
{
using (OnlineStoreEntities db = new OnlineStoreEntities())
{
user_id target = db.user_id
.Where(u => u.id == Id)
.FirstOrDefault();
return(mapper.Map <userDTO>(target));
}
}
public void DeleteUser(int id)
{
using (OnlineStoreEntities db = new OnlineStoreEntities())
{
//db.user_id.Attach(user);
// db.user_id.Remove(user);
user_id target = db.user_id
.Where(u => u.id == id)
.FirstOrDefault();
db.Entry(target).State = EntityState.Deleted;
db.SaveChanges();
}
}
public int UpdateUser(userDTO user)
{
using (OnlineStoreEntities db = new OnlineStoreEntities())
{
user_id target = db.user_id
.Where(u => u.id == user.id)
.FirstOrDefault();
//target = mapper.Map<user_id>(user);
target.user_name = user.user_name;
target.first_Name = user.first_Name;
target.last_Name = user.last_Name;
target.address = user.address;
db.SaveChanges();
return(target.id);
}
}
