public async Task <IActionResult> Create([Bind("ArtistIdGroup,ArtistIdMember,DateJoined,DateLeft")] GroupMember groupMember)
{
try
{
if (ModelState.IsValid)
{
_context.Add(groupMember);
await _context.SaveChangesAsync();
TempData["message"] = "Record saved successfully";
return(RedirectToAction(nameof(Index)));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.GetBaseException().Message);
}
// display a drop-down of members available sorted by full name
var artists = GetValidArtists()
.Select(a => new
{
ArtistId = a.ArtistId,
FullName = a.NameAddress.FullName
})
.ToList()
.OrderBy(a => a.FullName);
//ViewData["ArtistIdGroup"] = new SelectList(_context.Artist, "ArtistId", "ArtistId");
ViewData["ArtistIdMember"] = new SelectList(artists, "ArtistId", "FullName");
return(View(groupMember));
}
public async Task <IActionResult> Create([Bind("ContractId,StartDate,GroupId,ClubId,PricePerPerformace,NumberOfPerformances")] Contract contract)
{
//Getting the clibId from session
int ClubId = int.Parse(HttpContext.Session.GetString("SesClubId"));
//Adding Current club Name in the Viewbag to send it ti the view
ViewBag.ClubName = HttpContext.Session.GetString("SesClubName");
try
{
if (ModelState.IsValid)
{
_context.Add(contract);
await _context.SaveChangesAsync();
TempData["Message"] = "Contract added succeccfully";
return(RedirectToAction(nameof(Index)));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.GetBaseException().Message);
}
ViewData["ClubId"] = new SelectList(_context.Club, "ClubId", "Name", contract.ClubId);
ViewData["GroupId"] = new SelectList(_context.Groups, "GroupId", "Name", contract.GroupId);
return(View(contract));
}
public async Task <IActionResult> Create([Bind("ProvinceCode,Name,CountryCode,SalesTaxCode,SalesTax,IncludesFederalTax,FirstPostalLetter")] Province province)
{
string errorsMsg = "";
if (ModelState.IsValid)
{
// ensure there is no province with the same Code
Province prov = await _context.Province.FindAsync(province.ProvinceCode);
if (prov != null)
{
errorsMsg += $"'{prov.ProvinceCode}' is already taken - Province Code must be unique. ";
}
// ensure there is no province with the same Name
prov = _context.Province.FirstOrDefault(p => p.Name == province.Name);
if (prov != null)
{
errorsMsg += $"'{prov.Name}' is already taken - Province Name must be unique.";
}
if (errorsMsg == "")
{
_context.Add(province);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
if (errorsMsg != "")
{
TempData["message"] = errorsMsg;
}
ViewData["CountryCode"] = new SelectList(_context.Country, "CountryCode", "CountryCode", province.CountryCode);
return(View(province));
}
public async Task <IActionResult> Create([Bind("ProvinceCode,Name,CountryCode,SalesTaxCode,SalesTax,IncludesFederalTax,FirstPostalLetter")] Province province)
{
var existingProvince = _context.Province.Where(p => p.ProvinceCode == province.ProvinceCode).FirstOrDefault(); // checks the database if there's an existing province with the same code
var existingName = _context.Province.Where(p => p.Name == province.Name).FirstOrDefault();
string errorMessage = "";
// NOTE: I'm aware that the database checks against ALL provinces, not just the ones for the selected country. However, we cannot change this
// as it is using the province code as a primary key, so if we were to duplicate it, it would throw an exception.
if (ModelState.IsValid)
{
if (existingProvince != null) // if it didn't find anything, keep going
{
errorMessage += $"The province code {existingProvince.ProvinceCode} already exists.";
//return RedirectToAction(nameof(Index));
}
if (existingName != null)
{
errorMessage += "The province name " + existingName.Name + " already exists.";
}
else
{
_context.Add(province);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
TempData["Message"] = errorMessage;
ViewData["CountryCode"] = new SelectList(_context.Country, "CountryCode", "CountryCode", province.CountryCode);
return(View(province));
}
public async Task <IActionResult> Create([Bind("StyleName,Description")] Style style)
{
if (ModelState.IsValid)
{
_context.Add(style);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(style));
}
public async Task <IActionResult> Create([Bind("CountryCode,Name,PostalPattern,PhonePattern,FederalSalesTax,ProvinceTerminology")] Country country)
{
if (ModelState.IsValid)
{
_context.Add(country);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(country));
}
public async Task <IActionResult> Create([Bind("InstrumentId,Name")] Instrument instrument)
{
if (ModelState.IsValid)
{
_context.Add(instrument);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(instrument));
}
public async Task <IActionResult> Create([Bind("ArtistId,MinimumHourlyRate,NameAddressid")] Artist artist)
{
if (ModelState.IsValid)
{
_context.Add(artist);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["NameAddressid"] = new SelectList(_context.NameAddress, "NameAddressId", "NameAddressId", artist.NameAddressid);
return(View(artist));
}
public async Task <IActionResult> Create([Bind("ClubId,Name,Phone,StyleCode")] Club club)
{
if (ModelState.IsValid)
{
_context.Add(club);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["StyleCode"] = new SelectList(_context.Style, "StyleCode", "StyleCode", club.StyleCode);
return(View(club));
}
public async Task <IActionResult> Create([Bind("ArtistIdGroup,ArtistIdMember,DateJoined,DateLeft")] GroupMember groupMember)
{
// sets the group id to the active group
groupMember.ArtistIdGroup = int.Parse(HttpContext.Session.GetString("artistId"));
// I asked about this stuff in discord and never got an answer, so I decided I'd just interpret it as wanting us to change the dates
// on the back end. I hope that's what you wanted.
DateTime today = DateTime.Now;
groupMember.DateJoined = today; // sets the date joined to today no matter what they picked
groupMember.DateLeft = null; // sets date joined to null no matter what they picked
if (ModelState.IsValid)
{
_context.Add(groupMember);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
var artists = _context.Artist.ToList();
var artistsDup = _context.Artist.Include(a => a.NameAddress).ToList();
// same as above
foreach (var artist in artists)
{
var groups = _context.GroupMember.Where(g => g.ArtistIdGroup == artist.ArtistId).FirstOrDefault();
var groupsDup = _context.GroupMember.Where(g => g.ArtistIdMember == artist.ArtistId).FirstOrDefault();
if (groups != null)
{
artistsDup.Remove(artist);
}
else if (groupsDup != null)
{
if (groupsDup.DateLeft == null)
{
artistsDup.Remove(artist);
}
}
}
foreach (var artist in artistsDup)
{
string name = $"{artist.NameAddress.FirstName} {artist.NameAddress.LastName}";
artist.NameAddress.FirstName = name;
}
TempData["Message"] = "Something went wrong, please try again";
ViewData["ArtistIdGroup"] = new SelectList(_context.Artist, "ArtistId", "NameAddress.FirstName");
ViewData["ArtistIdMember"] = new SelectList(artistsDup, "ArtistId", "NameAddress.FirstName");
return(View(groupMember));
}
public async Task <IActionResult> Create([Bind("NameAddressId,FirstName,LastName,CompanyName,StreetAddress,City,PostalCode,ProvinceCode,Email,Phone")] NameAddress nameAddress)
{
if (ModelState.IsValid)
{
_context.Add(nameAddress);
await _context.SaveChangesAsync();
TempData["Message"] = "Create successful.";
return(RedirectToAction(nameof(Index)));
}
ViewData["ProvinceCode"] = new SelectList(_context.Province, "ProvinceCode", "ProvinceCode", nameAddress.ProvinceCode);
return(View(nameAddress));
}
public string Register([FromBody] User userF)
{
var login = userF.Login;
var password = SecurePasswordHasher.Hash(userF.Password);
var token = SecurePasswordHasher.Hash(login + password);
User user = new User()
{
Login = login,
Password = password,
Token = token
};
_dbContext.Add(user);
_dbContext.SaveChanges();
return("Done");
}
public ActionResult Create(Country country)
{
try
{
if (ModelState.IsValid)
{
_context.Add(country);
_context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
return(View(country));
}
catch
{
return(View(country));
}
}
public async Task <IActionResult> Create([Bind("NameAddressId,FirstName,LastName,CompanyName,StreetAddress,City,PostalCode,ProvinceCode,Email,Phone")] NameAddress nameAddress)
{
try
{
if (ModelState.IsValid)
{
_context.Add(nameAddress);
await _context.SaveChangesAsync();
TempData["message"] = "Name & Address record added successfully";
return(RedirectToAction(nameof(Index)));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.GetBaseException().Message);
}
// ViewData["ProvinceCode"] = new SelectList(_context.Province, "ProvinceCode", "ProvinceCode", nameAddress.ProvinceCode);
return(View(nameAddress));
}
public async Task <IActionResult> Create([Bind("ContractId,StartDate,GroupId,ClubId,PricePerPerformace,NumberOfPerformances,TotalPrice")] Contract contract)
{
contract.StartDate = Convert.ToDateTime(Request.Form["StartDate"]);
contract.GroupId = Convert.ToInt32(Request.Form["GroupId"]);
contract.ClubId = Convert.ToInt32(Request.Form["ClubId"]);
contract.PricePerPerformace = Convert.ToDouble(Request.Form["PricePerPerformace"]);
contract.NumberOfPerformances = Convert.ToInt32(Request.Form["NumberOfPerformances"]);
contract.TotalPrice = contract.PricePerPerformace * contract.NumberOfPerformances;
if (ModelState.IsValid)
{
_context.Add(contract);
await _context.SaveChangesAsync();
TempData["message"] = "Successfully saved contract with a total cost of: " + contract.TotalPrice;
return(RedirectToAction(nameof(Index)));
}
ViewData["ClubId"] = new SelectList(_context.Club, "ClubId", "Name", contract.ClubId);
ViewData["GroupId"] = new SelectList(_context.Groups, "GroupId", "Name", contract.GroupId);
return(View(contract));
}
public async Task <IActionResult> AddClubAction(IFormCollection data)
{
int count = _dbContext.Clubs.OrderBy(c => - c.Id).Take(1).ToList()[0].Id;
Console.WriteLine(count);
var club = new Club()
{
Id = count + 1,
Name = data["Name"],
Logo = data["Logo"],
LeagueId = Int32.Parse(data["LeagueId"])
};
_dbContext.Add(club);
_dbContext.SaveChanges();
for (int i = 1; i <= 11; i++)
{
var player = new Player()
{
Name = data["PlayerName_" + i],
Age = 22,
Photo = "",
Nation = "USSR",
Flag = "https://upload.wikimedia.org/wikipedia/commons/thumb/a/a9/Flag_of_the_Soviet_Union.svg/800px-Flag_of_the_Soviet_Union.svg.png",
Score = Int32.Parse(data["PlayerScore_" + i]),
Position = data["PlayerPosition_" + i],
Number = Int32.Parse(data["PlayerNumber_" + i]),
ClubId = club.Id
};
_dbContext.Entry(player).State = EntityState.Added;
_dbContext.SaveChanges();
}
return(View());
}
