public async Task <IActionResult> Edit(Guid id, [Bind("Id,Name,Date,LocationId")] ConcertInfo concertInfo)
{
if (id != concertInfo.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(concertInfo);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ConcertInfoExists(concertInfo.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["LocationId"] = new SelectList(_context.ConcertLocations, "Id", "Name", concertInfo.LocationId);
return(View(concertInfo));
}
/// <summary>
/// Отображает результаты концерта
/// </summary>
private void DisplayResult(ConcertInfo concert)
{
header.text = $"Концерт в \"{concert.LocationName}\" завершен!";
ticketsSold.text = $"ПРОДАНО {concert.TicketsSold} билетов";
ticketCost.text = $"ЦЕНА БИЛЕТА: {concert.TicketCost}$";
moneyIncome.text = $"ДОХОД: +{concert.Income}$";
}
/// <summary>
/// Показывает результаты концерта
/// </summary>
public void Show(ConcertInfo concert)
{
_concert = concert;
concertAnalyzer.Analyze(concert);
DisplayResult(concert);
Open();
}
protected override void BeforePageClose()
{
base.BeforePageClose();
managementPointsLabel.text = "0";
marketingPointsLabel.text = "0";
_concert = null;
}
private int displayConcertsBySqlCommand(string sql)
{
SqlConnection con = InfoSqlConnect.createConnection();
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader reader = cmd.ExecuteReader();
int index = 0;
Response.Write("<div class='concert_list'>");
while (reader.Read())
{
if (index > CONCERT_PAGE_COUNT - 1)
{
index++;
break;
}
ConcertInfo CInfo = new ConcertInfo();
CInfo.ConcertID = long.Parse(reader["id"].ToString());
CInfo.Name = reader["name"].ToString();
CInfo.Poster = reader["poster"].ToString();
CInfo.Description = reader["description"].ToString();
CInfo.Actor = reader["actor"].ToString();
string strShortDes = (CInfo.Description.Length <= SHORT_DESCRIPTION_COUNT) ?
CInfo.Description : CInfo.Description.Substring(0, SHORT_DESCRIPTION_COUNT);
Response.Write("<div class='home_poster'>" +
"<a href='DetailWeb.aspx?id=" + CInfo.ConcertID + "'>" +
"<img class='home_poster' src='/" + CInfo.Poster + "'/>" +
"</a></div>");
Response.Write("<div class='home_text_info'>");
Response.Write("<a href='DetailWeb.aspx?id=" + CInfo.ConcertID + "'>" +
"<span class='concert_name'>" + CInfo.Name + "</span></a><br/>" +
"表演：" + CInfo.Actor + "<br/>" +
"<br/>" + strShortDes);
Response.Write("</div>");
index++;
}
Response.Write("</div>");
reader.Close();
con.Close();
return(index);
}
public async Task <IActionResult> Create([Bind("Id,Name,Date,LocationId")] ConcertInfo concertInfo)
{
if (ModelState.IsValid)
{
concertInfo.Id = Guid.NewGuid();
_context.Add(concertInfo);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["LocationId"] = new SelectList(_context.ConcertLocations, "Id", "Name", concertInfo.LocationId);
return(View(concertInfo));
}
protected override void BeforePageOpen()
{
_concert = new ConcertInfo();
CacheLastAlbums();
var anyAlbums = _lastAlbums.Any();
var albumProps = anyAlbums
? _lastAlbums.Select(ConvertAlbumToCarouselProps).ToArray()
: new[] { new CarouselProps {
Text = "Нет альбомов", Value = new AlbumInfo()
} };
albumsCarousel.Init(albumProps);
OnPlaceChanged(0);
GameScreenController.Instance.HideProductionGroup();
}
private bool ConcertInsert()
{
SqlConnection con = InfoSqlConnect.createConnection();
con.Open();
ConcertInfo info = new ConcertInfo();
info.ConcertID = long.Parse(TBId.Text);
info.Name = TBName.Text;
info.Description = TBDescription.Text;
info.Actor = TBActor.Text;
if (UploadImage.FileName == null || UploadImage.FileName.Length <= 0)
{
info.Poster = "";
}
else
{
info.Poster = "image/poster/" + UploadImage.FileName;
}
SqlCommand cmd = new SqlCommand("insert into concerts values(" +
info.ConcertID + ",'" +
info.Name + "','" +
info.Description + "','" +
info.Actor + "','" +
info.Poster + "')", con);
int res = -1;
try
{
res = cmd.ExecuteNonQuery();
}
catch
{
return(false);
}
if (res < 0)
{
return(false);
}
return(true);
}
private void LoadConcerts()
{
SqlConnection con = InfoSqlConnect.createConnection();
con.Open();
SqlCommand cmd = new SqlCommand("select id,name from concerts", con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ConcertInfo Info = new ConcertInfo();
Info.ConcertID = long.Parse(reader["id"].ToString());
Info.Name = reader["name"].ToString();
Concerts.Add(Info);
LoadScreenings(Info.ConcertID);
}
reader.Close();
con.Close();
}
protected override void BeforePageClose()
{
flexingGraphic.AnimationState.SetEmptyAnimation(0, 0);
_concert = null;
}
/// <summary>
/// Открытие страницы с передачей информации о проведенном концерте
/// </summary>
public void Show(ConcertInfo concert)
{
_concert = concert;
Open();
}
protected override void AfterPageClose()
{
SaveResult(_concert);
_concert = null;
}
/// <summary>
/// Сохраняет результаты концерта
/// </summary>
private void SaveResult(ConcertInfo concert)
{
concert.Timestamp = TimeManager.Instance.Now;
PlayerManager.Instance.AddMoney(concert.Income, rewardExp);
ProductionManager.AddConcert(concert);
}
private void PrepareDatabase(IApplicationBuilder app)
{
using (var serviceScope = app.ApplicationServices.GetRequiredService <IServiceScopeFactory>().CreateScope())
using (var context = serviceScope.ServiceProvider.GetRequiredService <MagicCarpetWebAppContext>())
{
context.Database.Migrate();
if (!context.ConcertLocations.Any())
{
//Seed
var ziggoDome = new ConcertLocation {
Name = "Ziggo Dome", Station = "ASB"
};
var afasLive = new ConcertLocation {
Name = "AFAS Live", Station = "ASB"
};
var gelredome = new ConcertLocation {
Name = "Gelredome", Station = "AH"
};
context.ConcertLocations.Add(ziggoDome);
context.ConcertLocations.Add(afasLive);
context.ConcertLocations.Add(gelredome);
var nickiAug1Concert = new ConcertInfo {
Name = "Nicki Minaj (Aug 1st)", Location = ziggoDome, Date = new DateTime(2018, 08, 1, 22, 0, 0)
};
context.ConcertInfoes.Add(nickiAug1Concert);
context.ConcertInfoes.Add(new ConcertInfo {
Name = "Nicki Minaj (Aug 2nd)", Location = ziggoDome, Date = new DateTime(2018, 08, 2, 22, 0, 0)
});
context.ConcertInfoes.Add(new ConcertInfo {
Name = "Justin Bieber (Aug 3rd)", Location = afasLive, Date = new DateTime(2018, 08, 3, 22, 0, 0)
});
context.ConcertInfoes.Add(new ConcertInfo {
Name = "Justin Bieber (Aug 4th)", Location = afasLive, Date = new DateTime(2018, 08, 4, 22, 0, 0)
});
context.ConcertInfoes.Add(new ConcertInfo {
Name = "Snow Patrol (Aug 5th)", Location = gelredome, Date = new DateTime(2018, 08, 5, 22, 0, 0)
});
context.Reservations.Add(new Reservation {
Concert = nickiAug1Concert, Destination = "HGV", Amount = 6, EmailAddress = "*****@*****.**", Agrees = true, PaymentDetails = "{\"id\": \"493900A6-64AD-41CA-B569-A3364BBA62CA\",\"success\": true}"
});
context.Reservations.Add(new Reservation {
Concert = nickiAug1Concert, Destination = "HGV", Amount = 2, EmailAddress = "*****@*****.**", Agrees = true, PaymentDetails = "{\"id\": \"493900A6-64AD-41CA-B569-A3364BBA62CB\",\"success\": true}"
});
context.SaveChanges();
}
if (context.ConcertInfoes.All(c => c.Image == null))
{
foreach (var concert in context.ConcertInfoes)
{
if (concert.Name.StartsWith("Nicki"))
{
concert.Image = "Nicki.jpg";
}
else if (concert.Name.StartsWith("Justin"))
{
concert.Image = "Justin.jpg";
}
else if (concert.Name.StartsWith("Snow"))
{
concert.Image = "Snow.jpg";
}
}
context.SaveChanges();
}
}
}
protected override void AfterPageClose()
{
_concert = null;
_lastAlbums.Clear();
ResetTicketCost();
}
/// <summary>
/// Начинает выполнение работы
/// </summary>
public override void StartWork(params object[] args)
{
_concert = (ConcertInfo)args[0];
Open();
}
/// <summary>
/// Листенер события организации нового концерта (по завершению)
/// </summary>
private void CheckConcertPlace(ConcertInfo concertInfo)
{
_lastConcertPlaceName = concertInfo.LocationName;
EqualCheckValue(AchievementsType.ConcertPlace, concertInfo.LocationId, () => { _lastConcertPlaceName = ""; });
}
/// <summary>
/// Добавляет информацию о концерте в историю игрока
/// </summary>
public static void AddConcert(ConcertInfo info)
{
playerHistory.ConcertList.AddProduction(info, Instance.onConcertAdd);
}
