[HttpGet] // Контроллер для отправки входных параметров :) public string[] Get() { string[] result = null; string token = Request.Headers["Authorization"]; int id = new SecurityMethods().ParseToken(token); if (id < 0) { result = DpDataBase.Inputs.Where(p => p.Id == 1).Select(x => x.NAME).ToArray(); } else { result = DpDataBase.Inputs.Where(p => p.UserId == id || p.Id == 1).Select(x => x.NAME).ToArray(); } if (result.Length == 0) { string sw = new System.IO.StreamReader("log.txt", true).ReadToEnd(); var dt = JsonConvert.DeserializeObject <DPInputData>(sw.ToString()); dt.NAME = "Ознакомительный вариант расчета"; dt.UserId = 0; DpDataBase.Inputs.Add(dt); DpDataBase.SaveChanges(); return(DpDataBase.Inputs.Where(p => p.Id == 1).Select(x => x.NAME).ToArray()); } return(result); }
public IActionResult Create(string show, string customer, string ghe) { if (ghe != null) { string[] listID = ghe.Split(','); Booking booking = new Booking(); booking.Customer_ID = int.Parse(customer); booking.Show_ID = int.Parse(show); booking.Total_Price = 0; booking.Status = 0; _context.Add(booking); _context.SaveChanges(); foreach (var item in listID) { BookingDetail bookingDetail = new BookingDetail(); bookingDetail.Booking_ID = booking.ID; bookingDetail.Seat_ID = int.Parse(item); _context.Add(bookingDetail); var seat = _context.Equipments.Include(m => m.Category_Equipment).Where(m => m.ID.Equals(bookingDetail.Seat_ID)).FirstOrDefault(); booking.Total_Price += seat.Category_Equipment.Price; _context.SaveChanges(); } } return(Redirect("/")); }
public void CheckoutCart(OrderModel order) { string userId = User.FindFirstValue(ClaimTypes.NameIdentifier); var listCart = _context.ShoppingCarts.Where(s => s.UserID == userId).ToList(); order.Date = DateTime.Now; order.UserID = userId; order.PaymentID = 1; order.TotalMoney = Total(); order.Status = true; order.OrderDetails = new List <OrderDetailModel>(); foreach (var cart in listCart) { var orderDetail = new OrderDetailModel { ProductID = cart.ProductId, Quantity = cart.Amount, Status = true, }; order.OrderDetails.Add(orderDetail); } _context.Orders.Add(order); _context.SaveChanges(); }
public string Get2(string dsGheChon, string tongGia, string idLichChieu) { if (dsGheChon != null) { var ob = JsonConvert.DeserializeObject(dsGheChon); string a = ob.ToString(); string[] b = a.Split("\""); string c = ""; foreach (string item in b) { if (Char.IsLetter(item[0]) == true) { c += item + ","; } } string[] d = c.Split(","); JObject us = JObject.Parse(HttpContext.Session.GetString("User")); if (d.Length > 0) { DatVeModel datVeModel = new DatVeModel(); datVeModel.SoGhe = d.Length - 1; datVeModel.NgayDat = DateTime.Now; datVeModel.TongGia = int.Parse(tongGia); datVeModel.MaLichChieu = int.Parse(idLichChieu); datVeModel.TrangThaiThanhToan = true; datVeModel.MaKhachHang = int.Parse(us.SelectToken("IdUser").ToString()); _context.Add(datVeModel); _context.SaveChanges(); } var datVeHienTai = from s in _context.datVeModels where s.MaLichChieu == int.Parse(idLichChieu) && s.TongGia == int.Parse(tongGia) && s.MaKhachHang == int.Parse(us.SelectToken("IdUser").ToString()) && s.SoGhe == (d.Length - 1) select new { s.IdDatVe }; for (int i = 0; i < d.Length - 1; i++) { ChiTietDatVeModel chiTietDatVeModel = new ChiTietDatVeModel(); chiTietDatVeModel.TenGhe = d[i]; chiTietDatVeModel.GiaVe = 0; chiTietDatVeModel.MaDatVe = datVeHienTai.FirstOrDefault().IdDatVe; _context.Add(chiTietDatVeModel); _context.SaveChanges(); } return(JsonConvert.SerializeObject("1")); } else { return(JsonConvert.SerializeObject("0")); } }
public async Task <IActionResult> Create([Bind("Id,Image")] Slide slide, IFormFile File) { if (ModelState.IsValid) { if (File == null) { return(RedirectToAction(nameof(Create))); } _context.Add(slide); _context.SaveChanges(); var path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot/Img/Pro", slide.Id + "." + File.FileName.Split(".")[File.FileName.Split(".").Length - 1]); using (var stream = new FileStream(path, FileMode.Create)) { await File.CopyToAsync(stream); } slide.Image = slide.Id + "." + File.FileName.Split(".")[File.FileName.Split(".").Length - 1]; try { _context.Update(slide); await _context.SaveChangesAsync(); } catch (Exception e) { _context.RemoveRange(slide); throw; } return(RedirectToAction(nameof(Index)));; } return(View(slide)); }
public string Get(int id, string tp, string qh, int rp, DateTime nc, DateTime gc, int p, int idnd, int lg, string ghe, DateTime nd, decimal gv) { JArray array = JsonConvert.DeserializeObject <JArray>(ghe); LinkedList <VeModel> list = new LinkedList <VeModel>(); for (int i = 0; i < array.Count; i++) { VeModel veModel = new VeModel { IdPhim = id, ThanhPho = tp, QuanHuyen = qh, IdRap = rp, NgayChieu = nc, GioChieu = gc, IdPhong = p, IdNguoiDung = idnd, IdLoaiGhe = lg, TenGhe = array[i].ToString(), NgayDat = nd, GiaVe = gv, }; list.AddLast(veModel); _context.Add(veModel); _context.SaveChanges(); } return(JsonConvert.SerializeObject(list)); }
public void AddToCart(ProductModel product, UserModel user) { var shoppingCartItem = _db.ShoppingCarts.SingleOrDefault( s => s.ProductId == product.ProductID && s.UserID == user.Id); if (shoppingCartItem == null) { shoppingCartItem = new ShoppingCartModel { UserID = user.Id, ProductId = product.ProductID, Product = product, User = user, Amount = 1 }; _db.ShoppingCarts.Add(shoppingCartItem); } else { shoppingCartItem.Amount++; } _db.SaveChanges(); }
public ActionResult <bool> Posttset([FromBody] request_model?req) { try { var phim = _context.PhimModel.FirstOrDefault(p => p.ID == req.phim_id); var xuatChieu = _context.XuatChieuModel.FirstOrDefault(x => x.ID == req.xuatChieu_id); string tongTien = (phim.Gia_ve * req.listGhe.Count).ToString(); var nguoiDung = _context.NguoiDungModel.FirstOrDefault(n => n.ID == 1); var ngayLap = DateTime.Now; HoaDonModel hoaDonModel = new HoaDonModel { Tong_tien = tongTien, NguoiDung_ID = nguoiDung.ID, Ngay_lap = ngayLap, Da_xoa = false }; _context.Add(hoaDonModel); _context.SaveChanges(); var phongChieu = _context.PhongChieuModel.FirstOrDefault(p => p.ID == xuatChieu.PhongChieu_ID); var rapPhim = _context.RapPhimModel.FirstOrDefault(r => r.ID == phongChieu.RapPhim_ID); for (int i = 0; i < req.listGhe.Count; ++i) { VeXemPhimModel veXemPhimModel = new VeXemPhimModel { Ghe_ID = req.listGhe[i], PhongChieu_ID = phongChieu.ID, RapPhim_ID = rapPhim.ID, Phim_ID = phim.ID, HoaDon_ID = hoaDonModel.ID, DaXoa = false, XuatChieu_id = xuatChieu.ID }; _context.Add(veXemPhimModel); _context.SaveChanges(); } return(true); } catch { return(false); } }
public async Task <IActionResult> RemoveSongFromAlbum(int id) { int?IdAlbum; var song = await _context.Song.FindAsync(id); IdAlbum = song.IdAlbum; song.IdAlbum = null; //var album = await _context.Album.FindAsync(song.IdAlbum); _context.SaveChanges(); var AllSong = await _context.Song.ToListAsync(); var SongOfAlbum = AllSong.Where(m => m.IdAlbum == IdAlbum); List <SongModel> SongFromAlbum = new List <SongModel>(); foreach (var item in SongOfAlbum) { SongModel songModel = new SongModel(); //var singer = _context.Singer.Find(item.IdSinger); songModel = item; //songModel.Singer = singer; SongFromAlbum.Add(songModel); } var album = await _context.Album.FindAsync(IdAlbum); var ListSong = _context.SingerOfSong.Include(m => m.Song).Where(m => m.IdSinger == album.IdSinger).ToList(); List <SongModel> songOfAlbums = new List <SongModel>(); foreach (var item in ListSong) { songOfAlbums.Add(item.Song); } ViewBag.IdAlbum = IdAlbum; ViewData["Song"] = new SelectList(songOfAlbums, "Id", "Name"); return(PartialView("_GetSongFromAlbum", SongFromAlbum)); //var AllSong = await _context.Song.ToListAsync(); //var SongOfAlbum = AllSong.Where(m => m.IdAlbum == IdAlbum); //List<SongModel> SongFromAlbum = new List<SongModel>(); //foreach (var item in SongOfAlbum) //{ // SongModel songModel = new SongModel(); // var singer = _context.Singer.Find(item.IdSinger); // songModel = item; // songModel.Singer = singer; // SongFromAlbum.Add(songModel); //} //return PartialView("_GetSongFromAlbum", SongFromAlbum); //return PartialView(); }
public string Create(DateTime Start_Show, int Room_ID, int Status, int Movie_ID) { Movie movie = _context.Movies.Find(Movie_ID); Movie_Show movie_Show = new Movie_Show(); movie_Show.Start_Show = Start_Show; movie_Show.Room_ID = Room_ID; movie_Show.Status = Status; movie_Show.Movie_ID = Movie_ID; _context.Add(movie_Show); _context.SaveChanges(); movieShow movieShow = new movieShow(); movieShow.id = movie_Show.ID; movieShow.Room_ID = movie_Show.Room_ID; movieShow.Movie_ID = movie_Show.Movie_ID; movieShow.h_start = movie_Show.Start_Show.Hour; movieShow.m_start = movie_Show.Start_Show.Minute; movieShow.runningTime = movie_Show.Movie.Running_Time; movieShow.movieName = movie_Show.Movie.Name; return(JsonConvert.SerializeObject(movieShow)); }
public string ChangeStatus(int id) { var customer = _context.Customers.FirstOrDefault(m => m.ID == id); if (customer.Status == 1) { customer.Status = 0; } else { customer.Status = 1; } _context.Customers.Update(customer); _context.SaveChanges(); return(JsonConvert.SerializeObject(customer)); }
public string ChangeStatus(int id) { var obj = _context.Category_Equipment.FirstOrDefault(m => m.ID == id); if (obj.Status == 1) { obj.Status = 0; } else { obj.Status = 1; } _context.Category_Equipment.Update(obj); _context.SaveChanges(); return(JsonConvert.SerializeObject(obj)); }
public string ChangeStatus(int id) { var staf = _context.Stafs.FirstOrDefault(m => m.ID == id); if (staf.Status == 1) { staf.Status = 0; } else { staf.Status = 1; } _context.Stafs.Update(staf); _context.SaveChanges(); return(JsonConvert.SerializeObject(staf)); }
public string Post(UserRegistrition ur) { //Если такой логин уже зареган if (db.Users.FirstOrDefault(user => user.Login == ur.Login) != null) { return("Такой логин уже существует"); } RegistrationData rd = SecurityMethods.DBWrapper(ur); rd.Token = SecurityMethods.CreateToken(rd); db.Users.Add(rd); db.SaveChanges(); return("Пользователь успешно создан"); }
public ActionResult Register(Account _account) { if (ModelState.IsValid) { var check = _context.account.FirstOrDefault(s => s.Email == _account.Email); if (check == null) { _account.Catid = 1; _account.Password = GetMD5(_account.Password); _context.account.Add(_account); _context.SaveChanges(); return(RedirectToAction("Login")); } else { ViewBag.error = "Email already exists"; return(View()); } } return(View()); }
public async Task <IActionResult> Create([Bind("Id,Name,UnitPrice,Author,PublisherId,CategoryId,ProductTypeId,Img,Description,Level,Origin")] Product product, ICollection <IFormFile> Files) { if (ModelState.IsValid) { if (Files == null) { return(RedirectToAction(nameof(Create))); } _context.Add(product); _context.SaveChanges(); long size = Files.Sum(f => f.Length); foreach (var formFile in Files) { if (formFile.Length > 0) { var filePath = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot/Img/Pro", product.Id + formFile.FileName); using (var stream = new FileStream(filePath, FileMode.Create)) { await formFile.CopyToAsync(stream); } } product.Img += product.Id + formFile.FileName + ","; } try { _context.Update(product); await _context.SaveChangesAsync(); } catch (Exception e) { _context.RemoveRange(product); throw; } } _construct(); return(RedirectToAction(nameof(Index))); }
public string Create(string Name, int Row_ID, int Col_ID, int Room_ID, int Equipment_Level_ID) { var Equiment_LV = _context.Category_Equipment.Find(Equipment_Level_ID); Equipment equipment = new Equipment(); equipment.Name = Name; equipment.Row_ID = Row_ID; equipment.Col_ID = Col_ID; equipment.Status = 1; equipment.Room_ID = Room_ID; equipment.Equipment_Level_ID = Equipment_Level_ID; _context.Add(equipment); _context.SaveChanges(); Equiment_Custom equiment_Custom = new Equiment_Custom(); equiment_Custom.ID = equipment.ID; equiment_Custom.Name = equipment.Name; equiment_Custom.Row_ID = equipment.Row_ID; equiment_Custom.Col_ID = equipment.Col_ID; equiment_Custom.Room_ID = equipment.Room_ID; equiment_Custom.Count_Cell = Equiment_LV.Count_Cell; equiment_Custom.Level_Equipment = Equiment_LV.Level; return(JsonConvert.SerializeObject(equiment_Custom)); }
public string UpdateStatus(ImageP_Update_STT req) { (from p in _context.imageProduct where p.Id == req.id select p).ToList().ForEach(x => x.Status = req.stt); _context.SaveChanges(); return("{\"id\":" + req.id + ",\"stt\":\"" + req.stt + "\"}"); }