public UserAccunt(string UserName)
{
InitializeComponent();
this.DataContext = this;
MyDb = new MyDbContext();
_user = MyDb.Users.Where(x => x.UserName == UserName).FirstOrDefault();
Shelves = new ObservableCollection <Tbshelve> (MyDb.Shelves.Where(x => x.UserId == _user.Id).ToList());
}
public Librery(string UserName)
{
InitializeComponent();
this.DataContext = this;
MyDb = new MyDbContext();
_user = MyDb.Users.Where(x => x.UserName == UserName)
.FirstOrDefault();
SelectedShelve = new Tbshelve();
SelectedBook = new tbBook();
/// Shelves = new ObservableCollection<Tbshelve>(MyDb.Shelves.Where(x => x.UserId == _user.Id).ToList());
///
}
public static TbuserDto FromModel(Tbuser model)
{
return(new TbuserDto()
{
IdUser = model.IdUser,
CodUser = model.CodUser,
LoginUser = model.LoginUser,
NomPrenUser = model.NomPrenUser,
NumTel = model.NumTel,
SexUser = model.SexUser,
AdrUser = model.AdrUser,
Password = model.Password,
DatFonc = model.DatFonc,
IdTypeUser = model.IdTypeUser,
ProfilId = model.ProfilId,
AgentId = model.AgentId,
DateDebutValidite = model.DateDebutValidite,
DateFinValidite = model.DateFinValidite,
DateDerniereModificationPassword = model.DateDerniereModificationPassword,
InitUserPassword = model.InitUserPassword,
NbreEchecsOuvertureSession = model.NbreEchecsOuvertureSession,
DateDerniereConnexion = model.DateDerniereConnexion,
DerniereConnexionReussie = model.DerniereConnexionReussie,
DateDernierVerrouillage = model.DateDernierVerrouillage,
Email = model.Email,
StatutSession = model.StatutSession,
Hostname = model.Hostname,
ModifieLe = model.ModifieLe,
ModifiePar = model.ModifiePar,
StateCode = model.StateCode,
StatusCode = model.StatusCode,
DateCreation = model.DateCreation,
Agent = TbagentDto.FromModel(model.Agent),
IdTypeUserNavigation = TbtypeUserDto.FromModel(model.IdTypeUserNavigation),
Profil = TbprofilDto.FromModel(model.Profil),
TbspecialiteUser = model.TbspecialiteUser,
TbuserDossier = model.TbuserDossier,
});
}
public string DeleteEmpInfo(Tbuser objEmployee)
{
_db.Remove(objEmployee);
_db.SaveChanges();
return("Delete");
}
public string UpdateEmployee(Tbuser objEmmployee)
{
_db.Tbuser.Update(objEmmployee);
_db.SaveChanges();
return("update");
}
public Tbuser GetEmployeeById(int id)
{
Tbuser employee = _db.Tbuser.FirstOrDefault(s => s.Iduser == id);
return(employee);
}
public string Create(Tbuser objEmployee)
{
_db.Tbuser.Add(objEmployee);
_db.SaveChanges();
return("Success");
}
