public bool AddUsers(UserLIstModel userLIstModel)
{
var P = new List <UserPhone>();
foreach (var item in userLIstModel.Phone)
{
P.Add(new UserPhone {
Phone = item.ToString()
});
}
var a = _context.UserList.Select(x => x).Count();
_context.UserList.Add(new DbModels.UserLists
{
DateOfBirth = userLIstModel.DateOfBirth,
Name = userLIstModel.Name,
Surname = userLIstModel.Surname,
Nationaly = userLIstModel.Nationaly,
PayrollCurrency = userLIstModel.PayrollCurrency,
PersonalNumber = userLIstModel.personalnumber,
Salary = userLIstModel.Salary,
UserPhone = P,
});
_context.SaveChanges();
return(true);
}
public IActionResult UserList(UserLIstModel userLIstModel)
{
var result = _services.GetUser(userLIstModel);
return(View(result));
}
public bool Edit(UserLIstModel userLIstModel)
{
var u = _context.UserList.FirstOrDefault(x => x.Id == userLIstModel.Id);
u.Id = userLIstModel.Id;
u.Name = userLIstModel.Name;
u.Surname = userLIstModel.Surname;
u.PersonalNumber = userLIstModel.personalnumber;
u.PayrollCurrency = userLIstModel.PayrollCurrency;
u.DateOfBirth = userLIstModel.DateOfBirth;
u.Nationaly = userLIstModel.Nationaly;
u.Salary = userLIstModel.Salary;
u.UserPhone = userLIstModel.Phone.Select(p => new UserPhone {
Phone = p
}).ToList();
_context.SaveChanges();
return(true);
}
public List <UserLIstModel> GetUser(UserLIstModel UserLIstModel)
{
var result = new List <UserLIstModel>();
//result = (from P in _context.UserPhone
// join u in _context.UserList on P.UserListId equals u.Id
// select new UserLIstModel
result = _context.UserList.Select(u => new UserLIstModel
{
Id = u.Id,
Name = u.Name,
Surname = u.Surname,
DateOfBirth = u.DateOfBirth,
Nationaly = u.Nationaly,
PayrollCurrency = u.PayrollCurrency,
personalnumber = u.PersonalNumber,
Salary = u.Salary,
Phone = u.UserPhone.Select(x => x.Phone).ToList(),
}).ToList();
return(result);
}
public JsonResult Edit(UserLIstModel userLIstModel)
{
var result = _services.Edit(userLIstModel);
return(Json(result));
}
