public dynamic UpdatePassword(string email, string password)
{
//var query = from user in tblUser where user.email == email select user;
var query = db.tblUsers.Find(email);
query.userpassword = password;
db.Entry(query).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Valid"));
}
public IHttpActionResult PutUser(int id, User user)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//if (id != user.ID)
//{
// return BadRequest();
//}
db.Entry(user).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!UserExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Putemployee(int id, employee employee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != employee.eid)
{
return(BadRequest());
}
db.Entry(employee).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!employeeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutTour(int id, Tour tour)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tour.ID)
{
return(BadRequest());
}
db.Entry(tour).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TourExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public dynamic ApproveRetailer(int retailerid, string retaileremail)
{
var retailer = db.tblRetailers.Find(retailerid);
retailer.approved = 1;
db.Entry(retailer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Approved"));
}
public HttpResponseMessage changeUserPassword(string useremail, string userpassword, string newpassword)
{
if (CheckEmail1(useremail, userpassword))
{
var query = db.tblUsers.Find(useremail);
query.userpassword = newpassword;
db.Entry(query).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "valid"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, "invalid"));
}
}
public HttpResponseMessage ChangePass(string retaileremail, string retailerpassword, string newpassword)
{
if (CheckRetailer(retaileremail, retailerpassword))
{
int retailerid = getid(retaileremail, retailerpassword);
if (retailerid != 0)
{
var query = db.tblRetailers.Find(retailerid);
query.retailerpassword = newpassword;
db.Entry(query).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "valid"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, "invalid"));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, "invalid"));
}
}
public void Update(tbl_Category category)
{
db.Entry(category).State = EntityState.Modified;
}
public void Update(tbl_Location location)
{
db.Entry(location).State = EntityState.Modified;
}
public void Update(tbl_User user)
{
db.Entry(user).State = EntityState.Modified;
}
public void Update(tbl_GroundBooking booking)
{
db.Entry(booking).State = EntityState.Modified;
Save();
}
public void Update(tbl_Ground ground)
{
db.Entry(ground).State = EntityState.Modified;
Save();
}