public static string GetFriendlyName(DojoDbContext _context) { string userName = "******"; try { userName = ClaimsPrincipal.Current.Identity.Name; SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@UserName", SqlDbType.VarChar); sqlParams[0].Value = userName; userName = _context.Database.SqlQuery <string>("GetUserName @UserName", sqlParams).FirstOrDefault(); if (string.IsNullOrEmpty(userName)) { userName = "******"; } } catch { } return(userName); }
//private readonly DojoDbContext _context; public static string GetFavoriteIcon(DojoDbContext _context, string url) { string favoriteIconClass = "fa-heart-o"; try { var userName = ClaimsPrincipal.Current.Identity.Name; SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@UserName", SqlDbType.VarChar); sqlParams[0].Value = userName; string page = _context.Database.SqlQuery <string>("GetFavoritePage @UserName", sqlParams).FirstOrDefault(); if (!string.IsNullOrEmpty(page) && url.ToLower().EndsWith(page.ToLower())) { favoriteIconClass = "fa-heart"; } } catch { } return(favoriteIconClass); }
public InquiryController(DojoDbContext context) { _dbContext = context; ViewBag.PermissionClass = AuthorizationProvider.IsInquiryEditor() ? "app-grid-edit" : string.Empty; ViewBag.ApprovalClass = AuthorizationProvider.IsAppover() ? "app-grid-approve" : string.Empty; ViewBag.EditClass = AuthorizationProvider.IsInquiryEditor() ? string.Empty : " app-field-readonly"; // note: the following setting affect MVC serialization. Use Newtonsoft.Json to work around it. // if false, it will not get the associated certification and skills when we get the applicants. //_dbContext.Configuration.ProxyCreationEnabled = false; // Load navigation properties explicitly (avoid serialization trouble) //_dbContext.Configuration.LazyLoadingEnabled = false; // Because Web API will perform validation, we don't need/want EF to do so //_dbContext.Configuration.ValidateOnSaveEnabled = false; // We won't use this performance tweak because we don't need // the extra performance and, when autodetect is false, // we'd have to be careful. We're not being that careful. //_dbContext.Configuration.AutoDetectChangesEnabled = false; }
public GoogleDriveHelper(DojoDbContext dbContext) { _dbContext = dbContext; if (string.IsNullOrEmpty(AirbnbReportFolderId)) { string folderFilter = string.Format("mimeType='{0}' and name = 'Airbnb Reports'", FOLDER_MIME_TYPE); var folders = GetFileList(folderFilter); if (folders.Count > 0) { AirbnbReportFolderId = folders[0].Id; } } if (string.IsNullOrEmpty(CompletedFolderId)) { string folderFilter = string.Format("mimeType='{0}' and name = 'Airbnb Historical Data'", FOLDER_MIME_TYPE); var folders = GetFileList(folderFilter); if (folders.Count > 0) { CompletedFolderId = folders[0].Id; } } if (string.IsNullOrEmpty(FutureFolderId)) { string folderFilter = string.Format("mimeType='{0}' and name = 'Revenue Forecasts'", FOLDER_MIME_TYPE); var folders = GetFileList(folderFilter); if (folders.Count > 0) { FutureFolderId = folders[0].Id; } } DojoLogger.Info(string.Format("report folder={0}, completed folder={1}, future folder={2}", AirbnbReportFolderId, CompletedFolderId, FutureFolderId)); }
public ExportDbController(DojoDbContext context) { _dbContext = context; }
public PropertyService(DojoDbContext dbContext) { _context = dbContext; }
public OtherRevenueTableProvider(DojoDbContext dbContext) : base(dbContext) { _context = dbContext; }