public ActionResult Edit(TouristPlace touristPlace, HttpPostedFileBase imagePath)
{
if (ModelState.IsValid)
{
try
{
if (imagePath != null)
{
var extensionOfImage = Path.GetFileName(imagePath.FileName).Split('.');
var fileNameOriginal = Guid.NewGuid().ToString() + "." + extensionOfImage[1];
var filePathOriginal = Request.MapPath(Request.ApplicationPath) + @"/Content/Place_Images";
string savedOrgFileName = Path.Combine(filePathOriginal, fileNameOriginal);
touristPlace.ImagePath = "/Content/Place_Images/" + fileNameOriginal;
if (_touristPlacesService.UpdateTouristPlace(touristPlace))
{
imagePath.SaveAs(savedOrgFileName);
}
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
return(View(touristPlace));
}
public List <TouristPlace> GetTouristPlaces(int subCategoryID, int cityID)
{
String sql = "SELECT * FROM Tourist_Place where SubCategoryID=@1 AND CityID=@2";
List <TouristPlace> touristPlaceList = new List <TouristPlace>();
using (MySqlConnection conn = new MySqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["RajasthanTourismDB_ConnectionString"].ConnectionString;
conn.Open();
using (MySqlCommand command = new MySqlCommand(sql, conn))
{
command.Parameters.AddWithValue("@1", subCategoryID);
command.Parameters.AddWithValue("@2", cityID);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
TouristPlace touristPlace = new TouristPlace();
touristPlace.place = reader["Place"].ToString();
touristPlace.imageUrl = reader["ImageUrl"].ToString();
touristPlace.description = reader["Description"].ToString();
touristPlace.hyperlink = reader["Hyperlink"].ToString();
touristPlaceList.Add(touristPlace);
}
reader.Close();
}
}
return(touristPlaceList);
}
public async Task <IActionResult> Create(TouristPlace touristPlace)
{
try
{
touristPlaceManager.Add(touristPlace);
return(Ok(touristPlace));
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TouristPlace touristPlace = _touristPlacesService.GetTouristPlaceDetailsById(id.Value);
if (touristPlace == null)
{
return(HttpNotFound());
}
return(View(touristPlace));
}
public bool UpdateTouristPlace(TouristPlace touristPlace)
{
try
{
_touristPlacesRepository.Update(touristPlace);
SaveRecord();
return(true);
}
catch (Exception ex)
{
ex.Message.ToString();
return(false);
}
}
public bool InsertTPlace(TouristPlace obj)
{
bool status = false;
using (dbcon = new TourismWebsiteDBEntities())
{
dbcon.TouristPlaces.Add(obj);
int changes = dbcon.SaveChanges();
if (changes > 0)
{
status = true;
}
}
return(status);
}
public bool UpdatePlace(TouristPlace obj)
{
bool status = false;
using (dbcon = new TourismWebsiteDBEntities())
{
var uobj = dbcon.TouristPlaces.Where(x => x.Id == obj.Id).First();
uobj.PlaceName = obj.PlaceName;
uobj.Ratings = obj.Ratings;
int changes = dbcon.SaveChanges();
if (changes > 0)
{
status = true;
}
}
return(status);
}
public ActionResult DeleteConfirmed(int id)
{
TouristPlace touristPlace = _touristPlacesService.GetTouristPlaceDetailsById(id);
try
{
if (_touristPlacesService.DeleteTouristPlace(touristPlace))
{
ViewBag.Message = "Successfully deleted";
}
}
catch (Exception ex)
{
ex.Message.ToString();
ViewBag.Message = "Operation failed";
}
return(RedirectToAction("Index"));
}
public IActionResult Create([Bind("Name,Address,TypeId,Rating,ImageFile")] TouristPlaceViewModel model)
{
if (ModelState.IsValid)
{
if (model.ImageFile != null)
{
string wwwRootPath = _hostEnvironment.WebRootPath;
string fileName = Path.GetFileNameWithoutExtension(model.ImageFile.FileName);
string extension = Path.GetExtension(model.ImageFile.FileName);
model.Image = fileName = fileName + Guid.NewGuid() + extension;
string path = Path.Combine(wwwRootPath + "/image/", fileName);
using var fileStream = new FileStream(path, FileMode.Create);
model.ImageFile.CopyTo(fileStream);
}
TouristPlace entity = _mapper.Map <TouristPlace>(model);
touristPlaceService.InsertTouristPlace(entity);
if (entity.Id > 0)
{
return(Redirect(GetRedirectUrl()));
}
}
ViewBag.Types = new SelectList(touristPlaceTypeService.GetTouristPlaceTypes(), "Id", "TypeName");
return(View(model));
}
public void DeleteTouristPlace(TouristPlace entity)
{
touristPlaceRepository.Delete(entity);
}
public void UpdateTouristPlace(TouristPlace entity)
{
touristPlaceRepository.Update(entity);
}
public void InsertTouristPlace(TouristPlace entity)
{
touristPlaceRepository.Insert(entity);
}
