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);
}
