public ActionResult LogIn(LogInModel model, string returnUrl) { ViewBag.DisplayError = true; string decodedUrl = ""; if (VerifyLogin(model.UserName, model.Password, model.RememberMe)) { int role = UserRoleData.GetByUserId(Authentication.CurrentUser.UserId).RoleId; if (!string.IsNullOrEmpty(returnUrl)) { decodedUrl = Server.UrlDecode(returnUrl); return Redirect(decodedUrl); } else { if (role == 1 || role == 2) { return RedirectToAction("Index", "User"); } else { return RedirectToAction("Dashboard", "Home"); } } } else { ViewBag.ErrorLogin = true; } ViewBag.ReturnURL = returnUrl; return View(); }
// GET: Admin public ActionResult ManageRoles() { //Setup some data that can be used inside the view var viewData = new List <UserRoleData>(); var users = db.Users.ToList(); foreach (var user in users) { var newUserData = new UserRoleData(); newUserData.FirstName = user.FirstName; newUserData.LastName = user.LastName; newUserData.Email = user.Email; newUserData.RoleName = roleHelper.ListUserRoles(user.Id).FirstOrDefault() ?? "UnAssigned"; viewData.Add(newUserData); } //Left hand side control: This data will be used to power ListBox in the View ViewBag.UserIds = new MultiSelectList(db.Users, "Id", "Email"); //Right hand side control: This data will be used to power a Dropdown List in the View ViewBag.RoleName = new SelectList(db.Roles, "Name", "Name"); return(View(viewData)); }
public AdminController(IArticleData articleData, IApiErrorHandler apiErrorHandler, AssignedMedicineData assignedMedicineData, AssignedPlanData assignedPlanData, IFeedbackData feedbackData, ILabTestData labTestData, IMapper mapper, LabTestRequestsData labTestRequestsData, MedicineData medicineData, PatientNoteData patientNoteData, UserData userData, UserManager <ApplicationUser> userManager, RoleManager <ApplicationRole> roleManager, UserRoleData userRoleData, PatientData patientData, PatientProgressData patientProgressData) { _articleData = articleData; _apiErrorHandler = apiErrorHandler; _assignedMedicineData = assignedMedicineData; _assignedPlanData = assignedPlanData; _feedbackData = feedbackData; _labTestData = labTestData; _mapper = mapper; _labTestRequestsData = labTestRequestsData; _medicineData = medicineData; _patientNoteData = patientNoteData; _userData = userData; _userManager = userManager; _roleManager = roleManager; _userRoleData = userRoleData; _patientData = patientData; _patientProgressData = patientProgressData; }
public static IdType Insert(UserRoleData data) { // Create and execute the command string sql = "Insert Into " + TABLE + "(" + "UserId," + "RoleId," + "PermitDeny," ; sql = sql.Substring(0, sql.Length - 1) + ") values(" + "@UserId," + "@RoleId," + "@PermitDeny," ; sql = sql.Substring(0, sql.Length - 1) + ");select Scope_Identity() Id"; SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT); //Create the parameters and append them to the command object cmd.Parameters.Add(new SqlParameter("@UserId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "UserId", DataRowVersion.Proposed, data.UserId.DBValue)); cmd.Parameters.Add(new SqlParameter("@RoleId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "RoleId", DataRowVersion.Proposed, data.RoleId.DBValue)); cmd.Parameters.Add(new SqlParameter("@PermitDeny", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "PermitDeny", DataRowVersion.Proposed, data.PermitDeny.DBValue)); // Execute the query SqlDataReader returnValue = cmd.ExecuteReader(); returnValue.Read(); int returnId = (int)(returnValue.GetDecimal(0)); returnValue.Close(); // Set the output paramter value(s) return(new IdType(returnId)); }
public List <SqlParameter> MapParamsForUpsert(UserRoleData entity) { var sql_params = new List <SqlParameter>(); sql_params.Add(new SqlParameter("@RoleID", entity.RoleID)); sql_params.Add(new SqlParameter("@UserId", entity.UserID)); return(sql_params); }
/// <summary> /// Default constructor that initializes a new MySQLDatabase /// instance using the Default Connection string /// </summary> public UserStore() { userTable = new UserData(); roleTable = new RoleData(); userRolesTable = new UserRoleData(); userClaimsTable = new UserClaimsData(); userLoginsTable = new UserLoginsData(); }
private async Task AddUserToRoles(UserRoleData data) { Usr user = await _userManager.FindByNameAsync(data.Username) ?? await _userManager.FindByEmailAsync(data.Username); await Task.WhenAll( data.Roles.Select(r => { return(AddUserToRole(user, r)); }).ToArray() ); }
public ActionResult Edit(int UserId) { ViewBag.Region = db.Regions.ToList(); User user = UserData.Fetch(UserId); UserRole role = UserRoleData.GetByUserId(user.UserId); ViewBag.Role = role.RoleId; return(PartialView("Edit", user)); }
public override void OnApplyTemplate() { base.OnApplyTemplate(); if (!DesignerProperties.GetIsInDesignMode(this)) { foreach (var userRole in UserRoleData.ReadUserRoles()) { UserRoles.Add(userRole); } } }
public static int GetRoleId(int UserId) { UserRole role = UserRoleData.GetByUserId(UserId); if (role != null) { return(role.RoleId); } else { return(0); } }
public static string GetRoleName(int UserId) { UserRole role = UserRoleData.GetByUserId(UserId); if (role != null) { return(RoleData.GetById(role.RoleId).Name); } else { return("n/a"); } }
// GET: Bookings/Details/5 public async Task <IActionResult> Details(int?id) { if (id == null) { return(NotFound()); } var booking = await _context.Bookings .Include(b => b.Boat) .Include(b => b.User) .Include(b => b.UserBookings) .ThenInclude(b => b.User) .OrderBy(b => b.StartDateTime) .SingleOrDefaultAsync(m => m.BookingId == id); if (booking == null) { return(NotFound()); } var userRoles = new List <UserRoleData>(); foreach (var b in booking.UserBookings) { var userRole = new UserRoleData { FisrtName = b.User.FirstName, LastName = b.User.LastName, UsedCredit = b.UsedCredit, RoleName = string.Join(",", _userManager.GetRolesAsync(b.User).Result) }; userRoles.Add(userRole); } var model = new BookingViewModel { BookingId = booking.BookingId, BoatId = booking.BoatId, BoatName = booking.Boat.BoatName, StartDateTime = booking.StartDateTime, EndDateTime = booking.EndDateTime, NonMemberCrews = booking.NonMemberCrews, Itinerary = booking.Itinerary, AllocatedHours = booking.AllocatedHours, UserId = booking.UserId, MemberCrews = userRoles }; return(View(model)); }
public bool RemoveFromRole(User user, string roleName) { IUserRoleRepository repo = _data_repository_factory.GetIdentityDataRepository <IUserRoleRepository>(); IIdentityRoleBusinessEngine role_be = _business_engine_factory.GetBusinessEngine <IIdentityRoleBusinessEngine>(); var role = role_be.FindByName(roleName); UserRoleData ur = new UserRoleData() { RoleID = role.RoleId, UserID = user.UserId }; repo.Delete(ur); return(true); }
public static void Update(UserRoleData data) { // Create and execute the command UserRoleData oldData = Load(data.UserRoleId); string sql = "Update " + TABLE + " set "; if (!oldData.UserId.Equals(data.UserId)) { sql = sql + "UserId=@UserId,"; } if (!oldData.RoleId.Equals(data.RoleId)) { sql = sql + "RoleId=@RoleId,"; } if (!oldData.PermitDeny.Equals(data.PermitDeny)) { sql = sql + "PermitDeny=@PermitDeny,"; } WhereClause w = new WhereClause(); w.And("UserRoleId", data.UserRoleId.DBValue); sql = sql.Substring(0, sql.Length - 1) + w.FormatSql(); SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT); //Create the parameters and append them to the command object if (!oldData.UserRoleId.Equals(data.UserRoleId)) { cmd.Parameters.Add(new SqlParameter("@UserRoleId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "UserRoleId", DataRowVersion.Proposed, data.UserRoleId.DBValue)); } if (!oldData.UserId.Equals(data.UserId)) { cmd.Parameters.Add(new SqlParameter("@UserId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "UserId", DataRowVersion.Proposed, data.UserId.DBValue)); } if (!oldData.RoleId.Equals(data.RoleId)) { cmd.Parameters.Add(new SqlParameter("@RoleId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "RoleId", DataRowVersion.Proposed, data.RoleId.DBValue)); } if (!oldData.PermitDeny.Equals(data.PermitDeny)) { cmd.Parameters.Add(new SqlParameter("@PermitDeny", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "PermitDeny", DataRowVersion.Proposed, data.PermitDeny.DBValue)); } // Execute the query if (cmd.Parameters.Count > 0) { cmd.ExecuteNonQuery(); } }
private Tuple <CreateRoleData, DeleteRoleData, UserRoleData> GenerateModel(CreateRoleData item1 = null) { var roles = Roles.GetAllRoles(); var usernames = Database.Open("ContactMessageDatabase").Query("SELECT Email FROM UserProfile") .Select(r => r.Email).Cast <string>(); var createData = item1 ?? new CreateRoleData(); var deleteData = new DeleteRoleData { Roles = roles }; var userRole = new UserRoleData { Roles = roles, UserNames = usernames }; return(Tuple.Create(createData, deleteData, userRole)); }
public int AddToRole(User user, string roleName) { IUserRoleRepository repo = _data_repository_factory.GetIdentityDataRepository <IUserRoleRepository>(); IIdentityRoleBusinessEngine role_be = _business_engine_factory.GetBusinessEngine <IIdentityRoleBusinessEngine>(); var role = role_be.FindByName(roleName); Log.Debug($"Adding Role User Rel: Role:{role.RoleId}; UserID: {user.UserId}"); UserRoleData ur = new UserRoleData() { RoleID = role.RoleId, UserID = user.UserId }; return(repo.Save(ur)); }
public ActionResult AddRemoveUserRole(UserRoleData model) { Action <string, string> fn; if (!string.IsNullOrEmpty(model.AddUserRole)) { fn = Roles.AddUserToRole; } else { fn = Roles.RemoveUserFromRole; } fn(model.UserName, model.RoleName); return(new RedirectResult(RedirectUrl)); }
public static UserRoleData Load(IdType userRoleId) { WhereClause w = new WhereClause(); w.And("UserRoleId", userRoleId.DBValue); SqlDataReader dataReader = GetListReader(DatabaseEnum.ORDERDB, TABLE, w, null, true); if (!dataReader.Read()) { dataReader.Close(); throw new FinderException("Load found no rows for UserRole."); } UserRoleData data = GetDataObjectFromReader(dataReader); dataReader.Close(); return(data); }
//[Authorize(Policy = "RequireLogin", AuthenticationSchemes = OAuthValidationDefaults.AuthenticationScheme)] public IEnumerable <BookingViewModel> GetBooking() { var bookings = _context.Bookings .Include(b => b.Boat) .Include(b => b.User) .Include(b => b.UserBookings) .ThenInclude(b => b.User) .OrderBy(b => b.StartDateTime); var bookingModels = new List <BookingViewModel>(); foreach (var b in bookings) { var userRoles = new List <UserRoleData>(); foreach (var br in b.UserBookings) { var userRole = new UserRoleData { FisrtName = br.User.FirstName, LastName = br.User.LastName, RoleName = string.Join(",", _userManager.GetRolesAsync(b.User).Result) }; userRoles.Add(userRole); } var booking = new BookingViewModel { BookingId = b.BookingId, BoatId = b.BoatId, BoatName = b.Boat.BoatName, StartDateTime = b.StartDateTime, EndDateTime = b.EndDateTime, NonMemberCrews = b.NonMemberCrews, Itinerary = b.Itinerary, UserId = b.UserId, FirstName = b.User.FirstName, LastName = b.User.LastName, MemberCrews = userRoles }; bookingModels.Add(booking); } return(bookingModels); }
public JsonResult Fetch(string Id) { if (Id == null) { Id = 0.ToString(); } UserRole ur = UserRoleData.GetByUserId(Convert.ToInt32(Id)); if (ur == null) { return(this.Json(new { result = "false" }, JsonRequestBehavior.AllowGet)); } int RoleId = ur.RoleId; List <ModuleModel> model = ModuleData.GetModel(RoleId); //List<UserRight> model = UserRightData.GetList().Where(o=>o.UserId==Convert.ToInt32(Id)).ToList(); ViewBag.RoleDetails = RoleDetailData.GetById(Convert.ToInt32(Id)); ViewBag.Roles = RoleData.ListAll(); ViewBag.Modules = ModuleData.GetList(); string[] mId = new string[model.Count]; string[] mName = new string[model.Count]; string[] misAllowed = new string[model.Count]; string[] misAllowedOverride = new string[model.Count]; for (int i = 0; i < model.Count; i++) { mId[i] = model[i].ModuleId.ToString(); mName[i] = model[i].Name.ToString(); UserRight right = UserRightData.FindUserRight(Convert.ToInt32(Id), model[i].ModuleId); misAllowed[i] = model[i].IsAllowed.ToString(); if (right == null) { misAllowedOverride[i] = model[i].IsAllowed.ToString(); } else { misAllowedOverride[i] = right.IsAllowed.ToString(); } } return(this.Json(new { id = mId, name = mName, isallowed = misAllowed, isallowed2 = misAllowedOverride }, JsonRequestBehavior.AllowGet)); }
protected void btnUserRoleRightsSave_Click(object sender, EventArgs e) { try { for (int i = 1; i < lvUserRoleRightsDetails.Items.Count; i++) { string companyid = (lvUserRoleRightsDetails.Items[i].FindControl("lblCompanyID") as Label).Text; string module = (lvUserRoleRightsDetails.Items[i].FindControl("lblModule") as Label).Text; string screen = (lvUserRoleRightsDetails.Items[i].FindControl("lblScreen") as Label).Text; ListView innerLisview = lvUserRoleRightsDetails.Items[i].FindControl("lvRoleAssignToScreenDetails") as ListView; for (int innerLvCount = 0; innerLvCount < innerLisview.Items.Count; innerLvCount++) { UserRoleData data = new UserRoleData(); data.RoleID = (innerLisview.Items[innerLvCount].FindControl("hfRoleID") as HiddenField).Value; data.CompanyID = companyid; data.Module = module; data.Screen = screen; if ((innerLisview.Items[innerLvCount].FindControl("rbRead") as RadioButton).Checked) { data.Value = "Read"; data.CheckOrUncheck = "Check"; } else if ((innerLisview.Items[innerLvCount].FindControl("rbModify") as RadioButton).Checked) { data.Value = "Modify"; data.CheckOrUncheck = "Check"; } else { data.Value = "None"; data.CheckOrUncheck = "UnCheck"; } DBAccess.saveUpdateUserRoleRightsDetails(data); } } ScriptManager.RegisterStartupScript(this, this.GetType(), "successMsg", "showSuccessMsg('Record saved Successfully.','');", true); BindUserRoleRightsData(); } catch (Exception ex) { } }
public async Task <IEnumerable <UserRoleData> > ListAllUsersWithRolesAsync() { var users = await _userManager.Users.ToListAsync(); var userRolesList = new List <UserRoleData>(); foreach (UserProfile user in users) { var tempViewModel = new UserRoleData(); tempViewModel.UserId = user.Id; tempViewModel.Email = user.Email; tempViewModel.FirstName = user.FirstName; tempViewModel.LastName = user.LastName; tempViewModel.Roles = await GetUserRoles(user); userRolesList.Add(tempViewModel); } return(userRolesList); }
public Models.Business.UserAccountData GetUserAccount(string userName, string passWord) { try { var userRoleList = db.Roles.ToList(); var userRoleDataList = new List <UserRoleData>(); foreach (var item in userRoleList) { var userRole = new UserRoleData { RoleID = item.RoleID, RoleName = item.RoleName, CreatedBy = item.CreatedBy, CreatedDate = item.CreatedDate }; userRoleDataList.Add(userRole); } var userAccounts = db.UserAccounts.Where(m => m.UserName == userName && m.Password == passWord).SingleOrDefault(); Models.Business.UserAccountData obj = new Models.Business.UserAccountData(); if (userAccounts != null) { obj = new Models.Business.UserAccountData { UserAccountID = userAccounts.UserAccountID, RoleID = userAccounts.RoleID, RoleName = userAccounts.Role.RoleName, FullName = userAccounts.FullName, AliesName = userAccounts.AliesName, UserName = userAccounts.UserName, Password = userAccounts.Password, CreatedDate = userAccounts.CreatedDate, CreatedBy = userAccounts.CreatedBy }; } return(obj); } catch (Exception ex) { throw ex; } }
private static UserRoleData GetDataObjectFromReader(SqlDataReader dataReader) { UserRoleData data = new UserRoleData(); if (dataReader.IsDBNull(dataReader.GetOrdinal("UserRoleId"))) { data.UserRoleId = IdType.UNSET; } else { data.UserRoleId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("UserRoleId"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("UserId"))) { data.UserId = IdType.UNSET; } else { data.UserId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("UserId"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("RoleId"))) { data.RoleId = RoleEnum.UNSET; } else { data.RoleId = RoleEnum.GetInstance(dataReader.GetInt32(dataReader.GetOrdinal("RoleId"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("PermitDeny"))) { data.PermitDeny = PermitDenyEnum.UNSET; } else { data.PermitDeny = PermitDenyEnum.GetInstance(dataReader.GetInt32(dataReader.GetOrdinal("PermitDeny"))); } return(data); }
/// <summary> /// 删除单个用户角色 /// </summary> /// <param name="data"></param> /// <returns></returns> public async Task <OutputDto> DeleteUserRolesAsync(UserRoleData data) { return(await _userRoleRepository.DeleteAsync(v => v.UserId.Equals(data.UserId) && v.RoleId.Equals(data.RoleId))); }
private void SetUserAccessLevelData(User user) { //Save Location Admin if (Request.Form["UserRoleL"] == "A") { UserRoleData urd = new UserRoleData(); urd.RoleDataLegend = "A"; urd.UserRoleLegend = "L"; urd.RoleDataValue = 0; urd.RoleUserID = user.UserID; db.UserRoleDatas.Add(urd); db.SaveChanges(); } //Save Admin of Divs, Depts and Secs if (Request.Form["UserRoleD"] == "G") { UserRoleData urd = new UserRoleData(); urd.RoleDataLegend = "G"; urd.UserRoleLegend = "D"; urd.RoleDataValue = 0; urd.RoleUserID = user.UserID; db.UserRoleDatas.Add(urd); db.SaveChanges(); } if (Request.Form["UserRoleT"] == "Y") { UserRoleData urd = new UserRoleData(); urd.RoleDataLegend = "Y"; urd.UserRoleLegend = "T"; urd.RoleDataValue = 0; urd.RoleUserID = user.UserID; db.UserRoleDatas.Add(urd); db.SaveChanges(); } //Save UserLoc if (Request.Form["uLocationCount"] != "" && Request.Form["UserRoleL"] == "L") { int locationCount = Convert.ToInt32(Request.Form["uLocationCount"]); List <HR_Location> locs = new List <HR_Location>(); locs = db.HR_Location.ToList(); for (int i = 1; i <= locationCount; i++) { string uLocID = "uLocation" + i; string LocName = Request.Form[uLocID].ToString(); int locID = locs.Where(aa => aa.LocationName == LocName).FirstOrDefault().LocID; UserRoleData urd = new UserRoleData(); urd.RoleDataLegend = "L"; urd.UserRoleLegend = "L"; urd.RoleDataValue = (short)locID; urd.RoleUserID = user.UserID; db.UserRoleDatas.Add(urd); db.SaveChanges(); } } //Save User City if (Request.Form["uCityCount"] != "" && Request.Form["UserRoleL"] == "C") { int cityCount = Convert.ToInt32(Request.Form["uCityCount"]); List <HR_City> cities = new List <HR_City>(); cities = db.HR_City.ToList(); for (int i = 1; i <= cityCount; i++) { string uCityID = "uCity" + i; string CityName = Request.Form[uCityID].ToString(); int cityID = cities.Where(aa => aa.CityName == CityName).FirstOrDefault().CityID; UserRoleData urd = new UserRoleData(); urd.RoleDataLegend = "C"; urd.UserRoleLegend = "L"; urd.RoleDataValue = (short)cityID; urd.RoleUserID = user.UserID; db.UserRoleDatas.Add(urd); db.SaveChanges(); } } //Save User Region if (Request.Form["uRegionCount"] != "" && Request.Form["UserRoleL"] == "R") { int regionCount = Convert.ToInt32(Request.Form["uRegionCount"]); List <HR_City> regions = new List <HR_City>(); regions = db.HR_City.ToList(); for (int i = 1; i <= regionCount; i++) { string uRegionID = "uRegion" + i; string RegionName = Request.Form[uRegionID].ToString(); // int regionID = regions.Where(aa => aa.CityName == RegionName).FirstOrDefault().RegID; UserRoleData urd = new UserRoleData(); urd.RoleDataLegend = "R"; urd.UserRoleLegend = "L"; // urd.RoleDataValue = (short)regionID; urd.RoleUserID = user.UserID; db.UserRoleDatas.Add(urd); db.SaveChanges(); } } //Save User Section if (Request.Form["uSectionCount"] != "" && Request.Form["UserRoleD"] == "S") { int sectionCount = Convert.ToInt32(Request.Form["uSectionCount"]); List <HR_Section> sections = new List <HR_Section>(); sections = db.HR_Section.ToList(); for (int i = 1; i <= sectionCount; i++) { string uSectionID = "uSection" + i; string SectionName = Request.Form[uSectionID].ToString(); int sectionID = sections.Where(aa => aa.SectionName == SectionName).FirstOrDefault().SecID; UserRoleData urd = new UserRoleData(); urd.RoleDataLegend = "S"; urd.UserRoleLegend = "D"; urd.RoleDataValue = (short)sectionID; urd.RoleUserID = user.UserID; db.UserRoleDatas.Add(urd); db.SaveChanges(); } } //Save User Department if (Request.Form["uDepartmentCount"] != "" && Request.Form["UserRoleD"] == "D") { int departmentCount = Convert.ToInt32(Request.Form["uDepartmentCount"]); List <HR_Department> departments = new List <HR_Department>(); departments = db.HR_Department.ToList(); for (int i = 1; i <= departmentCount; i++) { string uDepartmentID = "uDepartment" + i; string DepartmentName = Request.Form[uDepartmentID].ToString(); int DepartmentID = departments.Where(aa => aa.DepartmentName == DepartmentName).FirstOrDefault().DeptID; UserRoleData urd = new UserRoleData(); urd.RoleDataLegend = "D"; urd.UserRoleLegend = "D"; urd.RoleDataValue = (short)DepartmentID; urd.RoleUserID = user.UserID; db.UserRoleDatas.Add(urd); db.SaveChanges(); } } //Save User Division //if (Request.Form["uDivisionCount"] != "" && Request.Form["UserRoleD"] == "V") //{ // int divisionCount = Convert.ToInt32(Request.Form["uDivisionCount"]); // List<HR_Division> divisions = new List<HR_Division>(); // divisions = db.HR_Division.ToList(); // for (int i = 1; i <= divisionCount; i++) // { // // string uDivisionID = "uDivision" + i; // //string DivisionName = Request.Form[uDivisionID].ToString(); // //int divisionID = divisions.Where(aa => aa.DivisionName == DivisionName).FirstOrDefault().DivID; // UserRoleData urd = new UserRoleData(); // urd.RoleDataLegend = "V"; // urd.UserRoleLegend = "D"; // urd.RoleDataValue = (short)divisionID; // urd.RoleUserID = user.UserID; // db.UserRoleDatas.Add(urd); // db.SaveChanges(); // } //} //Save User Types if (Request.Form["uETypeCount"] != "" && Request.Form["UserRoleT"] == "T") { int eTypeCount = Convert.ToInt32(Request.Form["uETypeCount"]); List <HR_EmpType> etypes = new List <HR_EmpType>(); etypes = db.HR_EmpType.ToList(); for (int i = 1; i <= eTypeCount; i++) { string uEtypeID = "uEType" + i; string TypeName = Request.Form[uEtypeID].ToString(); int typeID = etypes.Where(aa => aa.TypeName == TypeName).FirstOrDefault().TypID; UserRoleData urd = new UserRoleData(); urd.RoleDataLegend = "T"; urd.UserRoleLegend = "T"; urd.RoleDataValue = (short)typeID; urd.RoleUserID = user.UserID; db.UserRoleDatas.Add(urd); db.SaveChanges(); } } }
public List <SqlParameter> MapParamsForDelete(UserRoleData entity) { return(MapParamsForUpsert(entity)); }
private void BindUserRoleRightsData() { try { DataTable dt = new DataTable(); dt = DBAccess.getUserRoleRightsDetails(ddlCompany_ForUserRoleRights.SelectedValue == null?"":ddlCompany_ForUserRoleRights.SelectedValue.ToString(), ddlRole_ForUserRoleRights.SelectedValue == null?"":ddlRole_ForUserRoleRights.SelectedValue.ToString()); List <UserRoleData> list = new List <UserRoleData>(); UserRoleData data = new UserRoleData(); if (dt.Columns.Count > 3) { data = new UserRoleData(); data.CompanyID = "Company ID"; data.Module = "Module"; data.Screen = "Screen"; List <UserRoleRightsData> listRights = new List <UserRoleRightsData>(); UserRoleRightsData rights = null; for (int col = 3; col < dt.Columns.Count; col++) { rights = new UserRoleRightsData(); rights.RoleID = dt.Columns[col].ColumnName; rights.HeaderTemplateVisibility = "block"; rights.DataTemplateVisibility = "none"; int readCount = dt.AsEnumerable().Where(k => k.Field <string>(rights.RoleID) == "Read").Count(); int modifyCount = dt.AsEnumerable().Where(k => k.Field <string>(rights.RoleID) == "Modify").Count(); int noneCount = dt.AsEnumerable().Where(k => k.Field <string>(rights.RoleID) == "None").Count(); int tableCount = dt.Rows.Count; rights.IsModifyChcked = false; rights.IsReadChecked = false; rights.IsNoneChacked = false; if (readCount == tableCount) { rights.IsReadChecked = true; } else if (modifyCount == tableCount) { rights.IsModifyChcked = true; } else if (noneCount == tableCount) { rights.IsNoneChacked = true; } listRights.Add(rights); } data.UserRightValue = listRights; list.Add(data); } for (int row = 0; row < dt.Rows.Count; row++) { data = new UserRoleData(); data.CompanyID = dt.Rows[row]["CompanyID"].ToString(); data.Module = dt.Rows[row]["Module"].ToString(); data.Screen = dt.Rows[row]["Screen"].ToString(); List <UserRoleRightsData> listRights = new List <UserRoleRightsData>(); UserRoleRightsData rights = null; for (int col = 3; col < dt.Columns.Count; col++) { rights = new UserRoleRightsData(); rights.RoleID = dt.Columns[col].ColumnName; rights.HeaderTemplateVisibility = "none"; rights.DataTemplateVisibility = "block"; if (dt.Rows[row][col].ToString() == "Read") { rights.IsModifyChcked = false; rights.IsReadChecked = true; rights.IsNoneChacked = false; } else if (dt.Rows[row][col].ToString() == "Modify") { rights.IsModifyChcked = true; rights.IsReadChecked = false; rights.IsNoneChacked = false; } else { rights.IsModifyChcked = false; rights.IsReadChecked = false; rights.IsNoneChacked = true; } listRights.Add(rights); } data.UserRightValue = listRights; list.Add(data); } lvUserRoleRightsDetails.DataSource = list; lvUserRoleRightsDetails.DataBind(); } catch (Exception ex) { } }
// GET: KPIs/Details/5 public ActionResult UserDocs(int target, int report, int?quarter, int year) { Target _target = db.Targets.Find(target); List <KPI> _kpiList = new List <KPI>(); int role = UserRoleData.GetByUserId(Authentication.CurrentUser.UserId).RoleId; if (role == 1 || role == 2) // Admin { if (report == 1) { if (quarter != 0) { ViewBag.Year = year; ViewBag.Quarter = quarter; _kpiList = db.KPIs.Where(x => x.Year == year && x.Quarter == quarter).ToList(); return(View("~/Views/Reports/User/ProductionQuarterly.cshtml", _kpiList)); } else { double[] production = new double[4]; int[] hectar = new int[4]; int[] income = new int[4]; int counter = 0; _kpiList = db.KPIs.Where(x => x.Year == year).ToList(); int[] q = { 1, 2, 3, 4 }; double tempProduction = 0; string tempRegion; string tempCode; int temphectar = 0; int tempincome = 0; ViewBag.Year = year; List <ProductionQuarterly> PQ = new List <ProductionQuarterly>(); var AvailableRegionId = _kpiList.GroupBy(i => i.RegionId).OrderByDescending(g => g.Count()).Take(20).Select(g => g.Key); foreach (var item in AvailableRegionId) { tempProduction = 0; tempRegion = ""; tempCode = ""; temphectar = 0; tempincome = 0; List <KPI> kpiQuarter = _kpiList.Where(x => x.RegionId == item).ToList(); foreach (var kpiItem in kpiQuarter) { tempRegion = RegionData.returnName(kpiItem.RegionId); tempCode = RegionData.Fetch(kpiItem.RegionId).Code; temphectar = temphectar + kpiItem.Hectar; tempProduction = tempProduction + (kpiItem.Male + kpiItem.Production); tempincome = tempincome + kpiItem.IncomeGenerated; } counter++; ProductionQuarterly newPQ = new ProductionQuarterly(); newPQ.id = counter; newPQ.Region = tempRegion.ToString(); newPQ.Code = tempCode.ToString(); newPQ.Production = tempProduction * .001; newPQ.AreaPlanted = temphectar; newPQ.income = tempincome; PQ.Add(newPQ); } return(View("~/Views/Reports/User/Production.cshtml", PQ)); } } else if (report == 2) { if (quarter != 0) { ViewBag.Year = year; ViewBag.Quarter = quarter; ViewBag.Region = db.Regions.ToList(); _kpiList = db.KPIs.Where(x => x.Year == year && x.Quarter == quarter).ToList(); return(View("~/Views/Reports/User/PerformanceQuarterly.cshtml", _kpiList)); } else { ViewBag.Year = year; List <Region> region = db.Regions.ToList(); ViewBag.Region = region; _kpiList = db.KPIs.Where(x => x.Year == year).ToList(); int counter = 0; List <KPI> NEW_kpiList = new List <KPI>(); foreach (var regionItem in region) { KPI newKPI = new KPI(); List <KPI> NEW_Quarter_kpiList = _kpiList.Where(x => x.RegionId == regionItem.RegionId).ToList(); foreach (var newQuarterItem in NEW_Quarter_kpiList) { KPI TempKpi = db.KPIs.Find(newQuarterItem.KPIId); newKPI.KPIId = counter; newKPI.UniqueId = Guid.NewGuid(); newKPI.Name = null; newKPI.Category = 0; newKPI.Description = null; newKPI.RegionId = regionItem.RegionId; newKPI.Quarter = 0; newKPI.Year = year; newKPI.DateAndTime = DateTime.Now; newKPI.UserId = 0; newKPI.Hectar += TempKpi.Hectar; newKPI.NoOfFarms += TempKpi.NoOfFarms; newKPI.NoOfTrees += TempKpi.NoOfTrees; newKPI.Production += TempKpi.Production; newKPI.Variety = TempKpi.Variety; newKPI.VolumeMarket += TempKpi.VolumeMarket; newKPI.VolumeInternational += TempKpi.VolumeInternational; newKPI.VolumeSoldMarket += TempKpi.VolumeSoldMarket; newKPI.VolumeSoldInternational += TempKpi.VolumeSoldInternational; newKPI.Male += TempKpi.Male; newKPI.Female += TempKpi.Female; newKPI.MunicipalitiesEngaged += TempKpi.MunicipalitiesEngaged; newKPI.NumberOfNurseries += TempKpi.NumberOfNurseries; newKPI.NoOfPostharvest += TempKpi.NoOfPostharvest; newKPI.IncomeGenerated += TempKpi.IncomeGenerated; newKPI.SMEs += TempKpi.SMEs; newKPI.JobsCreated += TempKpi.JobsCreated; newKPI.NoOfFundingAssistance += TempKpi.NoOfFundingAssistance; newKPI.NoOfFundingInstitutions += TempKpi.NoOfFundingInstitutions; newKPI.NoOfPoliciReforms += TempKpi.NoOfPoliciReforms; newKPI.DA += TempKpi.DA; newKPI.DENR_NGP += TempKpi.DENR_NGP; newKPI.PCA_Kaanib += TempKpi.PCA_Kaanib; newKPI.DAR += TempKpi.DAR; newKPI.Trainings += TempKpi.Trainings; newKPI.FarmesrsTrained += TempKpi.FarmesrsTrained; newKPI.IECMaterials += TempKpi.IECMaterials; newKPI.LinkagesLocal += TempKpi.LinkagesLocal; newKPI.LinkagesInternational += TempKpi.LinkagesInternational; newKPI.DiseasesManagement += TempKpi.DiseasesManagement; newKPI.GoodAgriculturalPractices += TempKpi.GoodAgriculturalPractices; newKPI.CacaoFarmsCertified += TempKpi.CacaoFarmsCertified; newKPI.NurseriesAccredited += TempKpi.NurseriesAccredited; newKPI.ModelFarms += TempKpi.ModelFarms; newKPI.ResearchWorkDeveloped += TempKpi.ResearchWorkDeveloped; } counter++; NEW_kpiList.Add(newKPI); } return(View("~/Views/Reports/User/Performance.cshtml", NEW_kpiList)); } } else if (report == 3) { int[] years = getTargetYearInt(target); ViewBag.Year = year; List <Region> region = db.Regions.ToList(); ViewBag.Region = region; _kpiList = db.KPIs.ToList(); int counter = 0; List <KPI> NEW_kpiList = new List <KPI>(); foreach (int item in years) { KPI newKPI = new KPI(); List <KPI> NEW_Quarter_kpiList = _kpiList.Where(x => x.Year == item).ToList(); foreach (var newQuarterItem in NEW_Quarter_kpiList) { KPI TempKpi = db.KPIs.Find(newQuarterItem.KPIId); newKPI.KPIId = counter; newKPI.UniqueId = Guid.NewGuid(); newKPI.Name = null; newKPI.Category = 0; newKPI.Description = null; newKPI.RegionId = 0; newKPI.Quarter = 0; newKPI.Year = item; newKPI.DateAndTime = DateTime.Now; newKPI.UserId = 0; newKPI.Hectar += TempKpi.Hectar; newKPI.NoOfFarms += TempKpi.NoOfFarms; newKPI.NoOfTrees += TempKpi.NoOfTrees; newKPI.Production += TempKpi.Production; newKPI.Variety = TempKpi.Variety; newKPI.VolumeMarket += TempKpi.VolumeMarket; newKPI.VolumeInternational += TempKpi.VolumeInternational; newKPI.VolumeSoldMarket += TempKpi.VolumeSoldMarket; newKPI.VolumeSoldInternational += TempKpi.VolumeSoldInternational; newKPI.Male += TempKpi.Male; newKPI.Female += TempKpi.Female; newKPI.MunicipalitiesEngaged += TempKpi.MunicipalitiesEngaged; newKPI.NumberOfNurseries += TempKpi.NumberOfNurseries; newKPI.NoOfPostharvest += TempKpi.NoOfPostharvest; newKPI.IncomeGenerated += TempKpi.IncomeGenerated; newKPI.SMEs += TempKpi.SMEs; newKPI.JobsCreated += TempKpi.JobsCreated; newKPI.NoOfFundingAssistance += TempKpi.NoOfFundingAssistance; newKPI.NoOfFundingInstitutions += TempKpi.NoOfFundingInstitutions; newKPI.NoOfPoliciReforms += TempKpi.NoOfPoliciReforms; newKPI.DA += TempKpi.DA; newKPI.DENR_NGP += TempKpi.DENR_NGP; newKPI.PCA_Kaanib += TempKpi.PCA_Kaanib; newKPI.DAR += TempKpi.DAR; newKPI.Trainings += TempKpi.Trainings; newKPI.FarmesrsTrained += TempKpi.FarmesrsTrained; newKPI.IECMaterials += TempKpi.IECMaterials; newKPI.LinkagesLocal += TempKpi.LinkagesLocal; newKPI.LinkagesInternational += TempKpi.LinkagesInternational; newKPI.DiseasesManagement += TempKpi.DiseasesManagement; newKPI.GoodAgriculturalPractices += TempKpi.GoodAgriculturalPractices; newKPI.CacaoFarmsCertified += TempKpi.CacaoFarmsCertified; newKPI.NurseriesAccredited += TempKpi.NurseriesAccredited; newKPI.ModelFarms += TempKpi.ModelFarms; newKPI.ResearchWorkDeveloped += TempKpi.ResearchWorkDeveloped; } counter++; NEW_kpiList.Add(newKPI); } ViewBag.Year = _target.YearStart + " - " + _target.YearEnd; ViewBag.Year_array = years; return(View("~/Views/Reports/User/National.cshtml", NEW_kpiList)); } } else if (role == 3) // user { int regionId = UserData.Fetch(Authentication.CurrentUser.UserId).Region; ViewBag.RegionCode = regionId; if (report == 4) // Accomplish { if (quarter != 0) { ViewBag.Year = year; ViewBag.Quarter = quarter; _kpiList = db.KPIs.Where(x => x.Year == year && x.Quarter == quarter && x.RegionId == regionId).ToList(); return(View("~/Views/Reports/Admin/AccomplishmentQuarterly.cshtml", _kpiList)); } else { ViewBag.Year = year; _kpiList = db.KPIs.Where(x => x.Year == year).ToList(); int counter = 0; List <KPI> NEW_kpiList = new List <KPI>(); KPI newKPI = new KPI(); List <KPI> NEW_Quarter_kpiList = _kpiList.Where(x => x.RegionId == regionId).ToList(); foreach (var newQuarterItem in NEW_Quarter_kpiList) { KPI TempKpi = db.KPIs.Find(newQuarterItem.KPIId); newKPI.KPIId = counter; newKPI.UniqueId = Guid.NewGuid(); newKPI.Name = null; newKPI.Category = 0; newKPI.Description = null; newKPI.RegionId = regionId; newKPI.Quarter = 0; newKPI.Year = year; newKPI.DateAndTime = DateTime.Now; newKPI.UserId = 0; newKPI.Hectar += TempKpi.Hectar; newKPI.NoOfFarms += TempKpi.NoOfFarms; newKPI.NoOfTrees += TempKpi.NoOfTrees; newKPI.Production += TempKpi.Production; newKPI.Variety = TempKpi.Variety; newKPI.VolumeMarket += TempKpi.VolumeMarket; newKPI.VolumeInternational += TempKpi.VolumeInternational; newKPI.VolumeSoldMarket += TempKpi.VolumeSoldMarket; newKPI.VolumeSoldInternational += TempKpi.VolumeSoldInternational; newKPI.Male += TempKpi.Male; newKPI.Female += TempKpi.Female; newKPI.MunicipalitiesEngaged += TempKpi.MunicipalitiesEngaged; newKPI.NumberOfNurseries += TempKpi.NumberOfNurseries; newKPI.NoOfPostharvest += TempKpi.NoOfPostharvest; newKPI.IncomeGenerated += TempKpi.IncomeGenerated; newKPI.SMEs += TempKpi.SMEs; newKPI.JobsCreated += TempKpi.JobsCreated; newKPI.NoOfFundingAssistance += TempKpi.NoOfFundingAssistance; newKPI.NoOfFundingInstitutions += TempKpi.NoOfFundingInstitutions; newKPI.NoOfPoliciReforms += TempKpi.NoOfPoliciReforms; newKPI.DA += TempKpi.DA; newKPI.DENR_NGP += TempKpi.DENR_NGP; newKPI.PCA_Kaanib += TempKpi.PCA_Kaanib; newKPI.DAR += TempKpi.DAR; newKPI.Trainings += TempKpi.Trainings; newKPI.FarmesrsTrained += TempKpi.FarmesrsTrained; newKPI.IECMaterials += TempKpi.IECMaterials; newKPI.LinkagesLocal += TempKpi.LinkagesLocal; newKPI.LinkagesInternational += TempKpi.LinkagesInternational; newKPI.DiseasesManagement += TempKpi.DiseasesManagement; newKPI.GoodAgriculturalPractices += TempKpi.GoodAgriculturalPractices; newKPI.CacaoFarmsCertified += TempKpi.CacaoFarmsCertified; newKPI.NurseriesAccredited += TempKpi.NurseriesAccredited; newKPI.ModelFarms += TempKpi.ModelFarms; newKPI.ResearchWorkDeveloped += TempKpi.ResearchWorkDeveloped; } counter++; NEW_kpiList.Add(newKPI); return(View("~/Views/Reports/Admin/Accomplishment.cshtml", NEW_kpiList)); } } if (report == 5) // Accomplishment summary { ViewBag.Year = year; int[] q = { 1, 2, 3, 4, 5 }; _kpiList = db.KPIs.Where(x => x.Year == year).ToList(); int counter = 0; List <KPI> NEW_kpiList = new List <KPI>(); KPI newKPI = new KPI(); List <KPI> NEW_Quarter_kpiList = _kpiList.Where(x => x.RegionId == regionId).ToList(); foreach (var newQuarterItem in NEW_Quarter_kpiList) { counter++; KPI TempKpi = db.KPIs.Find(newQuarterItem.KPIId); NEW_kpiList.Add(TempKpi); } foreach (var newQuarterItem in NEW_Quarter_kpiList) { counter++; KPI TempKpi = db.KPIs.Find(newQuarterItem.KPIId); newKPI.KPIId = counter; newKPI.UniqueId = Guid.NewGuid(); newKPI.Name = null; newKPI.Category = 0; newKPI.Description = null; newKPI.RegionId = regionId; newKPI.Quarter = counter; newKPI.Year = year; newKPI.DateAndTime = DateTime.Now; newKPI.UserId = 0; if (newQuarterItem.Quarter == 4) { newKPI.Hectar = TempKpi.Hectar; } else { newKPI.Hectar = 0; } if (newQuarterItem.Quarter == 4) { newKPI.NoOfFarms = TempKpi.NoOfFarms; } else { newKPI.NoOfFarms = 0; } if (newQuarterItem.Quarter == 4) { newKPI.NoOfTrees = TempKpi.NoOfTrees; } else { newKPI.NoOfTrees = 0; } newKPI.Production += TempKpi.Production; newKPI.Variety = TempKpi.Variety; newKPI.VolumeMarket += TempKpi.VolumeMarket; newKPI.VolumeInternational += TempKpi.VolumeInternational; newKPI.VolumeSoldMarket += TempKpi.VolumeSoldMarket; newKPI.VolumeSoldInternational += TempKpi.VolumeSoldInternational; newKPI.Male += TempKpi.Male; if (newQuarterItem.Quarter == 4) { newKPI.Male = newKPI.Male / 4; } newKPI.Female += TempKpi.Female; if (newQuarterItem.Quarter == 4) { newKPI.Female = newKPI.Female / 4; } newKPI.MunicipalitiesEngaged += TempKpi.MunicipalitiesEngaged; if (newQuarterItem.Quarter == 4) { newKPI.MunicipalitiesEngaged = newKPI.MunicipalitiesEngaged / 4; } if (newQuarterItem.Quarter == 4) { newKPI.NumberOfNurseries = TempKpi.NumberOfNurseries; } else { newKPI.NumberOfNurseries = 0; } if (newQuarterItem.Quarter == 4) { newKPI.NoOfPostharvest = TempKpi.NoOfPostharvest; } else { newKPI.NoOfPostharvest = 0; } newKPI.NoOfPostharvest += TempKpi.NoOfPostharvest; newKPI.IncomeGenerated += TempKpi.IncomeGenerated; newKPI.SMEs += TempKpi.SMEs; newKPI.JobsCreated += TempKpi.JobsCreated; newKPI.NoOfFundingAssistance += TempKpi.NoOfFundingAssistance; newKPI.NoOfFundingInstitutions += TempKpi.NoOfFundingInstitutions; newKPI.NoOfPoliciReforms += TempKpi.NoOfPoliciReforms; newKPI.DA += TempKpi.DA; newKPI.DENR_NGP += TempKpi.DENR_NGP; newKPI.PCA_Kaanib += TempKpi.PCA_Kaanib; newKPI.DAR += TempKpi.DAR; newKPI.Trainings += TempKpi.Trainings; newKPI.FarmesrsTrained += TempKpi.FarmesrsTrained; newKPI.IECMaterials += TempKpi.IECMaterials; newKPI.LinkagesLocal += TempKpi.LinkagesLocal; newKPI.LinkagesInternational += TempKpi.LinkagesInternational; newKPI.DiseasesManagement += TempKpi.DiseasesManagement; if (newQuarterItem.Quarter == 4) { newKPI.DiseasesManagement = newKPI.DiseasesManagement / 4; } newKPI.GoodAgriculturalPractices += TempKpi.GoodAgriculturalPractices; if (newQuarterItem.Quarter == 4) { newKPI.GoodAgriculturalPractices = newKPI.GoodAgriculturalPractices / 4; } newKPI.CacaoFarmsCertified += TempKpi.CacaoFarmsCertified; newKPI.NurseriesAccredited += TempKpi.NurseriesAccredited; newKPI.ModelFarms += TempKpi.ModelFarms; newKPI.ResearchWorkDeveloped += TempKpi.ResearchWorkDeveloped; } NEW_kpiList.Add(newKPI); ViewBag.Quarter_array = q; return(View("~/Views/Reports/Admin/AccomplishmentReportSummary.cshtml", NEW_kpiList)); } if (report == 6) // Regional Accomplishment Report { int[] years = getTargetYearInt(target); ViewBag.Year = year; _kpiList = db.KPIs.ToList(); int counter = 0; List <KPI> NEW_kpiList = new List <KPI>(); foreach (int item in years) { KPI newKPI = new KPI(); List <KPI> NEW_Quarter_kpiList = _kpiList.Where(x => x.Year == item && x.RegionId == regionId).ToList(); foreach (var newQuarterItem in NEW_Quarter_kpiList) { KPI TempKpi = db.KPIs.Find(newQuarterItem.KPIId); newKPI.KPIId = counter; newKPI.UniqueId = Guid.NewGuid(); newKPI.Name = null; newKPI.Category = 0; newKPI.Description = null; newKPI.RegionId = 0; newKPI.Quarter = 0; newKPI.Year = item; newKPI.DateAndTime = DateTime.Now; newKPI.UserId = 0; newKPI.Hectar += TempKpi.Hectar; newKPI.NoOfFarms += TempKpi.NoOfFarms; newKPI.NoOfTrees += TempKpi.NoOfTrees; newKPI.Production += TempKpi.Production; newKPI.Variety = TempKpi.Variety; newKPI.VolumeMarket += TempKpi.VolumeMarket; newKPI.VolumeInternational += TempKpi.VolumeInternational; newKPI.VolumeSoldMarket += TempKpi.VolumeSoldMarket; newKPI.VolumeSoldInternational += TempKpi.VolumeSoldInternational; newKPI.Male += TempKpi.Male; newKPI.Female += TempKpi.Female; newKPI.MunicipalitiesEngaged += TempKpi.MunicipalitiesEngaged; newKPI.NumberOfNurseries += TempKpi.NumberOfNurseries; newKPI.NoOfPostharvest += TempKpi.NoOfPostharvest; newKPI.IncomeGenerated += TempKpi.IncomeGenerated; newKPI.SMEs += TempKpi.SMEs; newKPI.JobsCreated += TempKpi.JobsCreated; newKPI.NoOfFundingAssistance += TempKpi.NoOfFundingAssistance; newKPI.NoOfFundingInstitutions += TempKpi.NoOfFundingInstitutions; newKPI.NoOfPoliciReforms += TempKpi.NoOfPoliciReforms; newKPI.DA += TempKpi.DA; newKPI.DENR_NGP += TempKpi.DENR_NGP; newKPI.PCA_Kaanib += TempKpi.PCA_Kaanib; newKPI.DAR += TempKpi.DAR; newKPI.Trainings += TempKpi.Trainings; newKPI.FarmesrsTrained += TempKpi.FarmesrsTrained; newKPI.IECMaterials += TempKpi.IECMaterials; newKPI.LinkagesLocal += TempKpi.LinkagesLocal; newKPI.LinkagesInternational += TempKpi.LinkagesInternational; newKPI.DiseasesManagement += TempKpi.DiseasesManagement; newKPI.GoodAgriculturalPractices += TempKpi.GoodAgriculturalPractices; newKPI.CacaoFarmsCertified += TempKpi.CacaoFarmsCertified; newKPI.NurseriesAccredited += TempKpi.NurseriesAccredited; newKPI.ModelFarms += TempKpi.ModelFarms; newKPI.ResearchWorkDeveloped += TempKpi.ResearchWorkDeveloped; } counter++; NEW_kpiList.Add(newKPI); } ViewBag.Year = _target.YearStart + " - " + _target.YearEnd; ViewBag.Year_array = years; return(View("~/Views/Reports/Admin/NationalAccomplishmentReport.cshtml", NEW_kpiList)); } } return(View("Index", db.Targets.ToList())); }
/// <summary> /// The load user data. /// </summary> /// <param name="user"> /// The user. /// </param> /// <returns> /// The StruSoft.Impact.V120.ProjectManager.Core.ProjectBrowserData.UserData. /// </returns> public UserData LoadUserData( string user ) { user = user.ToLower(); ImpactQuery query = new ImpactQuery( true ) { From = { ImpUser.As( "U" ) }, Select = { ImpUserGroup.Company, ImpUserGroupStd.RoleId }, Join = { Join.Inner( ImpUserGroup.As( "UG" ), ImpUser.Userid.Equal( ImpUserGroup.Userid ) ), Join.Inner( ImpUserGroupStd.As( "UGS" ), ImpUserGroup.UserGroup.Equal( ImpUserGroupStd.Name ) ), }, Where = { ImpUser.Userid.Equal( user ) }, }; string statement = query.ToString(); UserData userData = new UserData { UserId = user }; using( var database = new ImpactDatabase() ) { var groupedCompanyRoleList = database.GetAll( statement, column => new { Company = column[0].Cast<string>(), Role = column[1].Cast<UserRole>(), } ).GroupBy( x => x.Company ).ToList(); foreach( var companyGroup in groupedCompanyRoleList ) { UserRoleData urd = new UserRoleData( companyGroup.Key, from item in companyGroup select item.Role ); userData.UserRoles.Add( urd ); } } return userData; }
private void BindUserRightsExceptionData() { try { string selectedUserIdList = ""; for (int i = 0; i < gvUserIDList.Rows.Count; i++) { if ((gvUserIDList.Rows[i].FindControl("chkUserIDChecked") as CheckBox).Checked) { if (selectedUserIdList == "") { selectedUserIdList += "'" + (gvUserIDList.Rows[i].FindControl("lblUserID") as Label).Text + "'"; } else { selectedUserIdList += ",'" + (gvUserIDList.Rows[i].FindControl("lblUserID") as Label).Text + "'"; } } } List <UserRoleData> list = new List <UserRoleData>(); if (selectedUserIdList != "") { DataTable userRightsDt = DBAccess.getUserRightsExceptionDetails(ddlUserRightExptnCompany.SelectedValue, ddlUserRightExptnRole.SelectedValue, selectedUserIdList); UserRoleData data = new UserRoleData(); bool firstRowEntered = true; // For first list item insert header related vaulues for (int i = 0; i < userRightsDt.Rows.Count; i++) { data = new UserRoleData(); if (firstRowEntered) { data.CompanyID = "Company"; data.Module = "Module"; data.Screen = "Screen"; } else { data.CompanyID = userRightsDt.Rows[i]["CompanyID"].ToString(); data.Module = userRightsDt.Rows[i]["Module"].ToString(); data.Screen = userRightsDt.Rows[i]["Screen"].ToString(); } List <UserRoleRightsData> listRights = new List <UserRoleRightsData>(); UserRoleRightsData rights = null; for (int col = 3; col < userRightsDt.Columns.Count; col++) { rights = new UserRoleRightsData(); if (firstRowEntered) { rights.HeaderTemplateVisibility = "block"; rights.DataTemplateVisibility = "none"; } else { rights.HeaderTemplateVisibility = "none"; rights.DataTemplateVisibility = "block"; } rights.UserID = userRightsDt.Columns[col].ColumnName; if (firstRowEntered) { int readCount = userRightsDt.AsEnumerable().Where(k => k.Field <string>(rights.UserID) == "Read").Count(); int modifyCount = userRightsDt.AsEnumerable().Where(k => k.Field <string>(rights.UserID) == "Modify").Count(); int noneCount = userRightsDt.AsEnumerable().Where(k => k.Field <string>(rights.UserID) == "None").Count(); int tableCount = userRightsDt.Rows.Count; rights.IsModifyChcked = false; rights.IsReadChecked = false; rights.IsNoneChacked = false; if (readCount == tableCount) { rights.IsReadChecked = true; } else if (modifyCount == tableCount) { rights.IsModifyChcked = true; } else if (noneCount == tableCount) { rights.IsNoneChacked = true; } } else { if (string.Equals(userRightsDt.Rows[i][col].ToString(), "Read", StringComparison.OrdinalIgnoreCase)) { rights.IsModifyChcked = false; rights.IsReadChecked = true; rights.IsNoneChacked = false; } else if (string.Equals(userRightsDt.Rows[i][col].ToString(), "Modify", StringComparison.OrdinalIgnoreCase)) { rights.IsModifyChcked = true; rights.IsReadChecked = false; rights.IsNoneChacked = false; } else if (string.Equals(userRightsDt.Rows[i][col].ToString(), "None", StringComparison.OrdinalIgnoreCase)) { rights.IsModifyChcked = false; rights.IsReadChecked = false; rights.IsNoneChacked = true; } else { rights.IsModifyChcked = false; rights.IsReadChecked = false; rights.IsNoneChacked = false; } } listRights.Add(rights); } data.UserRightValue = listRights; list.Add(data); if (firstRowEntered) { i = -1; firstRowEntered = false; } } } lvUserAssignedToRole.DataSource = list; lvUserAssignedToRole.DataBind(); } catch (Exception ex) { } }