public ActionResult ViewDetails(string staffid) { if (HttpContext.Session["AID"] == null) { return(RedirectToAction("AdminLogin", "Portal", null)); } if (staffid == null) { return(new HttpStatusCodeResult(400)); } mStaff s = new mStaff(); try { int id = int.Parse(staffid); using (Models.MerchantService db = new Models.MerchantService()) { v_Staff staff = db.v_Staff.Where(x => x.StaffID == id).SingleOrDefault(); s.StaffID = staff.StaffID; s.StaffName = staff.StaffName; s.Department = staff.Department; s.Office = staff.Office; } } catch (Exception ex) { TempData["StatusMessage"] = ex.Message; } return(View(s)); }
public v_Staff GetStaffData() { //List<int> schoolTypes = GetSchoolTypesList(this.STYP); ////create a bunch of Generics Lists, automatically populated with a 9 (the default value). //List<int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes; //base.GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes, // out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes); Years = base.GetYearList(); //Special logic for which fullkeys to use. _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL); bool useFullkeys = true; // _clauseForCompareToSchoolsDistrict = GetClauseForCompareToSchoolsDistrict( OrigFullKey, S4orALL, CompareTo, OrgLevel, SCounty, SAthleticConf, SCESA, SRegion, out useFullkeys); DALStaff staff = new DALStaff(); v_Staff ds = new v_Staff(); List <string> orderBy = GetOrderByList(ds._v_Staff, CompareTo, OrigFullKey); //List<string> orderBy = new List<string>(); //orderBy.Add("PRIORYEAR"); if (CompareTo.Key == CompareToKeys.SelSchools || CompareTo.Key == CompareToKeys.SelDistricts) { orderBy.Add(ds._v_Staff.LinkedDistrictNameColumn.ColumnName); } orderBy.Add("Category"); ds = staff.GetStaffData( Years, _fullKeys, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy); this.sql = staff.SQL; return(ds); }