public ActionResult Edit(utblTourGuide model)
{
try
{
if (ModelState.IsValid)
{
string linktext = Regex.Replace(model.TourGuideName, @"[^0-9A-Za-z ,]", "").Replace(" ", "-");
linktext = linktext.Replace("--", "-").ToLower();
model.TourGuideLink = linktext;
string jsonStr = JsonConvert.SerializeObject(model);
string result = objAPI.PostRecordtoApI("tourguide", "saveguide", jsonStr);
TempData["ErrMsg"] = result;
if (result.ToLower().Contains("error"))
{
ModelState.SetModelValue("TourGuideDesc", new ValueProviderResult(null, HttpUtility.HtmlDecode(model.TourGuideDesc), CultureInfo.InvariantCulture));
return(View(model));
}
return(RedirectToAction("index", "tourguide", new { Area = "admin" }));
}
ModelState.SetModelValue("TourGuideDesc", new ValueProviderResult(null, HttpUtility.HtmlDecode(model.TourGuideDesc), CultureInfo.InvariantCulture));
return(View(model));
}
catch (AuthorizationException)
{
TempData["ErrMsg"] = "Your Login Session has expired. Please Login Again";
return(RedirectToAction("Login", "Account", new { Area = "" }));
}
}
public ActionResult TourGuideDetails(string link)
{
utblTourGuide guide = objAPI.GetObjectByKey <utblTourGuide>("tourpackage", "guidedetails", link, "link");
ViewBag.TourGuides = objAPI.GetAllRecords <TourGuideListView>("tourpackage", "tourguides");
return(View(guide));
}
public async Task <string> SaveGuide(utblTourGuide model)
{
if (ModelState.IsValid)
{
return(await objGuide.SaveGuideAsync(model));
}
string messages = string.Join("; ", ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage));
return("Operation Error: " + messages);
}
public ActionResult Edit(long id)
{
try
{
utblTourGuide model = objAPI.GetObjectByKey <utblTourGuide>("tourguide", "guidebyid", id.ToString(), "id");
model.TourGuideDesc = HttpUtility.HtmlDecode(model.TourGuideDesc);
return(View(model));
}
catch (AuthorizationException)
{
TempData["ErrMsg"] = "Your Login Session has expired. Please Login Again";
return(RedirectToAction("Login", "Account", new { Area = "" }));
}
}
public async Task <string> DeleteGuideAsync(long id)
{
try
{
utblTourGuide obj = await db.utblTourGuides.FindAsync(id);
db.utblTourGuides.Remove(obj);
await db.SaveChangesAsync();
return("Tour Guide Details Removed");
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
public async Task <string> SaveGuideAsync(utblTourGuide model)
{
try
{
var parGuideID = new SqlParameter("@TourGuideID", model.TourGuideID);
var parGuideName = new SqlParameter("@TourGuideName", model.TourGuideName);
var parGuideShortDesc = new SqlParameter("@TourGuideShortDesc", model.TourGuideShortDesc);
var parGuideDesc = new SqlParameter("@TourGuideDesc", model.TourGuideDesc);
var parGuideLink = new SqlParameter("@TourGuideLink", model.TourGuideLink);
return(await db.Database.SqlQuery <string>("udspTourGuideSave @TourGuideID, @TourGuideName, @TourGuideShortDesc, @TourGuideDesc, @TourGuideLink",
parGuideID, parGuideName, parGuideShortDesc, parGuideDesc, parGuideLink).FirstOrDefaultAsync());
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
