public DataModel.Modal.Office GetOffice(int id)
{
try
{
DataSet dataSet;
using (var command = database.GetStoredProcCommand("[dbo].[sproc_SimplePlatForm_GetOfficesByID]"))
{
database.AddInParameter(command, "@ID", DbType.Int32, id);
dataSet = database.ExecuteDataSet(command);
}
if (dataSet == null || dataSet.Tables.Count <= 0) return null;
var dataTable = dataSet.Tables[0];
var userManager = new DataAccess.UserManager();
var office = (from dataRow in dataTable.AsEnumerable()
select new DataModel.Modal.Office
{
OfficeId = dataRow.Field<int>("OfficeId"),
Name = dataRow.Field<string>("Name"),
ContactNo = dataRow.Field<string>("ContactNo"),
City = dataRow.Field<string>("City"),
UsersDetail = userManager.GetUserByOfficeID(dataRow.Field<int>("OfficeId"), 2),
FileResource = new DataModel.Modal.FileResource { Id = dataRow.Field<int>("Id"), name = dataRow.Field<string>("name"), path = dataRow.Field<string>("path") }
}).FirstOrDefault();
return office;
}
catch (Exception ex)
{
return null;
}
}
public JsonResult GetUsers()
{
var userManager = new DataAccess.UserManager();
var userDetails = userManager.GetUsers(IsAdmin ? 0 : UserDetail.UserId);
var users = userDetails.Where(model => (!model.User.Roles.Any(roleModel => roleModel.RoleId == 1) || IsAdmin))
.Select(modal => new { id = modal.UserId, firstName = modal.User.FirstName, lastName = modal.User.LastName, createDate = modal.User.CreateDate.ToString("dd-MM-yyyy"), userRoles = string.Join(", ", modal.User.Roles.Select(roleModal => roleModal.RoleName).ToArray()), userRolesID = string.Join(",", modal.User.Roles.Select(roleModal => roleModal.RoleId).ToArray()), userOfficesID = string.Join(",", modal.Offices.Select(officeModel => officeModel.OfficeId).ToArray()) })
.ToList();
return Json(new { data = users });
}
public PartialViewResult Edit(int id)
{
var customRoleProvider = new CustomAuthentication.CustomRoleProvider();
var userManager = new DataAccess.UserManager();
var user = userManager.GetUserDetail(id);
var roles = IsAdmin ? customRoleProvider.GetAllRoles() : customRoleProvider.GetAllRoles().Where(model => model.RoleId != 1 && model.RoleId != 2).ToList();
ViewData["UserRoles"] = roles;
var officeMananer = new DataAccess.OfficeMananer();
ViewData["Offices"] = officeMananer.GetOffices(IsAdmin ? 0 : UserDetail.UserId);
return PartialView(user);
}
public PartialViewResult Edit(int id)
{
var userDetailManager = new DataAccess.UserManager();
var officeMananer = new DataAccess.OfficeMananer();
var user = userDetailManager.GetUserDetail(UserDetail.UserId);
var offices = officeMananer.GetOffices(IsAdmin ? 0 : UserDetail.UserId);
ViewData["Offices"] = offices;
var conventionManager = new DataAccess.ConventionManager();
var conventions = conventionManager.GetConventions();
ViewData["Conventions"] = conventions;
var eventManager = new DataAccess.EventManager();
var eventDetail = eventManager.GetEventDetail(id);
return PartialView(eventDetail);
}
public ActionResult Add()
{
var userDetailManager = new DataAccess.UserManager();
var officeMananer = new DataAccess.OfficeMananer();
var user = userDetailManager.GetUserDetail(UserDetail.UserId);
var offices = officeMananer.GetOffices(IsAdmin ? 0 : UserDetail.UserId);
ViewData["Offices"] = offices;
var conventionManager = new DataAccess.ConventionManager();
var conventions = conventionManager.GetConventions();
ViewData["Conventions"] = conventions;
if (IsAdmin)
{
var customRoleProvider = new CustomAuthentication.CustomRoleProvider();
var customMembershipProvider = new CustomAuthentication.CustomMembershipProvider();
ViewData["Employee"] = customMembershipProvider.GetUsers(4);
}
return PartialView();
}
protected override void OnActionExecuting(ActionExecutingContext filterContext)
{
#region User Specific Settings
var sessionUser = (CustomAuthentication.User)(Session["User"]);
var userManager = new DataAccess.UserManager();
user = userManager.GetUserDetail(sessionUser.UserId);
isAdmin = sessionUser.Roles.Any(model => model.RoleName.Equals(ADMIN_ROLE, StringComparison.InvariantCultureIgnoreCase));
#endregion
ControllerName = filterContext.RouteData.Values["controller"].ToString() + filterContext.RouteData.Values["action"].ToString();
ViewData["Controller_Name"] = ControllerName;
ViewData["UserDetail"] = UserDetail;
BundleConfig.AddScript("~/Scripts/Users", "users.js", ControllerName);
Script = string.Empty;
StartupScript = string.Empty;
Script = string.Format("var pageName = \"{0}\";", filterContext.RouteData.Values["controller"].ToString());
base.OnActionExecuting(filterContext);
}
public List<int> GetOfficeIDs(int userID)
{
try
{
DataSet dataSet;
using (var command = database.GetStoredProcCommand("[dbo].[sproc_SimplePlatForm_GetOfficeIDsByUserID]"))
{
database.AddInParameter(command, "@userID", DbType.Int32, userID);
dataSet = database.ExecuteDataSet(command);
}
if (dataSet == null || dataSet.Tables.Count <= 0) return null;
var dataTable = dataSet.Tables[0];
var userManager = new DataAccess.UserManager();
var offices = (from dataRow in dataTable.AsEnumerable()
select dataRow.Field<int>("OfficeId")).ToList();
return offices;
}
catch (Exception ex)
{
return null;
}
}
public JsonResult UpdatePassword(string oldPassword, string newPassword)
{
var userManager = new DataAccess.UserManager();
var status = userManager.UpdatePassword(oldPassword, newPassword, UserDetail.UserId);
return Json(status);
}
public JsonResult Update(int id, string firstName, string lastName, string emildID, int userRoleID, List<string> officesID)
{
var userManager = new DataAccess.UserManager();
var status = userManager.UpdateUser(id, firstName, lastName, emildID, userRoleID, officesID);
return Json(status);
}
public JsonResult Delete(int id)
{
var userManager = new DataAccess.UserManager();
var status = userManager.DeleteUser(id);
return Json(status);
}
public JsonResult AddDateDuration(DateTime startDate, DateTime endDate)
{
var userManager = new DataAccess.UserManager();
var status = userManager.AddDateDuration(startDate, endDate, UserDetail.UserId);
return Json(true);
}
public JsonResult UpdateProfileImage()
{
var status = false;
HttpPostedFileBase myFile = null;
if (Request.Files.Count > 0) myFile = Request.Files[0];
if (myFile != null && myFile.ContentLength != 0)
{
string pathForSaving = Server.MapPath("~/ImageUploads");
if (SharedFunction.CreateFolderIfNeeded(pathForSaving))
{
try
{
string fileName = DateTime.Now.ToString("MMddyyyyHHmmss") + Path.GetExtension(myFile.FileName);
myFile.SaveAs(Path.Combine(pathForSaving, fileName));
string path = "~/ImageUploads/" + fileName;
var userManager = new DataAccess.UserManager();
status = userManager.UpdateUser(Convert.ToInt32(Request.Form["id"]), Request.Form["firstName"].ToString(), Request.Form["lastName"].ToString(), Request.Form["emildID"].ToString(), Convert.ToInt32(Request.Form["userRoleID"]), Request.Form["officesID"].Split(',').ToList(), fileName, path);
}
catch (Exception ex)
{
return Json(ex.InnerException);
}
}
}
return Json(status);
}
