public static List <APP_USER> SelectUser()
{
//get list of all persons
List <APP_USER> persons = new List <APP_USER>();
try
{
using (UserDbEntities context = new UserDbEntities())
{
persons = context.APP_USER.ToList().Select(x => new APP_USER()
{
ID = x.ID,
FIRSTNAME = x.FIRSTNAME,
LASTNAME = x.LASTNAME,
BIRTHDATE = x.BIRTHDATE,
HEIGHT = x.HEIGHT,
}).ToList();
}
}
catch (Exception ex)
{
throw new Exception("erreur", ex);
}
return(persons);
}
public ActionResult UserDetails(int?UsersID)
{
if (Session["LogedUserID"] == null)
{
return(RedirectToAction("Index", "Home"));
}
UserDbEntities db = new UserDbEntities();
if (UsersID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var tasks = db.Tasks.Where(x => x.UserID == UsersID);
var finishedTasks = db.FinishedTasks.Where(x => x.UserID == UsersID);
var model = new WebOrganizer.Models.myModel.AllTasks()
{
Tasks = tasks.ToList(),
FinishedTasks = finishedTasks.ToList()
};
if (model.Tasks == null)
{
return(HttpNotFound());
}
return(View(model));
}
public ActionResult Urites()
{
using (UserDbEntities db = new UserDbEntities())
{
var urites = db.Urites();
}
return(View());
}
public JsonResult IsDuplicateDisplayName(string displayname)
{
UserDbEntities db = new UserDbEntities();
var data = from item in db.Users
where item.DisplayName == displayname
select item;
bool flag = false;
if (data.Count() > 0)
{
flag = true;
}
return(Json(flag));
}
public JsonResult IsDuplicateEmail(string email)
{
UserDbEntities db = new UserDbEntities();
var data = from item in db.Users
where item.Email == email
select item;
bool flag = false;
if (data.Count() > 0)
{
flag = true;
}
return(Json(flag));
}
public ActionResult Index(User user)
{
if (ModelState.IsValid)
{
UserDbEntities db = new UserDbEntities();
db.Users.AddObject(user);
db.SaveChanges();
return(View("Success"));
}
else
{
return(View("Index", user));
}
}
public ActionResult Login(User u)
{
UserDbEntities dc = new UserDbEntities();
var v = dc.Users.Where(a => a.Username.Equals(u.Username) && a.Password.Equals(u.Password)).FirstOrDefault();
if (v != null)
{
Session["LogedUserID"] = v.UserID.ToString();
Session["LogedUsername"] = v.Username.ToString();
return(RedirectToAction("AfterLogin"));
}
return(View(u));
}
public static APP_USER Add(APP_USER oModel)
{
try
{
using (UserDbEntities oContext = new UserDbEntities())
{
oContext.APP_USER.Add(oModel);
oContext.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception("erreur", ex);
}
return(oModel);
}
// GET: SQL
public ActionResult Index()
{
// A tbl_User2 tábla lekérése
UserDbEntities db = new UserDbEntities();
IQueryable <tbl_User2> user2Query =
from U2 in db.tbl_User2
select U2;
//Hiányzó adatok lekérése
var r1 = db.Adatmigracio_test().ToList();
string E1 = null;
string E2 = null;
DateTime D1 = DateTime.Now;
if (r1.Count > 0)
{
//Ha történt
E1 = "Adatmásolás";
E2 = "Megtörtént";
}
else
{
//Ha nem történt
E1 = "Adatmásolás";
E2 = "Nincs új rekord";
}
//Logolás
var futtatas2 = db.Logolas2(E1, E2, D1);
//Az Adatmigráció tárolt eljárás futtatása
var futtatas = db.Adatmigracio();
//Adatátadás a View-nak
ViewBag.Esemeny = E1;
ViewBag.Eredmeny = E2;
ViewBag.Datum = D1;
ViewBag.SpR = r1;
return(View(user2Query));
}
public static List <APP_USER> Delete(int oId)
{
APP_USER oModel = new APP_USER();
try
{
using (UserDbEntities oContext = new UserDbEntities())
{
oModel = oContext.APP_USER.Find(oId);
oContext.APP_USER.Remove(oModel);
oContext.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception("erreur", ex);
}
return(SelectUser());
}
public async Task <HttpResponseMessage> Login([FromBody] AccountInfo info)
{
using (UserDbEntities entities = new UserDbEntities())
{
// Search user by ID, and then vaerify the password.
var entity = await entities.Users.FirstOrDefaultAsync(e => e.UserID == info.UserID);
if (entity != null)
{
BCryptUtil bCrypt = new BCryptUtil();
bool result = bCrypt.Verify(info.Password, entity.PasswordHash);
if (result)
{
JwtAuthUtil jwt = new JwtAuthUtil(entity.GUID.ToString());
// token for portal login
string accessToken = jwt.GenerateToken();
// return necessary information to the front end
return(Request.CreateResponse(HttpStatusCode.OK,
new
{
guid = entity.GUID.ToString().ToUpper(),
lifeQual = entity.SalesLifeQual.ToUpper(),
propQual = entity.SalesPropQual.ToUpper(),
access_token = accessToken
}));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Wrong password!!"));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "No such user!"));
}
}
}
public static APP_USER Update(APP_USER oModel, int ID)
{
try
{
using (UserDbEntities oContext = new UserDbEntities())
{
APP_USER userInDb = new APP_USER();
userInDb = oContext.APP_USER.Find(ID);
userInDb.FIRSTNAME = oModel.FIRSTNAME;
userInDb.LASTNAME = oModel.LASTNAME;
userInDb.BIRTHDATE = oModel.BIRTHDATE;
userInDb.HEIGHT = oModel.HEIGHT;
oContext.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception("erreur", ex);
}
return(oModel);
}
