//
// GET: /Users/Details/5
public async Task <ActionResult> UserDetail(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var user = await UserManager.FindByIdAsync(id);
using (var db = new MercuryBackofficeDbContext())
{
var userExt = db.AspNetUsersExtension.Where(x => x.UserId == id).SingleOrDefault();
//if (userExt !=null)
//{
// user.LastLoginOn = (DateTime)userExt.LastLoginOn;
// user.CreatedOn = (DateTime)userExt.CreatedOn;
// user.CreatedBy = userExt.CreatedBy;
// user.UpdatedOn = (DateTime)userExt.UpdatedOn;
// user.UpdatedBy = userExt.UpdatedBy;
//}
}
ViewBag.RoleNames = await UserManager.GetRolesAsync(user.Id);
return(View(user));
}
public async Task <ActionResult> RaceEventTypeCreate(RaceEventTypeViewModel raceEventTypeViewModel)
{
try
{
if (ModelState.IsValid)
{
using (var db = new MercuryBackofficeDbContext())
{
db.RaceEventType.Add(new RaceEventType()
{
//EventTypeId = Incremental
EventTypeName = raceEventTypeViewModel.EventTypeName,
Description = raceEventTypeViewModel.Description,
IsActive = true,
CreatedOn = DateTime.Now,
CreatedBy = this.User.Identity.Name,
UpdatedOn = DateTime.Now,
UpdatedBy = this.User.Identity.Name,
});
var result = await db.SaveChangesAsync();
}
return(RedirectToAction(PageURL.url_Race_RaceEventType_List));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex);
return(View());
}
return(View());
}
public async Task <ActionResult> UserEdit([Bind(Include = "Email, Id, Address, City, State, PostalCode")] EditUserViewModel editUser, params string[] selectedRole)
{
if (ModelState.IsValid)
{
var user = await UserManager.FindByIdAsync(editUser.Id);
if (user == null)
{
return(HttpNotFound());
}
user.UserName = editUser.Email;
user.Email = editUser.Email;
user.Address = editUser.Address;
user.City = editUser.City;
user.State = editUser.State;
user.PostalCode = editUser.PostalCode;
var userRoles = await UserManager.GetRolesAsync(user.Id);
selectedRole = selectedRole ?? new string[] { };
var result = await UserManager.AddToRolesAsync(user.Id, selectedRole.Except(userRoles).ToArray <string>());
if (!result.Succeeded)
{
ModelState.AddModelError("", result.Errors.First());
return(View());
}
result = await UserManager.RemoveFromRolesAsync(user.Id, userRoles.Except(selectedRole).ToArray <string>());
if (!result.Succeeded)
{
ModelState.AddModelError("", result.Errors.First());
return(View());
}
//Update into User Extension table
using (var db = new MercuryBackofficeDbContext())
{
var userExt = await db.AspNetUsersExtension.Where(x => x.UserId == user.Id).SingleOrDefaultAsync();
if (userExt != null)
{
userExt.UpdatedBy = User.Identity.Name.ToString();
userExt.UpdatedOn = DateTime.Now;
}
await db.SaveChangesAsync();
}
return(RedirectToAction(PageURL.url_Management_User_List));
}
ModelState.AddModelError("", "Something failed.");
return(View());
}
//public async Task<ActionResult> RaceEventEdit([Bind(Include = "Name,Id,Description")] RoleViewModel roleModel)
public ActionResult RaceEventEdit(RaceEventViewModel raceEventViewModel)
{
try
{
if (ModelState.IsValid)
{
using (var db = new MercuryBackofficeDbContext())
{
var raceEvent = db.RaceEvent.Where(x => x.EventId.ToString() == raceEventViewModel.EventId.ToString()).SingleOrDefault();
if (raceEvent == null)
{
return(HttpNotFound());
}
if (raceEvent != null)
{
raceEvent.EventName = raceEventViewModel.EventName;
raceEvent.Description = raceEventViewModel.Description;
raceEvent.EventOrganiser = raceEventViewModel.EventOrganiser;
raceEvent.EventTypeId = raceEventViewModel.EventTypeId;
raceEvent.EventVenue = raceEventViewModel.EventVenue;
raceEvent.EventStartOn = raceEventViewModel.EventStartOn;
raceEvent.EventEndOn = raceEventViewModel.EventEndOn;
raceEvent.IsTimingChip = raceEventViewModel.IsTimingChip;
raceEvent.IsActive = raceEventViewModel.IsActive;
raceEvent.IsCharity = raceEventViewModel.IsCharity;
raceEvent.Latitude = raceEventViewModel.Latitude;
raceEvent.Longitude = raceEventViewModel.Longitude;
raceEvent.FacebookURL = raceEventViewModel.FacebookURL;
raceEvent.GooglePlusURL = raceEventViewModel.GooglePlusURL;
raceEvent.InstagramURL = raceEventViewModel.InstagramURL;
raceEvent.TwitterURL = raceEventViewModel.TwitterURL;
//raceEvent.CreatedOn = DateTime.Now;
//raceEvent.CreatedBy = User.Identity.Name;
raceEvent.UpdatedOn = DateTime.Now;
raceEvent.UpdatedBy = User.Identity.Name;
}
var result = db.SaveChanges();
//if (result)
//{
return(RedirectToAction(PageURL.url_Race_RaceEvent_List));
//}
}
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex);
return(View());
}
return(View());
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public ActionResult RaceResultList(string id)
{
try
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ViewBag.EventId = id;
using (var db = new MercuryBackofficeDbContext())
{
var raceEvent = db.RaceEvent.Where(x => x.EventId.ToString() == id.ToString()).SingleOrDefault();
if (raceEvent == null)
{
return(HttpNotFound());
}
RaceEventViewModel raceEventViewModel = new RaceEventViewModel()
{
EventId = raceEvent.EventId.ToString(),
EventName = raceEvent.EventName,
Description = raceEvent.Description,
EventOrganiser = raceEvent.EventOrganiser,
EventTypeId = raceEvent.EventTypeId,
EventVenue = raceEvent.EventVenue,
EventStartOn = raceEvent.EventStartOn,
EventEndOn = raceEvent.EventEndOn,
IsTimingChip = raceEvent.IsTimingChip,
IsActive = raceEvent.IsActive,
IsCharity = raceEvent.IsCharity,
Latitude = raceEvent.Latitude,
Longitude = raceEvent.Longitude,
FacebookURL = raceEvent.FacebookURL,
GooglePlusURL = raceEvent.GooglePlusURL,
InstagramURL = raceEvent.InstagramURL,
TwitterURL = raceEvent.TwitterURL,
CreatedOn = raceEvent.CreatedOn,
CreatedBy = raceEvent.CreatedBy,
UpdatedOn = raceEvent.UpdatedOn,
UpdatedBy = raceEvent.UpdatedBy
};
return(View(raceEventViewModel));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex);
return(View());
}
}
//public List<RaceEventType> GetRaceEventTypeLOV()
//{
// var records = dbContext.RaceEventType.Where(x => x.IsActive == true).OrderBy("EventTypeName", "OrderBy").ToList();
// if (records != null) { return new List<RaceEventType>(); }
// return records;
//}
public static List <RaceEventType> GetRaceEventTypeLOV()
{
using (var db = new MercuryBackofficeDbContext())
{
var records = db.RaceEventType.Where(x => x.IsActive == true).OrderBy("EventTypeName", "OrderBy").ToList();
if (records == null)
{
return(new List <RaceEventType>());
}
return(records);
}
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <ActionResult> RaceEventDetail(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (var db = new MercuryBackofficeDbContext())
{
var raceEvents = await db.RaceEvent.Where(x => x.EventId.ToString() == id.ToString()).ToListAsync();
ViewBag.RaceEvents = raceEvents;
ViewBag.RaceEventCount = raceEvents.Count();
return(View(raceEvents));
}
}
public async Task <ActionResult> RaceEventCreate(RaceEventViewModel raceEventViewModel)
{
try
{
if (ModelState.IsValid)
{
using (var db = new MercuryBackofficeDbContext())
{
db.RaceEvent.Add(new RaceEvent()
{
EventId = Guid.NewGuid().ToString().ToUpper(),
EventName = raceEventViewModel.EventName,
Description = raceEventViewModel.Description,
EventTypeId = raceEventViewModel.EventTypeId,
EventOrganiser = raceEventViewModel.EventOrganiser,
EventStartOn = raceEventViewModel.EventStartOn,
EventEndOn = raceEventViewModel.EventEndOn,
EventVenue = raceEventViewModel.EventVenue,
Latitude = null,
Longitude = null,
FacebookURL = null,
GooglePlusURL = null,
InstagramURL = null,
TwitterURL = null,
IsCharity = raceEventViewModel.IsCharity,
IsTimingChip = raceEventViewModel.IsTimingChip,
IsActive = true,
CreatedOn = DateTime.Now,
CreatedBy = this.User.Identity.Name,
UpdatedOn = DateTime.Now,
UpdatedBy = this.User.Identity.Name,
});
var result = await db.SaveChangesAsync();
}
return(RedirectToAction(PageURL.url_Race_RaceEvent_List));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex);
return(View());
}
return(View());
}
public void ConstructNavigationData(string roleId)
{
MenuListing = new List <Menu>();
MenuItemListing = new List <MenuItem>();
if (roleId == string.Empty)
{
return;
}
using (var db = new MercuryBackofficeDbContext())
{
MenuListing = db.Menu.Where(x => x.Roles.Contains(roleId)).ToList();
MenuItemListing = db.MenuItem.Where(x => x.Roles.Contains(roleId)).ToList();
}
return;
}
//public async Task<ActionResult> RaceEventTypeEdit([Bind(Include = "Name,Id,Description")] RoleViewModel roleModel)
public ActionResult RaceEventTypeEdit(RaceEventTypeViewModel raceEventTypeViewModel)
{
try
{
if (ModelState.IsValid)
{
using (var db = new MercuryBackofficeDbContext())
{
var raceEventType = db.RaceEventType.Where(x => x.EventTypeId.ToString() == raceEventTypeViewModel.EventTypeId.ToString()).SingleOrDefault();
if (raceEventType == null)
{
return(HttpNotFound());
}
if (raceEventType != null)
{
raceEventType.EventTypeName = raceEventTypeViewModel.EventTypeName;
raceEventType.Description = raceEventTypeViewModel.Description;
raceEventType.IsActive = raceEventTypeViewModel.IsActive;
//raceEventType.CreatedOn = DateTime.Now;
//raceEventType.CreatedBy = User.Identity.Name;
raceEventType.UpdatedOn = DateTime.Now;
raceEventType.UpdatedBy = User.Identity.Name;
}
var result = db.SaveChanges();
//if (result)
//{
return(RedirectToAction(PageURL.url_Race_RaceEventType_List));
//}
}
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex);
return(View());
}
return(View());
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <ActionResult> RaceEventTypeDelete(string id)
{
try
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (var db = new MercuryBackofficeDbContext())
{
var raceEventType = await db.RaceEventType.Where(x => x.EventTypeId.ToString() == id.ToString()).SingleOrDefaultAsync();
if (raceEventType == null)
{
return(HttpNotFound());
}
RaceEventTypeViewModel raceEventTypeViewModel = new RaceEventTypeViewModel()
{
EventTypeId = raceEventType.EventTypeId,
EventTypeName = raceEventType.EventTypeName,
Description = raceEventType.Description,
IsActive = raceEventType.IsActive,
//CreatedOn = DateTime.Now,
//CreatedBy = User.Identity.Name,
UpdatedOn = DateTime.Now,
UpdatedBy = User.Identity.Name
};
return(View(raceEventTypeViewModel));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex);
return(View());
}
}
public async Task <ActionResult> UserDeleteConfirmed(string id)
{
if (ModelState.IsValid)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var user = await UserManager.FindByIdAsync(id);
if (user == null)
{
return(HttpNotFound());
}
var result = await UserManager.DeleteAsync(user);
if (!result.Succeeded)
{
ModelState.AddModelError("", result.Errors.First());
return(View());
}
//Delete from User Extension table
using (var db = new MercuryBackofficeDbContext())
{
var userExt = await db.AspNetUsersExtension.Where(x => x.UserId == user.Id).SingleOrDefaultAsync();
if (userExt != null)
{
db.AspNetUsersExtension.Remove(userExt);
}
await db.SaveChangesAsync();
}
return(RedirectToAction(PageURL.url_Management_User_List));
}
return(View());
}
public async Task <ActionResult> RaceEventTypeDeleteConfirmed(string id, string deleteRaceEventType)
{
try
{
if (ModelState.IsValid)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (var db = new MercuryBackofficeDbContext())
{
var raceEventType = await db.RaceEventType.Where(x => x.EventTypeId.ToString() == id.ToString()).SingleOrDefaultAsync();
if (raceEventType == null)
{
return(HttpNotFound());
}
if (raceEventType != null)
{
db.RaceEventType.Remove(raceEventType);
await db.SaveChangesAsync();
return(RedirectToAction(PageURL.url_Race_RaceEventType_List));
}
}
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex);
return(View());
}
return(View());
}
public async Task <ActionResult> UserCreate(RegisterViewModel userViewModel, params string[] selectedRoles)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser
{
UserName = userViewModel.Email,
Email =
userViewModel.Email,
// Add the Address Info:
Address = userViewModel.Address,
City = userViewModel.City,
State = userViewModel.State,
PostalCode = userViewModel.PostalCode
};
// Add the Address Info:
user.Address = userViewModel.Address;
user.City = userViewModel.City;
user.State = userViewModel.State;
user.PostalCode = userViewModel.PostalCode;
// Then create:
var adminresult = await UserManager.CreateAsync(user, userViewModel.Password);
//Add User to the selected Roles
if (adminresult.Succeeded)
{
if (selectedRoles != null)
{
var result = await UserManager.AddToRolesAsync(user.Id, selectedRoles);
if (!result.Succeeded)
{
ModelState.AddModelError("", result.Errors.First());
ViewBag.RoleId = new SelectList(await RoleManager.Roles.OrderBy(x => x.Name).ToListAsync(), "Name", "Name");
return(View());
}
}
//Save into User Extension table
using (var db = new MercuryBackofficeDbContext())
{
db.AspNetUsersExtension.Add(new AspNetUsersExtension()
{
UserId = user.Id,
LastLoginOn = null,
CreatedBy = User.Identity.Name.ToString(),
CreatedOn = DateTime.Now,
UpdatedBy = User.Identity.Name.ToString(),
UpdatedOn = DateTime.Now
});
await db.SaveChangesAsync();
}
}
else
{
ModelState.AddModelError("", adminresult.Errors.First());
ViewBag.RoleId = new SelectList(RoleManager.Roles.OrderBy(x => x.Name).ToList(), "Name", "Name");
return(View());
}
return(RedirectToAction(PageURL.url_Management_User_List));
}
ViewBag.RoleId = new SelectList(RoleManager.Roles.OrderBy(x => x.Name).ToList(), "Name", "Name");
return(View());
}
