//internal void InsertChangesHistory(string name, string objectId, string json, Guid? userId, byte changeType, long tstamp) //{ // Task.Run(() => // { // using (var context = Context) // { // context.Backend_InsertChangesHistory(name, objectId, json, userId, changeType, tstamp); // } // }); //} public static async Task InsertHttpRequest(HttpRequestInfo httpRequest) { await Task.Run(() => { using (var context = new PortalDataContext(ApplicationSettingManager.SQLConnectionString)) { context.InsertHttpRequest(sessionId: httpRequest.SessionId, userHostAddress: httpRequest.UserHostAddress, userId: httpRequest.UserId, device: httpRequest.Device, urlReferrer: httpRequest.UrlReferrer, requestUrl: httpRequest.RequestUrl, machineId: httpRequest.MachineId, cookies: httpRequest.Cookies, queryString: httpRequest.Querystring, isNewSeession: httpRequest.isNewSession); } }); }
public static ResourceEntry GetResource(string name, string culture) { ResourceEntry resources = null; string cultureOut = null; string valueOut = null; string nameOut = null; using (var context = new PortalDataContext("Server=tcp:gomoblinportaldb.database.windows.net,1433;Initial Catalog=GoMoblinPortal;Persist Security Info=False;User ID=MoblinSA;Password=Moblin1@#;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;")) { context.WebSite_GetResource_Value(culture: culture, name: name, nameOut: ref nameOut, cultureOut: ref cultureOut, valueOut: ref valueOut); } resources = new ResourceEntry { Culture = cultureOut, Name = nameOut, Value = valueOut }; return(resources); }
public static IList <ResourceEntry> GetResources() { List <WebSite_GetResources_ValueResult> resources = null; IList <ResourceEntry> list = new List <ResourceEntry>(); using (var context = new PortalDataContext("Server=tcp:gomoblinportaldb.database.windows.net,1433;Initial Catalog=GoMoblinPortal;Persist Security Info=False;User ID=MoblinSA;Password=Moblin1@#;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;")) { resources = context.WebSite_GetResources_Value().ToList(); } foreach (var resource in resources) { list.Add(new ResourceEntry { Culture = resource.Culture, Name = resource.Name, Value = resource.Value }); } return(list); }
public static WebsiteSetting GetApplicationSetting() { //var connectionString = ConfigurationManager.ConnectionStrings["SettingsConnectionString"]; //if (connectionString==null) //{ // connectionString.ConnectionString = // ; //} using (var context = new PortalDataContext("Server=tcp:gomoblinportaldb.database.windows.net,1433;Initial Catalog=GoMoblinPortal;Persist Security Info=False;User ID=MoblinSA;Password=Moblin1@#;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;")) { Backend_Settings_GetResult settings = context.Backend_Settings_Get().FirstOrDefault(); WebsiteSetting setting; if (settings == null) { setting = GetApplicationSettingFromFile(); } else { setting = JsonConvert.DeserializeObject <WebsiteSetting>(settings.Json); } return(setting); } }