public IHttpActionResult edit(int Id) { AthiraEntities1 db = new AthiraEntities1(); Login logs = db.Logins.Where(c => c.Id == Id).FirstOrDefault(); return(Ok(logs)); }
public IHttpActionResult PassCheck(string ide, string pw) { AthiraEntities1 db = new AthiraEntities1(); Login api = new Login(); using (var ctx = new AthiraEntities1()) { api = (from n in ctx.Logins where n.Name == ide && n.Password == pw select n).FirstOrDefault(); if (api.Name != null) { //api.Name = ide; //api.Password=pw; string Ntoken = Guid.NewGuid().ToString(); DateTime issueon = DateTime.Now; DateTime expiredon = DateTime.Now.AddSeconds(50000000); api.AuthToken = Ntoken; api.IssuedOn = issueon; api.ExpiredOn = expiredon; db.Entry(api).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } return(Ok()); }
public Login GenereteToken(string usrname, string password) { AthiraEntities1 db = new AthiraEntities1(); //Login obj = new Login(); Login obj = db.Logins.Where(c => c.Name == usrname).FirstOrDefault(); if (obj != null) { if (obj.Password == password) { string token = Guid.NewGuid().ToString(); DateTime IssuedOn = DateTime.Now; DateTime ExpiredOn = DateTime.Now.AddSeconds(50000000); var TokenKey = new TokenEntity() { Name = usrname, AuthToken = token, IssuedOn = IssuedOn, ExpiresOn = ExpiredOn }; // obj.Id = Id; //obj.Name = TokenKey.Name; //obj.Password = TokenKey.Password; obj.AuthToken = TokenKey.AuthToken; obj.IssuedOn = TokenKey.IssuedOn; obj.ExpiredOn = TokenKey.ExpiresOn; db.Logins.Add(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } //} //AthiraEntities1 db = new AthiraEntities1(); //Login api = new Login(); //using (var ctx = new AthiraEntities1()) //{ // api = (from n in ctx.Logins where n.Name == usrname && n.Password == password select n).FirstOrDefault(); // if (api.Name != null) // { // //api.Name = ide; // //api.Password=pw; // string Ntoken = Guid.NewGuid().ToString(); // DateTime issueon = DateTime.Now; // DateTime expiredon = DateTime.Now.AddSeconds(50000000); // api.AuthToken = Ntoken; // api.IssuedOn = issueon; // api.ExpiredOn = expiredon; // db.Entry(api).State = System.Data.Entity.EntityState.Modified; // db.SaveChanges(); // } //} } return(obj); }
public IHttpActionResult delete(int Id) { AthiraEntities1 db = new AthiraEntities1(); Login log = db.Logins.Where(c => c.Id == Id).FirstOrDefault(); db.Logins.Remove(log); db.SaveChanges(); return(Ok("Sucess")); }
public IHttpActionResult edit(Login obj) { AthiraEntities1 db = new AthiraEntities1(); Login logs = db.Logins.Where(c => c.Id == obj.Id).FirstOrDefault(); db.Entry(logs).CurrentValues.SetValues(obj); db.SaveChanges(); return(Ok("sucess")); }
public IHttpActionResult GetStudentById(int Id) { AthiraEntities1 db = new AthiraEntities1(); Login log = db.Logins.Where(c => c.Id == Id).FirstOrDefault(); if (log != null) { return(Ok(log)); } else { return(Ok("No students found")); } }
public MyCustomResult GetAllStudentsEntities(int Id) { AthiraEntities1 db = new AthiraEntities1(); Login log = db.Logins.Where(c => c.Id == Id).FirstOrDefault(); if (log != null) { return(new MyCustomResult(log.Name, Request, HttpStatusCode.OK)); } else { return(new MyCustomResult("invalid id", Request, HttpStatusCode.NotFound)); } }
public bool ValidateToken(string token) { AthiraEntities1 db = new AthiraEntities1(); TokenEntity tok = new TokenEntity(); Login log = db.Logins.Where(c => c.AuthToken == token).FirstOrDefault(); if (log.AuthToken != null) { return(true); } else { return(false); } }
public IHttpActionResult Insert(Login person) { AthiraEntities1 db = new AthiraEntities1(); // Login obj = new Login(); //obj.Id = Id; //obj.Name = Name; //obj.Password = Password; //db.Logins.Add(obj); //db.SaveChanges(); Login log = db.Logins.Where(c => c.Id == person.Id).FirstOrDefault(); db.Logins.Add(person); db.SaveChanges(); return(Ok("Sucess")); }
public IHttpActionResult GetAllStudents() { List <Login> Logins = new List <Login>(); using (var context = new AthiraEntities1()) { Logins = context.Logins.ToList(); } if (Logins.Count > 0) { return(Ok(Logins)); } else { return(Ok("No students found")); } }