public void InsertCity(TourCity city)
{
using (var connection = new SqlConnection(this._connectionString))
{
connection.Execute(@"
INSERT INTO [dbo].[TourCities]
([Name]
,[StartDate]
,[DateDisplayed]
,[TourRegionId]
,[ImageUrl]
,[Visible]
,[LastUpdateDate]
,[LastUpdateUserId])
VALUES
(@Name
,@StartDate
,@DateDisplayed
,@TourRegionId
,@ImageUrl
,@Visible
,@LastUpdateDate
,@LastUpdateUserId)", city);
}
}
public IActionResult Update(int tourCityId, [Bind("CityId")] TourCity tourCity)
{
if (ModelState.IsValid)
{
var dbTourCity = _db.TourCities.FirstOrDefault(tc => tc.Id == tourCityId);
if (dbTourCity == null)
{
return(NotFound());
}
dbTourCity.CityId = tourCity.CityId;
_db.TourCities.Update(dbTourCity);
_db.SaveChanges();
return(RedirectToAction(nameof(Index), new { id = dbTourCity.TourId }));
}
else
{
var dbTourCity = _db.TourCities.FirstOrDefault(tc => tc.Id == tourCityId);
SelectListViewModel <TourCity> vmTourCity = new SelectListViewModel <TourCity>()
{
Entity = dbTourCity,
SelectListItems = new SelectList(_db.Cities.OrderBy(c => c.Name), "Id", "Name")
};
return(View(vmTourCity));
}
}
public async Task <IActionResult> AddTourCity([Bind("ID,City")] TourCity tourCity)
{
if (ModelState.IsValid)
{
_context.Add(tourCity);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(BusTourList)));
}
return(View(tourCity));
}
public void UpdateCity(TourCity city)
{
using (var connection = new SqlConnection(this._connectionString))
{
connection.Execute(@"
UPDATE [dbo].[TourCities]
SET [Name] = @Name
,[StartDate] = @StartDate
,[DateDisplayed] = @DateDisplayed
,[TourRegionId] = @TourRegionId
,[ImageUrl] = @ImageUrl
,[Visible] = @Visible
,[LastUpdateDate] = getdate()
,[LastUpdateUserId] = @LastUpdateUserId
WHERE Id = @Id", city);
}
}
public IActionResult Create(int tourId, [Bind("CityId")] TourCity tourCity)
{
if (ModelState.IsValid)
{
tourCity.TourId = tourId;
_db.TourCities.Add(tourCity);
_db.SaveChanges();
return(RedirectToAction("Index", "TourCity", new { id = tourId }));
}
else
{
TourCity city = new TourCity()
{
TourId = tourId
};
return(View(city));
}
}
protected void btnInsert_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
var city = new TourCity()
{
DateDisplayed = txtDateDisplayed.Text,
ImageUrl = txtImage.Text,
LastUpdateDate = DateTime.Now,
LastUpdateUserId = User.Identity.GetUserId(),
Name = txtName.Text,
StartDate = dtDate.Date,
TourRegionId = int.Parse(ddlRegion.SelectedValue),
Visible = cbVisible.Checked
};
var data = new IgniteTourRepository(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
data.InsertCity(city);
Response.Redirect(ResolveUrl("~/Cities/List"));
}
}
