public ActionResult Show(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Customer customer = db.Customers.SqlQuery("select * from customers where CustomerId=@id", new SqlParameter("@id", id)).FirstOrDefault(); if (customer == null) { return(HttpNotFound()); } string ShowAllReviews = "select * from Reviews where CustomerId = @id"; SqlParameter param = new SqlParameter("@id", id); List <Review> RecentReviews = db.Reviews.SqlQuery(ShowAllReviews, param).ToList(); string ShowReviewedComics = "select * from comics inner join reviews on comics.comicid = reviews.comicid where CustomerId = @id"; SqlParameter param2 = new SqlParameter("@id", id); List <Comic> ReviewedComics = db.Comics.SqlQuery(ShowReviewedComics, param2).ToList(); ShowCustomer viewmodel = new ShowCustomer(); viewmodel.Customer = customer; //display the chosen customer viewmodel.Reviews = RecentReviews; //display the reviews customer made viewmodel.Comics = ReviewedComics; return(View(viewmodel)); //To do: Display reviews customer made }
public ActionResult Show(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Customer customer = db.Customers.SqlQuery("select * from customers where customerid=@CustomerID", new SqlParameter("@CustomerID", id)).FirstOrDefault(); string second_query = "Select * from invoices join customers on customers.customerid=invoices.customerid where customers.customerid=@CustomerID"; SqlParameter sqlparam = new SqlParameter("@CustomerID", id); List <Invoice> CustomerInvoices = db.Invoices.SqlQuery(second_query, sqlparam).ToList(); ShowCustomer viewmodel = new ShowCustomer(); viewmodel.customer = customer; viewmodel.invoices = CustomerInvoices; return(View(viewmodel)); }
/// <summary> /// To gather information of particular customer with selected customerID /// </summary> /// <param name="id">CustomerID</param> /// <returns>Return particular customer information. Using View Modal, set a limit on what can be view by the client side and also able to set [DisplayName] to change the column name that will appaered in the View. </returns> // GET: Customer/Details/5 public ActionResult Details(int id) { ShowCustomer ViewModel = new ShowCustomer(); string findcustomerurl = "customerdata/findcustomer/" + id; HttpResponseMessage findcustomerresponse = client.GetAsync(findcustomerurl).Result; if (findcustomerresponse.IsSuccessStatusCode) { //Sending findcustomerresponse request to data controller, //if request send succeed (status code 200), Please retienve me this customer information (based on CustomerDto.) //If failed, direct to Error action (View) CustomerDto SelectedCustomer = findcustomerresponse.Content.ReadAsAsync <CustomerDto>().Result; ViewModel.customer = SelectedCustomer; return(View(ViewModel)); } else { return(RedirectToAction("Error")); } }
static void Main(string[] args) { if (SQL.CheckConnection()) { SQL.CreateDatabase(); } int homeChoice, typeChoice, usrActionChoice, admActionChoice, newOldChoice; Customer customer; do { homeChoice = PickStart.View(); if (homeChoice == 0) { typeChoice = PickUserType.View(); if (typeChoice == 0) { newOldChoice = PickNewOrOldCustomer.View(); if (newOldChoice == 0) { customer = CustomerLogin.View(); } else { customer = CreateCustomer.View(); } ShowCustomer.View(customer); do { usrActionChoice = PickCustomerActions.View(); switch (usrActionChoice) { case 0: CreateBooking.View(customer); break; case 1: ShowCustomerBookings.View(customer); break; case 2: customer = UpdateCustomer.View(customer); break; case 3: Delete.Customer(customer.CustomerId); usrActionChoice = 4; break; default: break; } } while (usrActionChoice != 4); } else if (typeChoice == 1) { do { admActionChoice = PickAdminActions.View(); switch (admActionChoice) { case 0: CreateMovie.View(); break; case 1: ShowCustomers.View(); break; default: break; } } while (admActionChoice != 2); } } } while (homeChoice == 0); }