public async Task <IActionResult> OnGetAsync(int p = 1, string q = null, int grid = -1)
{
SearchQuery = q != null ? q : "";
GridView = HttpContext.Session.GetInt32("grid_view").GetValueOrDefault(1) == 1;
if (grid != -1)
{
GridView = grid == 1 ? true : false;
HttpContext.Session.SetInt32("grid_view", GridView ? 1 : 0);
}
CurrentPage = p;
Museums = await _context.Museums.Include(m => m.Region).ToListAsync();
if (q != null)
{
Museums = Museums.Where(m => m.Name.ToLower().Contains(q.ToLower()) || m.City.ToLower().Contains(q.ToLower()) || m.Region.Name.ToLower().Contains(q.ToLower())).ToList();
}
TotalMuseums = Museums.Count();
if (CurrentPage < 1 || CurrentPage > (TotalMuseums / 30 + (TotalMuseums % 30 > 0 ? 1 : 0)) && q == null)
{
return(RedirectToPage("./Index"));
}
if (TotalMuseums > 30)
{
Museums = Museums.Skip(30 * (CurrentPage - 1)).Take(30).ToList();
}
return(Page());
}
public IActionResult GetInfo()
{
UserAccounts model = Autentification.GetLoggedUser(HttpContext);
Museums m = museumRepository.GetMuseumByAccId(model.Id);
return(PartialView("GetInfo", m));
}
public IActionResult Edit(MuseumVM model)
{
if (!ModelState.IsValid)
{
model.MuseumTypes = new SelectList(museumTypeRepository.GetMuseumTypes(), "Id", "Name");
return(View("Edit", model));
}
Museums m = new Museums();
m.Id = model.Id;
m.Name = model.Name;
m.UserId = model.UserId;
m.Latitude = model.Latitude;
m.Longitude = model.Longitude;
m.Address = model.Address;
m.Email = model.Email;
m.Phone = model.Phone;
m.MuseumTypeId = model.MuseumTypeId;
m.Description = model.Description;
m.OpeningYear = model.Year;
m.QrScanning = model.QrScanning;
m.OnlineTickets = model.TicketSelling;
museumRepository.UpdateMuseum(m);
museumRepository.Save();
return(RedirectToAction("Details", new { id = model.Id }));
}
public IActionResult GetMuseum(int?id)
{
int userId = Autentification.GetLoggedUser(HttpContext).Id;
Museums m = museumRepository.GetMuseumByAccId(userId);
id = m.Id;
MuseumVM model = new MuseumVM()
{
Id = m.Id,
Name = m.Name,
UserId = m.UserId,
Username = m.User.Username,
PasswordHash = m.User.PasswordHash,
PasswordSalt = m.User.PasswordSalt,
RegistrationDate = m.User.RegistrationDate.ToString("dd/MM/yyyy"),
MuseumType = m.MuseumType.Name,
MuseumTypeId = m.MuseumTypeId,
Year = m.OpeningYear,
QrScanning = m.QrScanning,
TicketSelling = m.OnlineTickets,
Description = m.Description,
Email = m.Email,
Phone = m.Phone,
Address = m.Address,
Latitude = m.Latitude,
Longitude = m.Longitude,
Images = imageRepository.GetMuseumImages(m.Id),
WorkingHour = workingHoursRepository.GetWorkingHours(m.Id)
};
model.MuseumTypes = new SelectList(museumTypeRepository.GetMuseumTypes(), "Id", "Name");
return(View("Edit", model));
}
//-------------------------------------------------------------------------------
public Museums AddMuseum(Museums museum)
{
try
{
DbCommand command = _factory.CreateCommand();
command.CommandText = "INSERT INTO Museums ([Address], CityId, [Description], Latitude, [Login], Longitude, [Password], Phone, PictureSrc, Radius, Title, WebSite) VALUES(@Address, @CityId, @Description, @Latitude, @Login, @Longitude, @Password, @Phone, @PictureSrc, @Radius, @Title, @WebSite)";
command.Parameters.Add(instance.GetParameter("Address", museum.Address, _factory));
command.Parameters.Add(instance.GetParameter("CityId", museum.CityId, _factory));
command.Parameters.Add(instance.GetParameter("Description", museum.Description, _factory));
command.Parameters.Add(instance.GetParameter("Latitude", museum.Latitude, _factory));
command.Parameters.Add(instance.GetParameter("Login", museum.Login, _factory));
command.Parameters.Add(instance.GetParameter("Longitude", museum.Longitude, _factory));
command.Parameters.Add(instance.GetParameter("Password", museum.Password, _factory));
command.Parameters.Add(instance.GetParameter("Phone", museum.Phone, _factory));
command.Parameters.Add(instance.GetParameter("PictureSrc", museum.PictureSrc, _factory));
command.Parameters.Add(instance.GetParameter("Radius", museum.Radius, _factory));
command.Parameters.Add(instance.GetParameter("Title", museum.Title, _factory));
command.Parameters.Add(instance.GetParameter("WebSite", museum.WebSite, _factory));
command.ExecuteNonQuery();
museum.Id = instance.GetNewId("Museums", _connection);
museums.Add(museum);
return(museum);
}
catch (DbException)
{
return(null);
}
}
public IActionResult Index()
{
int id = Autentification.GetLoggedUser(HttpContext).Id;
Museums m = museumRepository.GetMuseumByAccId(id);
List <Artworks> model = artworkRepository.GetArtworksByMuseum(m.Id);
List <ArtworkInfoVM> list = new List <ArtworkInfoVM>();
foreach (Artworks x in model)
{
ArtworkInfoVM vm = new ArtworkInfoVM();
vm.Id = x.Id;
vm.Artist = x.Artist.Name;
vm.ArtistId = x.ArtistId;
vm.Likes = likesRepository.GetLikes(x.Id);
vm.Name = x.Name;
vm.Image = imageRepository.GetArtworkImage(x.Id);
if (vm.Image != null)
{
vm.ImageId = vm.Image.Id;
}
list.Add(vm);
}
ViewData["collections"] = collectionRepository.GetCollections(m.Id);
return(View("Index", list));
}
public IActionResult Save(MuseumVM museum)
{
if (!ModelState.IsValid)
{
museum.MuseumType = new SelectList(museumtypeRepository.GetMuseumTypes(), "Id", "Name").ToList();
return(View("Add", museum));
}
UserAccounts u = new UserAccounts();
if (museum.PasswordHash == museum.PasswordSalt)
{
string password = museum.PasswordHash;
u.PasswordSalt = GeneratePassword.GenerateSalt();
u.PasswordHash = GeneratePassword.GenerateHash(password, u.PasswordSalt);
u.Username = museum.Username;
u.RegistrationDate = DateTime.Now;
u.Active = true;
userRepository.InsertUser(u);
museumRepository.Save();
Museums m = new Museums();
m.MuseumTypeId = museum.MuseumTypeId;
m.Name = museum.Name;
m.UserId = u.Id;
museumRepository.InsertMuseum(m);
museumRepository.Save();
}
return(RedirectToAction("Index"));
}
public IActionResult Activate(int museumId)
{
Museums museum = museumRepository.GetMuseum(museumId);
museum.User.Active = true;
museumRepository.UpdateMuseum(museum);
museumRepository.Save();
return(RedirectToAction("Index"));
}
public IActionResult Add()
{
int id = Autentification.GetLoggedUser(HttpContext).Id;
Museums m = museumRepository.GetMuseumByAccId(id);
News model = new News();
model.MuseumId = m.Id;
return(View("Add", model));
}
public IActionResult Index()
{
int Id = Autentification.GetLoggedUser(HttpContext).Id;
Museums m = museumRepository.GetMuseumByAccId(Id);
IEnumerable <TicketTypes> model = tickettypeRepository.GetTicketTypes(m.Id);
ViewData["Allow"] = m.OnlineTickets;
return(View("Index", model));
}
public IActionResult Add(int id)
{
int userId = Autentification.GetLoggedUser(HttpContext).Id;
Museums m = museumRepository.GetMuseumByAccId(userId);
Collections model = new Collections();
model.MuseumId = m.Id;
model.ImageId = id;
return(View("Add", model));
}
public IActionResult Add()
{
int id = Autentification.GetLoggedUser(HttpContext).Id;
Museums m = museumRepository.GetMuseumByAccId(id);
Events model = new Events();
model.MuseumId = m.Id;
model.StartDate = DateTime.Now;
model.EndTime = DateTime.Now;
return(View("Add", model));
}
public IActionResult Index()
{
int id = Autentification.GetLoggedUser(HttpContext).Id;
Museums m = museumRepository.GetMuseumByAccId(id);
List <Collections> model = collectionRepository.GetCollections(m.Id);
foreach (Collections x in model)
{
if (x.Description.Length > 200)
{
x.Description = x.Description.Substring(0, 200);
}
}
return(View("Index", model));
}
public IActionResult Add()
{
int id = Autentification.GetLoggedUser(HttpContext).Id;
Museums m = museumRepository.GetMuseumByAccId(id);
ArtworkVM model = new ArtworkVM();
model.Artist = new SelectList(artistRepository.GetArtists(), "Id", "Name");
model.ArtworkType = new SelectList(artworkTypeRepository.GetArtworkTypes(), "Id", "Name");
model.Country = new SelectList(countryRepository.GetCountries(), "Id", "Name");
model.Material = new SelectList(materialRepository.GetMaterials(), "Id", "Name");
model.Style = new SelectList(styleRepository.GetStyles(), "Id", "Name");
model.MuseumId = m.Id;
return(View("Add", model));
}
public async Task <IActionResult> GetMuseums(string museum_name = "", string name = "")
{
Museums _museums = new Museums();
if (Request.Query.ContainsKey("museum_name"))
{
museum_name = (Request.Query.FirstOrDefault(p => p.Key == "museum_name").Value);
}
if (Request.Query.ContainsKey("name"))
{
name = (Request.Query.FirstOrDefault(p => p.Key == "name").Value);
}
using (LiteraryTourismContext db = new LiteraryTourismContext())
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var museums_ = (from museums in db.Set <Museums>()
join museum_writer in db.Set <Museum_writer>()
on museums.Id_museum equals museum_writer.Id_museum
join writers in db.Set <Writers>()
on museum_writer.Id_writer equals writers.Id_writer
where writers.Full_name.Contains(name) &&
museums.Museum_name.Contains(museum_name)
select new { Id_museum = museums.Id_museum, Museum_name = museums.Museum_name,
Museum_site = museums.Museum_site, Museum_description = museums.Museum_description,
Museum_rating = museums.Museum_rating, Museum_address = museums.Museum_address,
Latitude = museums.Latitude, Longitude = museums.Longitude,
Id_writer = writers.Id_writer, Full_name = writers.Full_name,
Date_of_birth = writers.Date_of_birth, Date_of_death = writers.Date_of_death,
Place_of_birth = writers.Place_of_birth, Place_of_death = writers.Place_of_death,
Biography = writers.Biography }).ToList();
if (museums_ == null)
{
return(NotFound());
}
return(Ok(museums_));
}
}
//-------------------------------------------------------------------------------
public void UpdateMuseum(int i, Museums museum)
{
try
{
DbCommand command = _factory.CreateCommand();
command.CommandText = "UPDATE Museums SET Title = @Title, [Description] = @Description, [Address] = @Address, Phone = @Phone, PictureSrc = @PictureSrc, WebSite = @WebSite, [Login] = @Login, [Password] = @Password, Latitude = @Latitude, Longitude = @Longitude, Radius = @Radius, CityId = @CityId";
command.Parameters.Add(instance.GetParameter("Title", museum.Title, _factory));
command.Parameters.Add(instance.GetParameter("Description", museum.Description, _factory));
command.Parameters.Add(instance.GetParameter("Address", museum.Address, _factory));
command.Parameters.Add(instance.GetParameter("Phone", museum.Phone, _factory));
command.Parameters.Add(instance.GetParameter("PictureSrc", museum.PictureSrc, _factory));
command.Parameters.Add(instance.GetParameter("WebSite", museum.WebSite, _factory));
command.Parameters.Add(instance.GetParameter("Login", museum.Login, _factory));
command.Parameters.Add(instance.GetParameter("Password", museum.Password, _factory));
command.Parameters.Add(instance.GetParameter("Latitude", museum.Latitude, _factory));
command.Parameters.Add(instance.GetParameter("Longitude", museum.Longitude, _factory));
command.Parameters.Add(instance.GetParameter("Radius", museum.Radius, _factory));
command.Parameters.Add(instance.GetParameter("CityId", museum.CityId, _factory));
command.ExecuteNonQuery();
museums[i].Address = museum.Address;
museums[i].CityId = museum.CityId;
museums[i].Description = museum.Description;
museums[i].Latitude = museum.Latitude;
museums[i].Login = museum.Login;
museums[i].Longitude = museum.Longitude;
museums[i].Password = museum.Password;
museums[i].Phone = museum.Phone;
museums[i].PictureSrc = museum.PictureSrc;
museums[i].Radius = museum.Radius;
museums[i].Title = museum.Title;
museums[i].WebSite = museum.WebSite;
}
catch (DbException)
{
throw;
}
}
public List <Models.Museums> getAllMuseumsPriceAsc(int PackageID)
{
List <Museums> result = new List <Museums>();
List <OhridCityPassClassLibrary.Museum> list = db.GetAllMuseumsPrice(PackageID, true);
foreach (OhridCityPassClassLibrary.Museum mus in list)
{
Museums item = new Museums();
item.AttractionDescripption = mus.Attraction.Description;
item.AttractionID = mus.Attraction.Id;
item.AttractionImgUrl = mus.Attraction.ImageUrl;
item.AttractionLocation = mus.Attraction.Location;
item.AttractionName = mus.Attraction.Name;
item.AttractionPrice = mus.Attraction.Price;
item.HoursFrom = mus.HoursFrom.Value;
item.HoursTo = mus.HoursTo.Value;
item.ID = mus.MuseumId;
result.Add(item);
}
return(result);
}
public IActionResult GetMuseum(int id)
{
Museums m = museumRepository.GetMuseum(id);
MuseumVM model = new MuseumVM()
{
Id = m.Id,
Name = m.Name,
MuseumTypeId = m.MuseumTypeId,
UserId = m.UserId,
Username = m.User.Username,
PasswordHash = m.User.PasswordHash,
PasswordSalt = m.User.PasswordSalt,
NewPassword = null,
RepeatPassword = null,
MuseumType = museumtypeRepository.GetMuseumTypes().Select(x => new SelectListItem {
Value = x.Id.ToString(), Text = x.Name
}).ToList()
};
return(View("Edit", model));
}
public IActionResult Edit(MuseumVM museum)
{
if (!ModelState.IsValid)
{
museum.MuseumType = new SelectList(museumtypeRepository.GetMuseumTypes(), "Id", "Name").ToList();
return(View("Edit", museum));
}
UserAccounts u = userRepository.GetUserById(museum.UserId);
if (museum.PasswordHash != null && museum.PasswordSalt != null)
{
if (museum.NewPassword == museum.RepeatPassword)
{
if (museum.NewPassword != null && museum.RepeatPassword != null)
{
string password = museum.NewPassword;
u.PasswordSalt = GeneratePassword.GenerateSalt();
u.PasswordHash = GeneratePassword.GenerateHash(password, u.PasswordSalt);
}
else
{
u.PasswordHash = museum.PasswordHash;
u.PasswordSalt = museum.PasswordSalt;
}
u.Username = museum.Username;
userRepository.UpdateUser(u);
museumRepository.Save();
Museums m = museumRepository.GetMuseum(museum.Id);
m.MuseumTypeId = museum.MuseumTypeId;
m.Name = museum.Name;
m.UserId = u.Id;
museumRepository.UpdateMuseum(m);
museumRepository.Save();
}
}
return(RedirectToAction("Index"));
}
//-------------------------------------------------------------------------------
public void GetMuseums()
{
try
{
DbCommand command = _factory.CreateCommand();
command.CommandText = "SELECT * FROM Museums";
DbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Museums museum = new Museums();
museum.Address = Convert.ToString(reader["Address"]);
museum.CityId = Convert.ToInt32(reader["CityId"]);
museum.Description = Convert.ToString(reader["Description"]);
museum.Id = Convert.ToInt32(reader["Id"]);
museum.Latitude = Convert.ToSingle(reader["Latitude"]);
museum.Login = Convert.ToString(reader["Login"]);
museum.Longitude = Convert.ToSingle(reader["Longitude"]);
museum.Password = Convert.ToString(reader["Password"]);
museum.Phone = Convert.ToString(reader["Phone"]);
museum.PictureSrc = Convert.ToString(reader["PictureSrc"]);
museum.Radius = Convert.ToSingle(reader["Radius"]);
museum.Title = Convert.ToString(reader["Title"]);
museum.WebSite = Convert.ToString(reader["WebSite"]);
museums.Add(museum);
}
reader.Close();
}
catch (DbException)
{
throw;
}
}
public JsonResult GetEvents(DateTime start, DateTime end)
{
int id = Autentification.GetLoggedUser(HttpContext).Id;
Museums m = museumRepository.GetMuseumByAccId(id);
List <Events> list = eventRepository.GetEvents(m.Id);
list = list.Where(x => x.StartDate >= start && x.EndTime <= end).ToList();
var eventList = from e in list
select new
{
id = e.Id,
title = e.Title,
start = e.StartDate,
end = e.EndTime,
color = "Teal",
someKey = e.Id + 1,
allDay = false
};
var rows = eventList.ToArray();
return(Json(rows));
}
public IActionResult Index()
{
int id = Autentification.GetLoggedUser(HttpContext).Id;
Museums m = museumRepository.GetMuseumByAccId(id);
List <News> news = newsRepository.GetNews(m.Id);
List <NewsVM> model = new List <NewsVM>();
foreach (News x in news)
{
NewsVM vm = new NewsVM();
vm.Id = x.Id;
vm.Date = x.Date;
vm.MuseumId = x.MuseumId;
vm.Subtitle = x.SubTitle;
if (x.Text.Length > 200)
{
vm.Text = x.Text.Substring(0, 200);
}
else
{
vm.Text = x.Text;
}
vm.Title = x.Title;
vm.Images = imageRepository.GetNewsImage(x.Id);
if (vm.Images != null)
{
vm.ImageId = vm.Images.Id;
}
vm.Img = null;
model.Add(vm);
}
return(View("Index", model));
}
public IActionResult Details(int id)
{
Artworks a = artworkRepository.GetArtworkById(id);
Museums m = museumRepository.GetMuseum(a.MuseumId);
ArtworkVM model = new ArtworkVM();
model.AccessionNumber = a.AccessionNumber;
model.Active = a.Active;
model.ArtistId = a.ArtistId;
model.ArtworkTypeId = a.ArtworkTypeId;
model.CatalogueEntry = a.CatalogueEntry;
model.CountryId = a.CountryId;
model.Date = a.Date;
model.Id = a.Id;
model.MaterialId = a.MaterialId;
model.MuseumId = a.MuseumId;
model.Name = a.Name;
model.Provenance = a.Provenance;
model.StyleId = a.StyleId;
model.Artist_S = a.Artist.Name;
model.ArtworkType_S = a.ArtworkType.Name;
model.Country_S = a.Country.Name;
model.Material_S = a.Material.Name;
model.Style_S = a.Style.Name;
model.Images = imageRepository.GetArtworkImages(a.Id);
model.Artist = new SelectList(artistRepository.GetArtists(), "Id", "Name");
model.ArtworkType = new SelectList(artworkTypeRepository.GetArtworkTypes(), "Id", "Name");
model.Country = new SelectList(countryRepository.GetCountries(), "Id", "Name");
model.Material = new SelectList(materialRepository.GetMaterials(), "Id", "Name");
model.Style = new SelectList(styleRepository.GetStyles(), "Id", "Name");
ViewData["download"] = m.QrScanning;
return(View("Details", model));
}
public MuseumBookGump(Mobile from, MuseumBook book, int page, int lookat) : base(25, 25)
{
if (lookat > 60 || lookat < 1)
{
lookat = 1;
}
m_Book = book;
this.Closable = true;
this.Disposable = true;
this.Dragable = true;
this.Resizable = false;
AddPage(0);
AddImage(0, 0, 151);
AddImage(300, 0, 151);
AddImage(600, 0, 151);
AddImage(0, 300, 151);
AddImage(300, 300, 151);
AddImage(600, 300, 151);
AddImage(2, 2, 129);
AddImage(598, 2, 129);
AddImage(298, 2, 129);
AddImage(2, 298, 129);
AddImage(302, 298, 129);
AddImage(598, 298, 129);
AddImage(5, 6, 145);
AddImage(164, 12, 129);
AddImage(6, 356, 142);
AddImage(251, 291, 129);
AddImage(238, 568, 143);
if (page == 3)
{
AddImage(704, 77, 164);
AddImage(642, 77, 164);
AddImage(704, 186, 164);
AddImage(642, 186, 164);
AddImage(648, 83, 10892);
AddHtml(180, 20, 400, 20, @"<BODY><BASEFONT Color=#FBFBFB><BIG>TOME OF MUSEUM ANTIQUES</BIG></BASEFONT></BODY>", (bool)false, (bool)false);
AddButton(856, 14, 4017, 4017, 901, GumpButtonType.Reply, 0);
AddHtml(174, 78, 418, 23, @"<BODY><BASEFONT Color=#FCFF00><BIG>The Search For Museum Antiques</BIG></BASEFONT></BODY>", (bool)false, (bool)false);
AddHtml(101, 154, 525, 343, @"<BODY><BASEFONT Color=#FFA200><BIG>You have decided to embark on a search for 60 different antiques that the Art Collector would like to have researched. The problem is, you don’t know where to begin. In order to get clues, you will need to talk to citizens (orange names) to see if they can perhaps tell you where to search. If a citizen doesn’t initially mention anything about antiques, you will have to seek out another. When you finally get a clue, a small tune will play and your book will be updated with that rumor they gave you. It could be true or it could be false. You won’t know until you go there. Sometimes the antique may be in a chest or bag on a pedestal in a dungeon, or held by one of the more powerful creatures within that dungeon. As you collect antiques, they will be marked off in your book. When they are all marked off, then you can give the book to the Art Collector to claim your " + MuseumBook.QuestValue() + " gold. The antiques you collected can also be given to the Art Collector, and you can double click the item in your pack to see what the value of it is. Some antiques are lights or fires that can be turned on or off. Each antique has a base value and then a value affected by certain characteristics you have. You can only embark on this search once, so don’t lose your book.</BIG></BASEFONT></BODY>", (bool)false, (bool)false);
AddHtml(644, 350, 226, 197, @"<BODY><BASEFONT Color=#FCFF00><BIG>Antiques Value Modifiers<br><br>- Merchant Skill<br> (Item Identification)<br><br>- Begging Skill<br> (If Demeanor Is Set)<br><br>- Merchant Guild Member</BIG></BASEFONT></BODY>", (bool)false, (bool)false);
}
else
{
if (page == 1)
{
AddButton(852, 16, 4005, 4005, 902, GumpButtonType.Reply, 0);
AddHtml(785, 18, 60, 20, @"<BODY><BASEFONT Color=#FCFF00><BIG>Next</BIG></BASEFONT></BODY>", (bool)false, (bool)false);
}
else
{
AddButton(852, 16, 4014, 4014, 901, GumpButtonType.Reply, 0);
AddHtml(785, 18, 60, 20, @"<BODY><BASEFONT Color=#FCFF00><BIG>Previous</BIG></BASEFONT></BODY>", (bool)false, (bool)false);
}
AddButton(837, 565, 3610, 3610, 903, GumpButtonType.Reply, 0);
string rumor = "";
if (m_Book.RumorFrom != "")
{
rumor = MuseumBook.GetRumor(m_Book, MuseumBook.GetNext(m_Book), false);
}
AddHtml(180, 20, 400, 20, @"<BODY><BASEFONT Color=#FBFBFB><BIG>TOME OF MUSEUM ANTIQUES</BIG></BASEFONT></BODY>", (bool)false, (bool)false);
AddHtml(180, 50, 701, 50, @"<BODY><BASEFONT Color=#FFA200><BIG>" + rumor + "</BIG></BASEFONT></BODY>", (bool)false, (bool)false);
int cycle = 30;
int txt = 320;
int btn = 275;
int down = 45;
int item = 1; if (page == 2)
{
item = 31;
}
while (cycle > 0)
{
if (cycle == 15)
{
txt = 645; btn = 600; down = 45;
}
down = down + 30;
int button = 3609;
string color = "FFA200";
if (item == MuseumBook.GetNext(m_Book) && m_Book.RumorFrom != "")
{
button = 4011;
}
else if (MuseumBook.GetMuseums(item, m_Book) > 0)
{
button = 4017; color = "33DA1C";
}
if (item == lookat)
{
color = "FBFBFB";
}
AddButton(btn, down + 30, button, button, item, GumpButtonType.Reply, 0);
AddHtml(txt, down + 30, 250, 20, @"<BODY><BASEFONT Color=#" + color + "><BIG>" + MuseumBook.AntiqueInfo(item, 4, m_Book) + "</BIG></BASEFONT></BODY>", (bool)false, (bool)false);
item++;
cycle--;
}
if (MuseumBook.GetMuseums(lookat, m_Book) > 0)
{
AddHtml(90, 450, 100, 20, @"<BODY><BASEFONT Color=#33DA1C><BIG>Found</BIG></BASEFONT></BODY>", (bool)false, (bool)false);
}
else
{
AddHtml(90, 450, 100, 20, @"<BODY><BASEFONT Color=#FF0000><BIG>Lost</BIG></BASEFONT></BODY>", (bool)false, (bool)false);
}
if (lookat == MuseumBook.GetNext(m_Book) && m_Book.ItemValue > 0)
{
AddItem(74, 481, 3823);
int cost = Museums.AntiqueTotalValue(m_Book.ItemValue, from, false);
AddHtml(114, 485, 100, 20, @"<BODY><BASEFONT Color=#FCFF00><BIG>" + cost + "</BIG></BASEFONT></BODY>", (bool)false, (bool)false);
}
AddHtml(87, 327, 175, 115, @"<BODY><BASEFONT Color=#FCFF00><BIG>" + MuseumBook.AntiqueInfo(lookat, 4, m_Book) + "<br><br>" + MuseumBook.AntiqueInfo(lookat, 5, m_Book) + "</BIG></BASEFONT></BODY>", (bool)false, (bool)false);
if (lookat == 1)
{
AddItem(149, 201, 20425);
}
else if (lookat == 2)
{
AddItem(156, 183, 8850);
}
else if (lookat == 3)
{
AddItem(128, 179, 20411);
}
else if (lookat == 4)
{
AddItem(160, 193, 20414);
}
else if (lookat == 5)
{
AddItem(152, 180, 20407);
}
else if (lookat == 6)
{
AddItem(145, 187, 20403);
}
else if (lookat == 7)
{
AddItem(146, 190, 1167);
}
else if (lookat == 8)
{
AddItem(145, 173, 20415);
}
else if (lookat == 9)
{
AddItem(149, 182, 21187);
}
else if (lookat == 10)
{
AddItem(155, 184, 8836);
}
else if (lookat == 11)
{
AddItem(145, 197, 21189);
}
else if (lookat == 12)
{
AddItem(125, 183, 20388);
}
else if (lookat == 13)
{
AddItem(149, 187, 21288);
}
else if (lookat == 14)
{
AddItem(147, 184, 21355);
}
else if (lookat == 15)
{
AddItem(147, 185, 21323);
}
else if (lookat == 16)
{
AddItem(117, 176, 20401);
}
else if (lookat == 17)
{
AddItem(121, 159, 20393);
}
else if (lookat == 18)
{
AddItem(125, 197, 21276);
}
else if (lookat == 19)
{
AddItem(149, 194, 21256);
}
else if (lookat == 20)
{
AddItem(152, 210, 20399);
}
else if (lookat == 21)
{
AddItem(148, 187, 20429);
}
else if (lookat == 22)
{
AddItem(150, 216, 8519);
}
else if (lookat == 23)
{
AddItem(140, 216, 20413);
}
else if (lookat == 24)
{
AddItem(150, 193, 8829);
}
else if (lookat == 25)
{
AddItem(147, 182, 20420);
}
else if (lookat == 26)
{
AddItem(148, 207, 20384);
}
else if (lookat == 27)
{
AddItem(132, 161, 20391);
}
else if (lookat == 28)
{
AddItem(138, 206, 21191);
}
else if (lookat == 29)
{
AddItem(151, 201, 20387);
}
else if (lookat == 30)
{
AddItem(137, 210, 18080);
}
else if (lookat == 31)
{
AddItem(144, 186, 20418);
}
else if (lookat == 32)
{
AddItem(112, 158, 6247);
}
else if (lookat == 33)
{
AddItem(116, 146, 20422);
}
else if (lookat == 34)
{
AddItem(141, 198, 21333);
}
else if (lookat == 35)
{
AddItem(148, 207, 20386);
}
else if (lookat == 36)
{
AddItem(159, 220, 732);
}
else if (lookat == 37)
{
AddItem(154, 207, 21244);
}
else if (lookat == 38)
{
AddItem(145, 205, 20383);
}
else if (lookat == 39)
{
AddItem(147, 211, 4085);
}
else if (lookat == 40)
{
AddItem(109, 171, 19724);
}
else if (lookat == 41)
{
AddItem(149, 187, 20409);
}
else if (lookat == 42)
{
AddItem(148, 201, 15283);
}
else if (lookat == 43)
{
AddItem(142, 181, 20390);
}
else if (lookat == 44)
{
AddItem(145, 191, 21395);
}
else if (lookat == 45)
{
AddItem(131, 170, 21280);
}
else if (lookat == 46)
{
AddItem(137, 191, 21393);
}
else if (lookat == 47)
{
AddItem(145, 197, 21208);
}
else if (lookat == 48)
{
AddItem(152, 146, 20430);
}
else if (lookat == 49)
{
AddItem(149, 188, 21332);
}
else if (lookat == 50)
{
AddItem(150, 188, 20424);
}
else if (lookat == 51)
{
AddItem(157, 199, 20405);
}
else if (lookat == 52)
{
AddItem(131, 131, 20395);
}
else if (lookat == 53)
{
AddItem(157, 190, 8843);
}
else if (lookat == 54)
{
AddItem(154, 190, 21347);
}
else if (lookat == 55)
{
AddItem(114, 116, 21171);
}
else if (lookat == 56)
{
AddItem(147, 212, 20397);
}
else if (lookat == 57)
{
AddItem(151, 194, 21287);
}
else if (lookat == 58)
{
AddItem(144, 210, 21206);
}
else if (lookat == 59)
{
AddItem(148, 212, 18406);
}
else if (lookat == 60)
{
AddItem(147, 193, 21258);
}
}
}
public void Awake()
{
m = (Museums)target;
}
public IActionResult Index()
{
UserAccounts u = Autentification.GetLoggedUser(HttpContext);
Administrators admin = null;
Museums museum = null;
if (u != null)
{
if (adminRepository.GetAdministrator(u.Id) != null)
{
admin = adminRepository.GetAdministrator(u.Id);
}
if (museumRepository.GetMuseumByAccId(u.Id) != null)
{
museum = museumRepository.GetMuseumByAccId(u.Id);
}
}
if (admin != null)
{
return(RedirectToAction("Index", "Home", new { area = "Administrator" }));
}
else if (museum != null)
{
return(RedirectToAction("Index", "Home", new { area = "Moderator" }));
}
else
{
HomeVM model = new HomeVM();
List <Museums> list = museumRepository.GetTop3();
model.Museums = new List <MuseumVM>();
model.Artworks = new List <ArtworkVM>();
model.News = new List <NewsVM>();
List <Artworks> artworks = artworkRepository.GetTop6();
List <News> news = newsRepository.GetLatest();
foreach (Museums x in list)
{
MuseumVM m = new MuseumVM();
m.Id = x.Id;
m.Description = x.Description;
m.Image = imageRepository.GetMuseumImage(x.Id);
m.Name = x.Name;
if (m.Image != null)
{
m.ImageId = m.Image.Id;
}
model.Museums.Add(m);
}
foreach (Artworks x in artworks)
{
ArtworkVM a = new ArtworkVM();
a.Id = x.Id;
a.Name = x.Name;
a.Artist = x.Artist.Name;
a.Museum = x.Museum.Name;
a.Image = imageRepository.GetArtworkImage(x.Id);
if (a.Image != null)
{
a.ImageId = a.Image.Id;
}
model.Artworks.Add(a);
}
foreach (News x in news)
{
NewsVM n = new NewsVM();
n.Id = x.Id;
n.Date = x.Date;
n.Image = imageRepository.GetNewsImage(x.Id);
if (n.Image != null)
{
n.ImageId = n.Image.Id;
}
n.Museum = x.Museum.Name;
n.Subtitle = x.SubTitle;
n.Text = x.Text;
n.Title = x.Title;
model.News.Add(n);
}
return(View("Index", model));
}
}
public void UpdateMuseum(Museums museum)
{
context.Entry(museum).State = EntityState.Modified;
}
public void InsertMuseum(Museums museum)
{
context.Museums.Add(museum);
}
public IActionResult Details(int id)
{
Museums model = museumRepository.GetMuseum(id);
return(View("Details", model));
}
public IActionResult Details(int id)
{
Museums m = museumRepository.GetMuseum(id);
MuseumVM model = new MuseumVM();
model.Id = m.Id;
model.Address = m.Address;
model.Description = m.Description;
model.Email = m.Email;
if (model.Image != null)
{
model.ImageId = model.Image.Id;
}
model.Images = imageRepository.GetMuseumImages(id);
model.Latitude = m.Latitude;
model.Longitude = m.Longitude;
model.Image = imageRepository.GetMuseumImage(m.Id);
model.Name = m.Name;
model.OpeningYear = m.OpeningYear;
model.Phone = m.Phone;
model.TicketSelling = m.OnlineTickets;
model.Type = m.MuseumType.Name;
model.UserId = m.UserId;
List <Artworks> artworks = artworkRepository.GetArtworksByMuseum(m.Id);
model.Artworks = new List <ArtworkVM>();
foreach (Artworks a in artworks)
{
ArtworkVM vm = new ArtworkVM();
vm.Artist = a.Artist.Name;
vm.ArtworkType = a.ArtworkType.Name;
vm.ArtworkTypeId = a.ArtworkTypeId;
vm.Country = a.Country.Name;
vm.Id = a.Id;
vm.Image = imageRepository.GetArtworkImage(a.Id);
if (vm.Image != null)
{
vm.ImageId = vm.Image.Id;
}
vm.Name = a.Name;
vm.MuseumId = a.MuseumId;
model.Artworks.Add(vm);
}
List <News> news = newsRepository.GetNews(m.Id);
model.News = new List <NewsVM>();
foreach (News x in news)
{
NewsVM n = new NewsVM();
n.Id = x.Id;
n.Date = x.Date;
n.Image = imageRepository.GetNewsImage(x.Id);
if (n.Image != null)
{
n.ImageId = n.Image.Id;
}
n.Museum = x.Museum.Name;
n.Subtitle = x.SubTitle;
n.Text = x.Text;
n.Title = x.Title;
model.News.Add(n);
}
model.Collections = collectionRepository.GetCollections(m.Id);
model.Events = eventRepository.GetEvents(m.Id);
model.TicketTypes = tickettypeRepository.GetTicketTypes(m.Id);
model.WorkingHours = workinghoursRepository.GetWorkingHours(m.Id);
model.Review = new Reviews();
model.Review.MuseumId = m.Id;
return(View("Details", model));
}
