public ActionResult Accept(int?id, int?tripinfoid)
{
//Update requests
RequestRepository reqRepo = new RequestRepository();
Request request = reqRepo.GetById(id);
request.Response = 1;
reqRepo.UpdateRequest(request);
//Update trip information
TripInformationRepository tripInfoRepo = new TripInformationRepository();
TripInformation tripInfo = tripInfoRepo.GetById(tripinfoid);
tripInfo.Users.Add(request.User);
tripInfo.Capacity--;
//Added instead of update repo
string sql = "update TripInformation set Capacity=@P0 where TripInformationId=@P1";
List <object> parameterList1 = new List <object>();
//User user = (User)Session["__user"];
parameterList1.Add(tripInfo.Capacity);
parameterList1.Add(tripInfo.TripInformationId);
object[] parameters1 = parameterList1.ToArray();
int result = db.Database.ExecuteSqlCommand(sql, parameters1);
//tripInfoRepo.UpdateTripInformation(tripInfo);//Error when executing this line
return(RedirectToAction("Index", "Request"));
}
public ActionResult SendRequest(int id)
{
ViewBag.from = TempData["from"];
ViewBag.to = TempData["to"];
ViewBag.time = TempData["time"];
//Modify TripInfo database
User user = UserAccountsManager.Instance.CurrentUser;
TripInformationRepository tripRepo = new TripInformationRepository();
TripInformation tripInfo = tripRepo.GetById(id);
Request request = new Request();
request.User = user;
request.From = ViewBag.from;
request.To = ViewBag.to;
request.Response = 0;
request.StartTime = Convert.ToDateTime(ViewBag.time);
request.TripInformation = tripInfo;
request.Owner = tripInfo.Owner;
//RequestRepository requestRepo = new RequestRepository();
// requestRepo.CreateRequest(request);//Error when executing this line. Solved the StackOverflow exception
string sql = "insert into Request ([To],[From],StartTime,Response,Owner_UserId,User_UserId,TripInformation_TripInformationId) values (@p0,@p1,@p2,@p3,@p4,@p5,@p6)";
List <object> parameterList1 = new List <object>();
parameterList1.Add(request.To);
parameterList1.Add(request.From);
parameterList1.Add(request.StartTime);
parameterList1.Add(request.Response);
parameterList1.Add(request.Owner.UserId);
parameterList1.Add(request.User.UserId);
parameterList1.Add(request.TripInformation.TripInformationId);
object[] parameters = parameterList1.ToArray();
int result = db.Database.ExecuteSqlCommand(sql, parameters);
return(View());
}