public Rating Get(int id)
{
using (C2CthesisEntities entities = new C2CthesisEntities())
{
return(entities.Ratings.FirstOrDefault(e => e.RatingID == id));
}
}
public IEnumerable <Rating> Get()
{
using (C2CthesisEntities entities = new C2CthesisEntities())
{
return(entities.Ratings.ToList());
}
}
public String Get(String phone)
{
using (C2CthesisEntities entities = new C2CthesisEntities())
{
return(entities.Users.FirstOrDefault(e => e.UserPhonenumber == phone).UserPoint.ToString());
}
}
public IEnumerable <User> Get()
{
using (C2CthesisEntities entities = new C2CthesisEntities())
{
return(entities.Users.ToList());
}
}
public async Task <IHttpActionResult> PostUser(User user)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (C2CthesisEntities entities = new C2CthesisEntities())
{
entities.Users.Add(user);
await entities.SaveChangesAsync();
}
return(CreatedAtRoute("DefaultApi", new { id = user.UserPhonenumber }, user));
}
// POST api/rating
public String Post([FromBody] string value)
{
//Result return the result of API
String resultReturn = "";
//Rating + Rated + Point
String[] splitInput = value.Split('*');
String UserRatingPhone = splitInput[0];
String UserRatedPhone = splitInput[1];
double RatingPoint = Double.Parse(splitInput[2], System.Globalization.CultureInfo.InvariantCulture);
//String UserRatingPhone = "123";
//String UserRatedPhone = "345";
//double RatingPoint = 1;
User RatedUser = new User();
resultReturn = resultReturn + " " + UserRatingPhone + " " + UserRatedPhone + " " + RatingPoint.ToString() + " EndInit ";
using (C2CthesisEntities entities = new C2CthesisEntities())
{
//resultReturn = resultReturn + " In Using Entity ";
//Check if User Rating exist in Database
if (!entities.Users.Any(o => o.UserPhonenumber.Equals(UserRatingPhone)))
{
//resultReturn = resultReturn + " Check User Rating exist Db ";
User newRatingUser = new User();
newRatingUser.UserPhonenumber = UserRatingPhone;
newRatingUser.UserPoint = -1;
entities.Users.Add(newRatingUser);
}
//Check if User Rated not exist in Db
if (!entities.Users.Any(o => o.UserPhonenumber.Equals(UserRatedPhone)))
{
//resultReturn = resultReturn + " Check User Rated exist Db ";
User newRatedUser = new User();
newRatedUser.UserPhonenumber = UserRatedPhone;
newRatedUser.UserPoint = RatingPoint;
entities.Users.Add(newRatedUser);
}
else
//If User Rated already exist in Db
{
RatedUser = entities.Users.FirstOrDefault(o => o.UserPhonenumber.Equals(UserRatedPhone));
resultReturn += "ChangePoint " + RatedUser.UserPoint;
RatedUser.UserPoint = Math.Round((RatedUser.UserPoint + RatingPoint) / 2, 2);
resultReturn += " to " + RatedUser.UserPoint;
}
//Add Rating to Database
Rating newRating = new Rating();
newRating.RatingUserrating = UserRatingPhone;
newRating.RatingUserrated = UserRatedPhone;
newRating.RatingPoint = RatingPoint;
newRating.RatingDate = System.DateTime.Now;
entities.Ratings.Add(newRating);
entities.SaveChanges();
resultReturn = resultReturn + " End Using ";
}
resultReturn = resultReturn + "Out";
return(resultReturn);
}
