/// <summary> /// method for reading the order /// </summary> public void Read() { // input and validation Console.WriteLine("Input code of record you want to view"); bool isValid = int.TryParse(Console.ReadLine(), out int code); while (isValid == false) { Console.WriteLine("Wrong input, please try again."); isValid = int.TryParse(Console.ReadLine(), out code); } try { using (RestaurantBraticGacinovicEntities context = new RestaurantBraticGacinovicEntities()) { // finding the order in the database with ID tblRecord recordToView = (from x in context.tblRecords where x.Code == code select x).First(); List <tblOrder> list = (from x in context.tblOrders where x.RecordID == recordToView.RecordID select x).ToList(); // displaying the order foreach (var item in list) { Console.WriteLine(item.Article + " " + item.Quantity); } } } catch (Exception) { Console.WriteLine("Error"); } }
public List <tblRecord> getAllCash() { SqlDataReader reader = ReadData("delete from tblRecord"); List <tblRecord> dsSaleRe = new List <tblRecord>(); while (reader.Read()) { string id = reader.GetString(0); string descrip = reader.GetString(1); string price = reader.GetString(2); string quantity = reader.GetString(3); string totalsum = reader.GetString(4); string type = reader.GetString(5); string size = reader.GetString(6); string brand = reader.GetString(7); DateTime date = reader.GetDateTime(8); tblRecord sale = new tblRecord(); sale.ID = id; sale.Description = descrip; sale.Price = price; sale.Quantity = quantity; sale.TotalSum = totalsum; sale.Type = type; sale.Size = size; sale.Brand = brand; sale.DateTime = date; dsSaleRe.Add(sale); } reader.Close(); return(dsSaleRe); }
/// <summary> /// method for deleting the order /// </summary> public void Delete() { // inputs and validations Console.WriteLine("Input code of record you want to delete"); bool isValid = int.TryParse(Console.ReadLine(), out int code); while (isValid == false) { Console.WriteLine("Wrong input, please try again."); isValid = int.TryParse(Console.ReadLine(), out code); } try { // finding the order and deleting it from the database using (RestaurantBraticGacinovicEntities context = new RestaurantBraticGacinovicEntities()) { tblRecord recordToDelete = (from x in context.tblRecords where x.Code == code select x).First(); List <tblOrder> list = (from x in context.tblOrders where x.RecordID == recordToDelete.RecordID select x).ToList(); context.tblOrders.RemoveRange(list); context.tblRecords.Remove(recordToDelete); context.SaveChanges(); } } catch (Exception) { Console.WriteLine("Error"); } }
public List <tblRecord> search(string Desciption) { SqlDataReader reader = ReadData("Select * from tblRecord where Description like '" + Desciption + "%' Order by DateTime DESC"); List <tblRecord> dsSale = new List <tblRecord>(); while (reader.Read()) { string id = reader.GetString(0); string descrip = reader.GetString(1); string price = reader.GetString(2); string quantity = reader.GetString(3); string totalsum = reader.GetString(4); string type = reader.GetString(5); string size = reader.GetString(6); string brand = reader.GetString(7); DateTime date = reader.GetDateTime(8); tblRecord sale = new tblRecord(); sale.ID = id; sale.Description = descrip; sale.Price = price; sale.Quantity = quantity; sale.TotalSum = totalsum; sale.Type = type; sale.Size = size; sale.Brand = brand; sale.DateTime = date; dsSale.Add(sale); } reader.Close(); return(dsSale); }
public DetailsViewModel(tblRecord record, List <tblRating> ratings) { Record = record; RatingsList = ratings; if (RatingsList.Count() >= 1) { OverallRating = RatingsList.Select(x => x.Rating).Sum() / RatingsList.Count(); } else { OverallRating = 0; } }
public ActionResult Edit([Bind(Include = "RecordID, RecordName, RecordBio, ReleaseDate, ArtistSelected, GenreSelected, ImageSrc, ImageAlt")] tblRecord record, EditViewModel view) { if (ModelState.IsValid) { record.ArtistID = int.Parse(view.ArtistSelected); record.GenreID = int.Parse(view.GenreSelected); context.Entry(record).State = EntityState.Modified; context.SaveChanges(); return(RedirectToAction("AdminIndex")); } else { return(View()); } }
private void AddToCartExecute() { try { AmountInt = Meal.Price * Convert.ToInt32(Amount) + AmountInt; tblRecord record = new tblRecord(); record.MealID = Meal.MealID; record.Amount = Convert.ToInt32(Amount); recordList.Add(record); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public ActionResult Create(CreateViewModel createvm) { if (ModelState.IsValid) { string filename = Path.GetFileName(createvm.Image.FileName); createvm.ImageSrc = "~/Content/RecordImages/" + filename; filename = Path.Combine(Server.MapPath("~/Content/RecordImages/"), filename); createvm.Image.SaveAs(filename); tblRecord record = new tblRecord(int.Parse(createvm.ArtistSelected), int.Parse(createvm.GenreSelected), createvm.RecordName, createvm.RecordBio, createvm.ReleaseDate, createvm.ImageSrc, createvm.ImageAlt); context.tblRecords.Add(record); context.SaveChanges(); ModelState.Clear(); CreateViewModel newcreatevm = new CreateViewModel(); return(View(newcreatevm)); } else { return(View()); } }
public ActionResult Delete(DeleteViewModel view) { bool isPasswordValid = context.tblUsers .Any(x => x.UserName.ToLower() == User.Identity.Name.ToLower() && x.Password == view.Password); if (isPasswordValid) { tblRecord record = context.tblRecords.Find(view.Record.RecordID); List <tblRating> ratingslist = context.tblRatings.Where(x => x.RecordID == record.RecordID).ToList(); foreach (var item in ratingslist) { context.tblRatings.Remove(item); } context.tblRecords.Remove(record); context.SaveChanges(); return(RedirectToAction("AdminIndex")); } return(View()); }
/// <summary> /// method for creating the order /// </summary> public void Create() { // dictionary for displaying the restaurant Menu Dictionary <int, string> RestaurantMenu = ShowMenu(); try { using (RestaurantBraticGacinovicEntities context = new RestaurantBraticGacinovicEntities()) { tblRecord record = new tblRecord(); Random rnd = new Random(); // variables for creating record in table Records and taking random order code record.OrderTime = DateTime.Now; record.Code = rnd.Next(1, 9999); context.tblRecords.Add(record); string exit = null; // loop for creating the order do { // inputs and validations Console.WriteLine("Input ID of the article: "); bool isValid = int.TryParse(Console.ReadLine(), out int id); while (isValid == false) { Console.WriteLine("Wrong input, please try again."); isValid = int.TryParse(Console.ReadLine(), out id); } // loop for checking if the article exists in the Menu if (!RestaurantMenu.ContainsKey(id)) { Console.WriteLine("The article does not exist."); return; } Console.WriteLine("Input quantity: "); bool inputQuantity = int.TryParse(Console.ReadLine(), out int quantity); while (inputQuantity == false) { Console.WriteLine("Wrong input, please try again."); inputQuantity = int.TryParse(Console.ReadLine(), out quantity); } // loop for checking if article exists and creating the order if (RestaurantMenu.ContainsKey(id)) { tblOrder order = new tblOrder(); order.Article = RestaurantMenu[id]; order.Quantity = quantity; order.RecordID = record.RecordID; context.tblOrders.Add(order); } Console.WriteLine("If you want to finish order press 'x', or press 'enter' to continue."); exit = Console.ReadLine(); } while (exit != "x"); Console.WriteLine("\nCode of your order: " + record.Code); context.SaveChanges(); } } catch (Exception) { Console.WriteLine("Error"); } }
/// <summary> /// method for updating orders, deleting the order and creating new with the same code and ID /// </summary> public void Update() { // inputs and validations Console.Write("Please enter your order code: "); bool isValid = int.TryParse(Console.ReadLine(), out int code); while (isValid == false) { Console.WriteLine("Wrong input, please try again."); isValid = int.TryParse(Console.ReadLine(), out code); } // calling method for displaying the restaurant Menu Dictionary <int, string> RestaurantMenu = ShowMenu(); try { using (RestaurantBraticGacinovicEntities context = new RestaurantBraticGacinovicEntities()) { tblRecord record = new tblRecord(); // finding order to edit tblRecord recordToEdit = (from x in context.tblRecords where x.Code == code select x).First(); List <tblOrder> list = (from y in context.tblOrders where y.RecordID == recordToEdit.RecordID select y).ToList(); // deleting the order context.tblOrders.RemoveRange(list); if (recordToEdit != null) { string exit = null; // loop for creating new order at the same code and ID do { Console.WriteLine("Input ID of the article: "); bool inputID = int.TryParse(Console.ReadLine(), out int id); while (inputID == false) { Console.WriteLine("Wrong input, please try again."); inputID = int.TryParse(Console.ReadLine(), out id); } Console.WriteLine("Input quantity: "); bool inputQuantity = int.TryParse(Console.ReadLine(), out int quantity); while (inputID == false) { Console.WriteLine("Wrong input, please try again."); inputQuantity = int.TryParse(Console.ReadLine(), out quantity); } // creating new order if (RestaurantMenu.ContainsKey(id)) { tblOrder order = new tblOrder(); order.Article = RestaurantMenu[id]; order.Quantity = quantity; order.RecordID = recordToEdit.RecordID; context.tblOrders.Add(order); } Console.WriteLine("\nIf you want to finish order press 'x', or press 'enter' to continue."); exit = Console.ReadLine(); } while (exit != "x"); context.SaveChanges(); } else { Console.WriteLine("\nYour order does not exist, please try again."); } } } catch (Exception) { Console.WriteLine("Error"); } }
public DeleteViewModel(tblRecord record, List <tblRating> ratings) { Record = record; RatingsList = ratings.Where(x => x.RecordID == Record.RecordID).ToList(); }