BenefitsAllocationUpload.Controllers.ReimbursableBenefitsAccountController.GetOrgIdForCurrentUser C# (CSharp) Метод

        protected string GetOrgIdForCurrentUser()
        {
            var retval = string.Empty;

            using (var db = new FISDataMartEntities())
            {
                var user = Models.User.FindByLoginId(System.Web.HttpContext.Current.User.Identity.Name);
                var unit = user.Units.FirstOrDefault();
                var schoolCodeParameter = new SqlParameter("schoolCode", unit.SchoolCode);

                retval = db.Database.SqlQuery<string>(
                    "SELECT dbo.udf_GetOrgIdForSchoolCode(@schoolCode)", schoolCodeParameter).FirstOrDefault();
            }
            return retval;
        }