protected void lnk_View_Click(object sender, EventArgs e)
{
int restId = Convert.ToInt32((sender as LinkButton).CommandArgument);
RestaurantBLL rBLL = new RestaurantBLL();
Restaurant restaurant = rBLL.DoRetrieveRestaurantByRestID(restId);
txtRName.Text = restaurant.RestName;
DataTable dt = new DataTable();
PromoBLL promoBLL = new PromoBLL();
dt = promoBLL.DoRetrieveAllPromoByRestId(restId);
panelViewPromo.Visible = true;
if (dt != null)
{
gv_promo.DataSource = dt;
gv_promo.DataBind();
}
else
{
alertFailure.Visible = true;
lblErrorRetrieve.Text = "Error in retrieving food item list";
}
}
public async Task <IActionResult> PutRestaurant([FromBody] Restaurant restaurant)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
RestaurantBLL BLL = new RestaurantBLL(_context);
return(Ok(await BLL.UpdateRestaurant(restaurant)));
}
catch (DbUpdateConcurrencyException ex)
{
if (!RestaurantExists(restaurant.Id))
{
return(NotFound());
}
else
{
return(BadRequest(ex.Message));
}
}
}
public ActionResult FoodItemCreate(FoodItem iFoodItem)
{
if (ModelState.IsValid)
{
// Instantiates objects
RestaurantBLL lRestaurantBLL = new RestaurantBLL();
RestaurantMapper lRestaurantMapper = new RestaurantMapper();
// map Model object to database object
FoodItemDBO lFoodItemDBO = lRestaurantMapper.MapModelToDBO(iFoodItem);
// get a unique food item id as return value
int lFoodItemIDPK = lRestaurantBLL.CreateFoodItem(lFoodItemDBO);
// success
if (lFoodItemIDPK > 0)
{
return(Json(new { success = true, blank = "" }));
}
}
else
{
// check errors
//var errors = ModelState.Values.SelectMany(v => v.Errors);
}
return(Json(new { success = false }));
}
protected void lnk_ViewStaff_Click(object sender, EventArgs e)
{
int restId = Convert.ToInt32((sender as LinkButton).CommandArgument);
RestaurantBLL rBLL = new RestaurantBLL();
Restaurant restaurant = rBLL.DoRetrieveRestaurantByRestID(restId);
StaffBLL staffBLL = new StaffBLL();
DataTable dt = new DataTable();
panelViewStaff.Visible = true;
lblRestName.Text = restaurant.RestName;
dt = staffBLL.DoRetrieveStaffByRestID(restId);
if (dt != null)
{
gv_viewStaff.DataSource = dt;
gv_viewStaff.DataBind();
}
else
{
alertFailure.Visible = true;
lblErrorRetrieve.Text = "Error in retrieving staff list";
}
}
public ActionResult UserProfile(int id, Common notice)
{
// Instantiate objects
UserBLL lUserBLL = new UserBLL();
UserMapper lUserMapper = new UserMapper();
BoardBLL lBoardBLL = new BoardBLL();
RestaurantBLL lRestaurantBLL = new RestaurantBLL();
BoardCommentBLL lBoardCommentBLL = new BoardCommentBLL();
// Instantiate object to hold all info about user
UserRestaurantBoardUtil lUserAllData = new UserRestaurantBoardUtil();
// Get info about user with id
lUserAllData.UserData = lUserBLL.FindUserByID(id);
// Get info about board with user id
lUserAllData.BoardList = lBoardBLL.GetAllBoardsByUserID(id);
lUserAllData.BoardCommentList = lBoardCommentBLL.GetAllCommentsByUserID(id);
// Get info about order with user id
lUserAllData.OrderList = lRestaurantBLL.GetAllOrdersByUserID(id);
// number of rows per page
lUserAllData.PageSize = 10;
return(View(lUserAllData));
}
public Result Logout(MODEL.Criteria.reqTable req)
{
Result result = new Result();
result.ResultOk = "false";
RestaurantBLL sv = new RestaurantBLL();
DAL.Restaurant svDAL = new DAL.Restaurant();
//DAL.StringCipher sv = new DAL.StringCipher();
try
{
///Check User
Result UserComplete = svDAL.checkOrderNotComplete(req.userID);
if (UserComplete.ResultOk == "true")
{
result.ResultOk = "false";
result.ErrorMessage = "User not pay !!!";
result.ReturnMessage = "";
return(result);
}
Result CancelTable = svDAL.cancelTable(req);
result = CancelTable;
}
catch (Exception e)
{
result.ErrorMessage = e.Message;
result.ResultOk = "false";
result.ReturnMessage = "";
}
return(result);
}
public Result cancelOrder([FromBody] MODEL.Criteria.reqOrder req)
{
Result result = new Result();
result.ResultOk = "false";
RestaurantBLL sv = new RestaurantBLL();
try
{
result = sv.cancelOrder(req);
//Veriy Data
//result.ResultOk = "Success";
//for (int i = 0; i < req.listFood.Count; i++)
//{
// result.ReturnMessage += req.listFood[i].foodID + ",";
//}
//if (req != null)
//{
//return sv.InsertMenu(req);
//}
}
catch (Exception e)
{
result.ErrorMessage = e.Message;
result.ResultOk = "false";
result.ReturnMessage = "";
}
return(result);
}
public ActionResult SendOrders(int id)
{
// Instantiate Object
RestaurantBLL lRestaurantBLL = new RestaurantBLL();
bool isSent = lRestaurantBLL.sendOrdersByRestaurantID(id);
return(PartialView());
}
public Result insertOrder([FromBody] MODEL.Criteria.reqOrder req)
{
Result result = new Result();
result.ResultOk = "false";
RestaurantBLL sv = new RestaurantBLL();
try
{
result = sv.insertOrder(req);
//Result OrderStatus = sv.getStatusOrder(req.restaurantID, req.tableID);
//if (OrderStatus.ResultOk == "false")
//{
// result = sv.insertOrder(req);
//}
//else
//{
// switch (OrderStatus.ReturnMessage)
// {
// case "1":
// result.ResultOk = "false";
// result.ErroMessage = "Table is open";
// result.ReturnMessage = "";
// break;
// case "2":
// result.ResultOk = "false";
// result.ErroMessage = "Table is bill please";
// result.ReturnMessage = "";
// break;
// default:
// result = sv.insertOrder(req);
// break;
// }
//}
//Veriy Data
//result.ResultOk = "Success";
//for (int i = 0; i < req.listFood.Count; i++)
//{
// result.ReturnMessage += req.listFood[i].foodID + ",";
//}
//if (req != null)
//{
//return sv.InsertMenu(req);
//}
}
catch (Exception e)
{
result.ErrorMessage = e.Message;
result.ResultOk = "false";
}
return(result);
}
public ActionResult GetTopRatedOrder(int id)
{
// Instantiate Object
RestaurantBLL lRestaurantBLL = new RestaurantBLL();
// get the list of ratings
List <UserOrderRatingDBO> lUserOrderRating = lRestaurantBLL.GetTopRatedOrdersByRestaurantID(id);
return(PartialView(lUserOrderRating));
}
public ActionResult Index()
{
// instantiate object
RestaurantBLL lRestaurantBLL = new RestaurantBLL();
// Get list of restaurants
List <RestaurantDBO> lRestaurantList = lRestaurantBLL.GetAllActiveRestaurants();
return(View(lRestaurantList));
}
public ActionResult RestaurantRemove(int id)
{
// Instantiate BLL object
RestaurantBLL lRestaurantBLL = new RestaurantBLL();
// get result of bool if removal succeded
bool lResult = lRestaurantBLL.RemoveRestaurantByRestaurantID(id);
return(RedirectToAction("RestaurantList", "Restaurant"));
}
public PartialViewResult UserOrderDetails(int id)
{
// Instantiate BLL object
RestaurantBLL lRestaurantBLL = new RestaurantBLL();
// get list of food items for the order
List <FoodItemDBO> lFoodItemList = lRestaurantBLL.GetAllFoodItemsByOrderID(id);
return(PartialView("UserOrderDetails", lFoodItemList));
}
public ActionResult RestaurantList(string searchString)
{
// Instantitate BLL object
RestaurantBLL lRestaurantBLL = new RestaurantBLL();
RestaurantListUtil lRestaurantUtil = new RestaurantListUtil();
// Get the list of entrie restaurant
lRestaurantUtil.RestaurantList = lRestaurantBLL.GetAllRestaurants(searchString);
return(View(lRestaurantUtil));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["isLogin"] == null)
{
Response.Redirect("Login.aspx");
}
alertSuccess.Visible = false;
alertFailure.Visible = false;
panelChangePassword.Visible = false;
panelWorkplace.Visible = false;
if (!IsPostBack)
{
UserAccount user = (UserAccount)Session["UserAccountObj"];
txtSUsername.Text = user.Username;
StaffBLL staffBLL = new StaffBLL();
Staff staff = staffBLL.DoRetrieveStaffByID(user.UserId);
if (staff != null)
{
txtSName.Text = staff.StaffName;
if (user.UserRole.Equals("Staff"))
{
RestaurantBLL restaurantBLL = new RestaurantBLL();
Restaurant restaurant = restaurantBLL.DoRetrieveRestaurantByRestID(staff.RestId);
panelWorkplace.Visible = true;
if (restaurant != null)
{
txtRName.Text = restaurant.RestName;
txtRAddress.Text = restaurant.RestAddress;
txtRArea.Text = restaurant.RestArea;
}
else
{
alertFailure.Visible = true;
lblAlertMsg.Text = "Unable to retrieve staff profile";
}
}
}
else
{
txtSName.Text = "admin";
txtSName.Enabled = false;
btnChangePassword.Enabled = false;
btnDeactivate.Enabled = false;
btnUpdate.Enabled = false;
}
}
}
protected void lnk_AddStaff_Click(object sender, EventArgs e)
{
int restId = Convert.ToInt32((sender as LinkButton).CommandArgument);
RestaurantBLL rBLL = new RestaurantBLL();
Restaurant restaurant = rBLL.DoRetrieveRestaurantByRestID(restId);
panelCreateStaff.Visible = true;
lblCreateStaff.Text = "CREATING STAFF FOR RESTAURANT ID " + restId;
txtRestId.Text = restId.ToString();
txtRName.Text = restaurant.RestName;
}
public ActionResult RestaurantPayment()
{
// Instantiate objects
RestaurantBLL lRestaurantBLL = new RestaurantBLL();
// Do calculations
MeaningfulCalcUtil lCalcUtil = lRestaurantBLL.GetAllCalc();
// return the weeks and show on the left menu bar
return(View(lCalcUtil));
}
protected void btn_Review_Click(object sender, EventArgs e)
{
Orders od = new Orders();
OrdersBLL odbll = new OrdersBLL();
RestaurantBLL rbll = new RestaurantBLL();
od = odbll.DoRetrieveUserOrderDetails(int.Parse(txtOrderId.Text));
ReviewBLL reviewBLL = new ReviewBLL();
reviewBLL.DoCreateReview(od.OrderId, od.CId, od.RId, rbll.DoRetrieveRestIdByTransactionId(od.TransactionId), Convert.ToInt32(ddlRiderRating.SelectedValue), Convert.ToInt32(ddlRestaurantRating.SelectedValue), txtReview.Text);
Response.Redirect("UserRetrieveReview.aspx?orderid=" + od.OrderId);
}
protected void lnk_Update_Click(object sender, EventArgs e)
{
int restId = Convert.ToInt32((sender as LinkButton).CommandArgument);
RestaurantBLL rBLL = new RestaurantBLL();
Restaurant restaurant = rBLL.DoRetrieveRestaurantByRestID(restId);
panelUpdateRestaurant.Visible = true;
lblUpdateRestaurant.Text = "Updating Record for Restaurant ID: " + restaurant.RestId;
txtRestId.Text = restaurant.RestId.ToString();
txtRName.Text = restaurant.RestName;
txtRAddress.Text = restaurant.RestAddress;
ddlRArea.SelectedValue = restaurant.RestArea;
txtMinAmnt.Text = restaurant.MinAmnt.ToString();
}
public ActionResult RestaurantUpdate(Restaurant iRestaurant)
{
if (ModelState.IsValid)
{
// validation for price
if (!Decimal.TryParse(iRestaurant.SandwichPrice.ToString(), out decimal price))
{
return(View(iRestaurant));
}
// Instantiate objects
RestaurantBLL lRestaurantBLL = new RestaurantBLL();
RestaurantMapper lRestaurantMapper = new RestaurantMapper();
// Map Model to DB object
RestaurantDBO lRestaurantDBO = lRestaurantMapper.MapModelToDBO(iRestaurant);
// get result after update
bool lResult = lRestaurantBLL.UpdateRestaurantByRestaurantID(lRestaurantDBO);
if (lResult)
{
// success
TempData["msg"] = "<script>alert('Successfully Updated!')</script>";
return(RedirectToAction("RestaurantProfile", "Restaurant", new { id = lRestaurantDBO.RestaurantIDPK }));
}
else
{
// failure
TempData["msg"] = "<script>alert('Error occured while processing your request. Please try later.')</script>";
}
}
else
{
// model state not valid
TempData["msg"] = "<script>alert('Please Fill all Required Fields.')</script>";
}
// Add days to the list
iRestaurant.DayList = new List <string>();
iRestaurant.DayList.Add("Monday");
iRestaurant.DayList.Add("Tuesday");
iRestaurant.DayList.Add("Wednesday");
iRestaurant.DayList.Add("Thursday");
iRestaurant.DayList.Add("Friday");
iRestaurant.DayList.Add("Saturday");
iRestaurant.DayList.Add("Sunday");
return(View(iRestaurant));
}
public ActionResult RestaurantProfile(int id, string searchString)
{
// Instantiate objects
RestaurantBLL lRestaurantBLL = new RestaurantBLL();
RestaurantMapper lRestaurantMapper = new RestaurantMapper();
// Instantiate util object
RestaurantFoodsRatingUtil lRestaurantUtil = new RestaurantFoodsRatingUtil();
// Get info about a restaurant by restaurant id
lRestaurantUtil.Restaurant = lRestaurantBLL.FindRestaurantByRestaurantID(id);
// Get list of food items by restaurant id
lRestaurantUtil.FoodItemList = lRestaurantBLL.GetAllFoodItemsByRestaurantID(id);
// check if searchstring not null
if (!string.IsNullOrEmpty(searchString) && searchString != "reset")
{
lRestaurantUtil.FoodItemList = lRestaurantUtil.FoodItemList.Where(food => food.FoodItemName.ToLower().Contains(searchString) ||
food.FoodTypeName.ToLower().Contains(searchString) ||
food.IngredientTypeName.ToLower().Contains(searchString)).ToList();
// set current tab
ViewBag.tab = "nav-foods";
}
else
{
// if user reset search, populate food item list again
lRestaurantUtil.FoodItemList = lRestaurantBLL.GetAllFoodItemsByRestaurantID(id);
if (searchString == "reset")
{
// set current tab
ViewBag.tab = "nav-foods";
}
else
{
// set currert tab
ViewBag.tab = "nav-info";
}
}
// Get list of rating for restaurant by id
lRestaurantUtil.RatingList = lRestaurantBLL.GetAllRatingByRestaurantID(id);
lRestaurantUtil.RestaurantRating = lRestaurantBLL.GetRatingAverageByRestaurantID(id);
return(View(lRestaurantUtil));
}
public ActionResult OrderCheck(int id)
{
// Restaurant BLL objects
RestaurantBLL lRestaurantBLL = new RestaurantBLL();
// get list of orders for the restaurant within a week
List <UserOrderDBO> lUserOrderList = lRestaurantBLL.GetAllRecentOrdersByRestaurantID(id);
if (lUserOrderList.Count == 0)
{
TempData["msg"] = "<script>alert('No orders');</script>";
return(RedirectToAction("Index", "Restaurant"));
}
return(PartialView("OrderCheck", lUserOrderList));
}
public async Task <IActionResult> DeleteRestaurant([FromRoute] int id)
{
try
{
RestaurantBLL BLL = new RestaurantBLL(_context);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
return(Ok(await BLL.DeleteRestaurant(id)));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public ResultProfile updateProfile([FromBody] MODEL.ResultProfile req)
{
ResultProfile result = new ResultProfile();
result.ResultOk = "false";
RestaurantBLL sv = new RestaurantBLL();
try
{
result = sv.updateProfile(req);
}
catch (Exception e)
{
result.ErrorMessage = e.Message;
result.ResultOk = "false";
}
return(result);
}
public ResultRestaurantContent getFirstPage()
{
ResultRestaurantContent result = new ResultRestaurantContent();
result.ResultOk = "false";
RestaurantBLL sv = new RestaurantBLL();
try
{
result = sv.getFirstPage(null);
}
catch (Exception e)
{
result.ErrorMessage = e.Message;
result.ResultOk = "false";
}
return(result);
}
public ResultRestaurantContent getFirstPageByID(MODEL.Criteria.reqRestaurant req)
{
ResultRestaurantContent result = new ResultRestaurantContent();
result.ResultOk = "false";
RestaurantBLL sv = new RestaurantBLL();
try
{
result = sv.getFirstPage(req);
}
catch (Exception e)
{
result.ErrorMessage = e.Message;
result.ResultOk = "false";
}
return(result);
}
public ResultHistoryUser getHistoryUser(MODEL.Criteria.reqUser req)
{
ResultHistoryUser result = new ResultHistoryUser();
result.ResultOk = "false";
RestaurantBLL sv = new RestaurantBLL();
try
{
result = sv.getHistoryByUserID(req);
}
catch (Exception e)
{
result.ErrorMessage = e.Message;
result.ResultOk = "false";
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["isLogin"] == null)
{
Response.Redirect("Login.aspx");
}
panelViewRestaurants.Visible = false;
alertSuccess.Visible = false;
alertFailure.Visible = false;
panelUpdateRestaurant.Visible = false;
UserAccount user = (UserAccount)Session["UserAccountObj"];
if (!IsPostBack)
{
DataTable dt = new DataTable();
RestaurantBLL rBLL = new RestaurantBLL();
dt = rBLL.DoRetrieveAllRestaurants();
if (dt != null)
{
gv_restaurants.DataSource = dt;
gv_restaurants.DataBind();
}
else
{
alertFailure.Visible = true;
lblErrorRetrieve.Text = "Error in retrieving list";
}
}
if (!user.UserRole.Equals("Manager"))
{
lblUserDenied.Text = "YOU DO NOT HAVE MANAGER RIGHTS TO ACCESS THIS FUNCTION";
btnSearch.Enabled = false;
}
else
{
panelViewRestaurants.Visible = true;
}
}
public ActionResult RestaurantRegister(Restaurant iRestaurant)
{
if (ModelState.IsValid)
{
// Map Models.Restaurant to db objects
RestaurantMapper lRestaurantMapper = new RestaurantMapper();
RestaurantDBO lRestaurantDBO = lRestaurantMapper.MapModelToDBO(iRestaurant);
// insert mapped object into database
RestaurantBLL lRestaurantBLL = new RestaurantBLL();
int lRestaurantIDPK = lRestaurantBLL.CreateRestaurant(lRestaurantDBO);
if (lRestaurantIDPK > 0)
{
// success
ViewBag.msg = "<script>alert('Registered Successfully');</script>";
return(RedirectToAction("RestaurantList", "Restaurant"));
}
else
{
// failure
ViewBag.msg = "<script>alert('Registeration Failed');</script>";
}
}
else
{
//not valid model state
ViewBag.msg = "<script>alert('Not Valid Inputs');</script>";
}
// re-populate days to the list in case of failure
iRestaurant.DayList = new List <string>();
iRestaurant.DayList.Add("Monday");
iRestaurant.DayList.Add("Tuesday");
iRestaurant.DayList.Add("Wednesday");
iRestaurant.DayList.Add("Thursday");
iRestaurant.DayList.Add("Friday");
iRestaurant.DayList.Add("Saturday");
iRestaurant.DayList.Add("Sunday");
return(View(iRestaurant));
}
public ResultLogin Login([FromBody] MODEL.Criteria.reqLogin req)
{
ResultLogin result = new ResultLogin();
result.ResultOk = "false";
RestaurantBLL sv = new RestaurantBLL();
try
{
result = sv.getLoginGuest(req);
}
catch (Exception e)
{
result.ErroMessage = e.Message;
result.ResultOk = "false";
result.ReturnMessage = "";
}
return(result);
}
