public void UpdateUser(IUserView usr)
{
tbl_Usr User = (from u in MerpDatabase().tbl_Usr where u.Usr_ == usr.UsrId select u).Single();
User.Usr_ = usr.UsrId;
User.UsrName = usr.UsrName;
User.UsrLogedin = usr.UsrLogedIn;
User.UsrPassword = usr.UsrPassword;
User.UsrIdent = usr.UsrIdent;
MerpDatabase().SaveChanges();
}
public static IUserView UserByIdent(string usrident)
{
var query = (from usr in MerpDatabase().tbl_Usr where usr.UsrIdent == usrident select usr);
tbl_Usr usre = query.FirstOrDefault();
if (usre != null)
{
IUserView Userli2 = UserFactory.CreateUser(usre.Usr_, usre.UsrNumber, usre.UsrName, usre.UsrIdent, usre.UsrIsEmployer,
usre.UsrPassword, usre.UsrLogedin);
return(Userli2);
}
return(null);
}
public void AddUser(IUserView usr)
{
tbl_Usr User = new tbl_Usr();
User.Usr_ = usr.UsrId;
User.UsrName = usr.UsrName;
User.UsrLogedin = usr.UsrLogedIn;
User.UsrPassword = usr.UsrPassword;
User.UsrIdent = usr.UsrIdent;
MerpDatabase().tbl_Usr.AddObject(User);
try {
MerpDatabase().SaveChanges();
} catch (Exception e) {
}
}
