[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 + "\"}");
}
