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));
}
}
