public HttpResponseMessage put(int id, REVIEW review) { try { using (ReviewEntities entities = new ReviewEntities()) { var entity = entities.REVIEW.FirstOrDefault(e => e.ReviewId == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Review doesnt exist")); } else { entity.Rating = review.Rating; entity.Comment = review.Comment; entity.GenerateReviewId = review.GenerateReviewId; entity.EmployeeId = review.EmployeeId; entity.PerameterId = review.PerameterId; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult LogIn(User user) { using (var context = new ReviewEntities()) { FormsAuthentication.SetAuthCookie(user.Username, false); if (user.Username == "bala123" && user.Password == "Welcome123") { return(RedirectToAction("Index", "Home")); } else if (context.Organizations.Any(o => o.UserId == user.Username && o.Password == user.Password)) { var organization = context.Organizations.Single(o => o.UserId == user.Username && o.Password == user.Password); TempData["organizationId"] = organization.Id; return(RedirectToAction("Index", "Employees")); } else if (context.Employees.Any(e => e.Username == user.Username && e.Password == user.Password)) { var employee = context.Employees.Single(e => e.Username == user.Username && e.Password == user.Password); TempData["employeeId"] = employee.Id; return(RedirectToAction("Index", "Employee")); } ModelState.AddModelError("", "Invalid username and password"); return(View()); } }
public void GetItems() { using (ReviewEntities db = new ReviewEntities()) { db.Master_Table.ToList(); return; } }
public HttpResponseMessage get() { try { using (ReviewEntities entities = new ReviewEntities()) { return(Request.CreateResponse(HttpStatusCode.OK, entities.REVIEW.ToList())); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { Guid id = Guid.NewGuid(); model.Id = id; model.FirstName = fname.Text; model.LastName = lname.Text; model.Review = comments.InnerText; model.Date = DateTime.Now; using (ReviewEntities db = new ReviewEntities()) { db.Master_Table.Add(model); db.SaveChanges(); } } }
public HttpResponseMessage post([FromBody] REVIEW review) { try { using (ReviewEntities entities = new ReviewEntities()) { entities.REVIEW.Add(review); entities.SaveChanges(); HttpResponseMessage message = Request.CreateResponse(HttpStatusCode.Created, review); message.Headers.Location = new Uri(Request.RequestUri + review.ReviewId.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage get(int id) { try { using (ReviewEntities entities = new ReviewEntities()) { REVIEW review = entities.REVIEW.FirstOrDefault(e => e.ReviewId == id); if (review != null) { return(Request.CreateResponse(HttpStatusCode.OK, review)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No entity with id " + id + "found!")); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage delete(int id) { try { using (ReviewEntities entities = new ReviewEntities()) { var entity = entities.REVIEW.FirstOrDefault(e => e.ReviewId == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Review doesnt exist")); } else { entities.REVIEW.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }