static void Main(string[] args) { var serviceUri = new Uri("http://localhost:61317/odata"); var context = new Default.Container(serviceUri); // context.Products.ByKey(1).GetValueAsync().Wait(); var product = new Product { Id = 99, Name = "Product 99" }; context.Configurations.RequestPipeline.OnEntryStarting(args => { if (product.GetType().IsAssignableFrom(args.Entity.GetType())) { List <ODataProperty> entryProperties = args.Entry.Properties as List <ODataProperty>; entryProperties.Add(new ODataProperty { Name = "SalesDescription", Value = new ODataPrimitiveValue("Product 99 sales description") }); } }); context.AddToProducts(product); context.SaveChangesAsync(SaveChangesOptions.None).Wait(); }
static void ListAllLocations(Default.Container container) { foreach (var p in container.Locations) { Console.WriteLine("{0} {1} {2}", p.District, p.SubDistrict, p.Locality); } }
private static void DataBulkInsert(List <DataPrfOsasco> datas, Func <string, string> treatIndex) { if (!datas.Any()) { return; } var dataUriStr = "http://localhost:58994/odata/v4"; var dataUri = new Uri(dataUriStr); var container = new Default.Container(dataUri) { Timeout = int.MaxValue }; var groupsDbDictionary = container.Groups.ToDictionaryTree(g => treatIndex(g.Name), OsascoGroupId); var datas2 = datas .GroupBy(e => string.Join("/", e.Group.Key) + "/" + e.Date.ToString()) .Select(eg => new Data.Models.DataDecimal() { CollectionDate = eg.First().Date, GroupId = groupsDbDictionary[eg.First().Group.Key].Data.Id, DecimalValue = eg.Sum(e => e.Value) }) .ToList <Data.Models.Data>(); var bulkInsert = Default.ExtensionMethods.BulkInsert(container.Datas, datas2); bulkInsert.Execute(); }
internal static Default.Container Context() { string LogMsg = MethodBase.GetCurrentMethod().ReflectedType.Name + "." + MethodBase.GetCurrentMethod().ToString() + " :: "; try { var container = new Default.Container(new Uri(serviceURI)); container.Timeout = serviceTimeout; container.BuildingRequest += (sender, eventArgs) => { //attach header information required to use ApiKey var hmac = new HMAC() { TimeStamp = DateTime.UtcNow.ToString(), Uri = eventArgs.RequestUri.ToString(), Method = eventArgs.Method.ToString(), AppID = appID, ApiKey = apiKey }; hmac.SetNonce(); eventArgs.Headers.Add("HMAC", hmac.BuildHeader()); eventArgs.Headers.Add("Hash", hmac.Hash()); }; return(container); } catch (Exception ex) { NLogWriter.LogMessage(LogType.Error, LogMsg + "Exception calling Flotation Device Service Application :: " + ex.ToString()); throw; } }
/// <summary> /// On-premise context /// </summary> /// <param name="serviceUri"></param> public TimetrackerOdataContext(Uri serviceUri) { _serviceUri = serviceUri; Container = new Default.Container(serviceUri); Container.Credentials = System.Net.CredentialCache.DefaultCredentials; }
public void FilterCountriesByNames(Default.Container container, string name) { var countries = from c in container.Countries where c.CountryName == name select c; }
public void FilterCityClimateByTemp(Default.Container container, double awgTemp) { var cityClimateInfo = from c in container.ClimateInfo where c.AvgTemperature == awgTemp select c; }
public (EsasLoadResult esasLoadResult, object[] loadedObjects) Load() { _esasContainer = _esasContextFactory.Create(); EsasLoadResult loadResult = new EsasLoadResult(); loadResult.LoaderStrategyName = this.GetType().Name; loadResult.LoadStartTimeUTC = DateTime.UtcNow; DateTime deltaTimeLoadvalue = new DateTime(1963, 11, 22).ToUniversalTime(); // J.F.K. RIP loadResult.ModifiedOnDateTimeUTC = deltaTimeLoadvalue; object[] loadedObjects = null; try { Stopwatch sp = new Stopwatch(); sp.Start(); loadedObjects = _esasContainer.OptionSetValueString.ToArray(); sp.Stop(); loadResult.EsasLoadStatus = EsasOperationResultStatus.OperationSuccesful; loadResult.LoadTimeMs = sp.ElapsedMilliseconds; loadResult.Message = $"{loadedObjects.Count()} objects loaded"; } catch (Exception ex) { _logger.LogError(ex.Message, ex); loadResult.EsasLoadStatus = EsasOperationResultStatus.OperationFailed; loadResult.Message = $"Exception: {ex.Message}"; } loadResult.LoadEndTimeUTC = DateTime.UtcNow; return(loadResult, loadedObjects); }
/// <summary> /// Load Applicants Data when entering the second tab. Note, refreshes container w. database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SubmittedApplicantsTab_OnEnter(object sender, EventArgs e) { // Load Elements on Submitted Applicants TabPage container = new Default.Container(new Uri(serviceUri)); //reload container to get updated records? ApplicantsListListbox.DisplayMember = "FirstName"; ApplicantsListListbox.ValueMember = "ApplicationId"; ApplicantsListListbox.DataSource = container.Applicants.ToList(); }
public void AddCity(Default.Container container, City city) { if (container.Cities.Where(c => c.CityName == city.CityName && c.CountryID == city.CountryID).Count() != 0) { return; } container.AddToCities(city); var serviceResponse = container.SaveChanges(); }
public void AddCityClimate(Default.Container container, CityClimateInfo cityClimate) { if (container.ClimateInfo.Where(ci => ci.CityID == cityClimate.CityID && ci.Month == cityClimate.Month).Count() != 0) { return; } container.AddToClimateInfo(cityClimate); var serviceResponse = container.SaveChanges(); }
/// <summary> /// VSTS context /// </summary> /// <param name="serviceUri"></param> /// <param name="token"></param> public TimetrackerOdataContext(Uri serviceUri, string token) { _serviceUri = serviceUri; _token = token; Container = new Default.Container(serviceUri); Container.SendingRequest2 += SendHeaderAuth; }
public void AddCountry(Default.Container container, Country country) { if (container.Countries.Where(c => c.CountryName == country.CountryName).Count() != 0) { return; } container.AddToCountries(country); var serviceResponse = container.SaveChanges(); }
public MainWindow() { InitializeComponent(); var context = new Default.Container(new Uri("http://localhost:23645/api")); List <Movie> movies = context.Movies.ToList(); List <Movie> movies2 = context.Movies.Skip(25).ToList(); }
public void UpdateCity(Default.Container container, int id, string cityName) { var city = container.Cities.Where(c => c.CityID == id).SingleOrDefault(); if (city != null) { city.CityName = cityName; container.UpdateObject(city); container.SaveChanges(); } }
void DisplayPerson() { // TODO: Replace with your local URI. string serviceUri = "http://localhost:53569/odata/"; var container = new Default.Container(new Uri(serviceUri)); if (container != null) { GridView1.DataSource = container.Person; GridView1.DataBind(); } }
public void UpdateCityClimate(Default.Container container, int id, double awgTemp) { var CityClimate = container.ClimateInfo.Where(c => c.CityClimateInfoID == id).SingleOrDefault(); if (CityClimate != null) { CityClimate.AvgTemperature = awgTemp; container.UpdateObject(CityClimate); container.SaveChanges(); } }
public void UpdateCountry(Default.Container container, int id, string countryName) { var country = container.Countries.Where(c => c.CountryID == id).SingleOrDefault(); if (country != null) { country.CountryName = countryName; container.UpdateObject(country); container.SaveChanges(); } }
public static async Task <T> PostObject <T>(this Default.Container container, string url, object obj) { var client = container.GetHttpClient(); var request = new HttpRequestMessage(new HttpMethod("POST"), url) { Content = new StringContent(JsonConvert.SerializeObject(obj), Encoding.UTF8, "application/json") }; var response = await client.SendAsync(request); if (!response.IsSuccessStatusCode) { return(default);
static async Task TestService() { var context = new Default.Container(new Uri("http://localhost:5000/odata")); var query = context.Products.Where(p => p.CreatedAt < DateTimeOffset.UtcNow) as DataServiceQuery <Product>; var results = await query.ExecuteAsync(); foreach (var product in results) { Console.WriteLine("Product {0} {1}", product.Name, product.CreatedAt); } }
public static Container GetContainer() { try { string serviceUri = ApplicationSettingsFactory.GetApplicationSettings().ServiceUri; var container = new Default.Container(new Uri(serviceUri)); return container; } catch (Exception ex) { throw new Exception("GetContainer:" + ex.ToString()); } }
public List <TicketValue> ValuesPadre(Ticket ticket, Default.Container container) { List <TicketValue> values = new List <TicketValue>(); if (ticket.ParentId != 0 && ticket.ParentId != null) { values.AddRange(ValuesPadre(container.Tickets.Expand(tv => tv.TicketValues).Where(o => o.Id == ticket.ParentId).First(), container)); } values.AddRange(ticket.TicketValues); return(values); }
static void Main(string[] args) { // TODO: Replace with your local URI. string serviceUri = "http://localhost:2235/odata/"; var container = new Default.Container(new Uri(serviceUri)); //ListAllLocations(container); //AddPatient(container); //AddCareProvider(container); //AddDoctor(container); AddCase(container); System.Console.WriteLine("Dine"); }
static void Main(string[] args) { //local URI string serviceUri = "http://localhost:52605/"; var container = new Default.Container(new Uri(serviceUri)); var product = new ProductService.Models.Product() { Name = "Holzplatte", Category = "Holz" }; //AddProduct(container, product); ListAllProducts(container); }
public void DeleteCityClimate(Default.Container container, int id) { try { var CityClimate = container.ClimateInfo.Where(c => c.CityClimateInfoID == id).Single(); if (CityClimate != null) { container.DeleteObject(CityClimate); container.SaveChanges(); } } catch (DataServiceQueryException) { return; } }
static void Main(string[] args) { // TODO: Replace with your local URI. string serviceUri = "http://localhost:port/"; var container = new Default.Container(new Uri(serviceUri)); var product = new ProductService.Models.Product() { Name = "Yo-yo", Category = "Toys", Price = 4.95M }; AddProduct(container, product); ListAllProducts(container); }
public void DeleteCountry(Default.Container container, int id) { try { var country = container.Countries.Where(c => c.CountryID == id).Single(); if (country != null) { container.DeleteObject(country); container.SaveChanges(); } } catch (DataServiceQueryException) { return; } }
static void Main(string[] args) { var serviceUri = "http://192.168.70.118:8123/odata"; var container = new Default.Container(new Uri(serviceUri)); var product = new Product() { Name = "Yo-yo", Category = "Toys", Price = 4.95M }; AddProduct(container, product); ListAllProducts(container); //var pr=container.Products.FirstOrDefault(p => p.Id == 1); //Console.WriteLine("{0} {1} {2}", pr.Name, pr.Price, pr.Category); Console.ReadKey(false); }
private static void AddPatient(Default.Container container) { var patient = new testClient.Org.Naima.Services.Cases.Models.Patient() { Name = "ABD", Id = 2, LocationId = 2 }; container.AddToPatients(patient); var serviceResponse = container.SaveChanges(); foreach (var operationResponse in serviceResponse) { Console.WriteLine("Response: {0}", operationResponse.StatusCode); } }
private static void Main(string[] args) { var container = new Default.Container(new Uri("http://localhost:52126/odata")); var query = container.InternetSales.Where(p => p.DimSalesReasons.Any(x => x.SalesReasonName == "Quality")); var items = query.ToList(); Console.WriteLine($"found {items.Count} items"); foreach (var item in items) { Console.WriteLine($" - {item.SalesOrderNumber} - {item.SalesOrderLineNumber}"); } Console.WriteLine("Done"); }
/// <summary> /// Load Form and initialize all form elements /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ClientForm_Load(object sender, EventArgs e) { this.Text = "NSCC Application Form Viewer"; ResetLabels(); container = new Default.Container(new Uri(serviceUri)); //Bind Data Sources AcademicYearCbo.DisplayMember = "Description"; AcademicYearCbo.ValueMember = "AcademicYearId"; AcademicYearCbo.DataSource = container.AcademicYears.OrderBy(ay => ay.Description).ToList(); //Gender Values Hardcoded CountryCbo.DisplayMember = "CountryName"; CountryCbo.ValueMember = "CountryCode"; CountryCbo.DataSource = container.Countries.OrderBy(ay => ay.CountryName).ToList(); CountryCbo.SelectedValue = "CA"; CountryCbo_SelectedIndexChanged(this, null); ProvinceStateCbo.DisplayMember = "Name"; //Province State has composite key. How to set value member ProvinceStateCbo.DataSource = container.ProvinceStates.Where(ps => ps.CountryCode == "CA").ToList(); CitizenshipCbo.DisplayMember = "Description"; CitizenshipCbo.DataSource = container.Citizenships.ToList(); CitizenshipOtherCbo.Enabled = false; ProgramChoice1Cbo.DataSource = container.Programs.ToList(); ProgramChoice1Cbo.DisplayMember = "Name"; ProgramChoice1Cbo.ValueMember = "ProgramId"; CampusChoice1Cbo.DataSource = container.Campuses.ToList(); CampusChoice1Cbo.DisplayMember = "Name"; CampusChoice1Cbo.ValueMember = "CampusId"; ProgramChoice2Cbo.DisplayMember = "Name"; ProgramChoice2Cbo.DataSource = container.Programs.ToList(); ProgramChoice2Cbo.ValueMember = "ProgramId"; CampusChoice2Cbo.DisplayMember = "Name"; CampusChoice2Cbo.ValueMember = "CampusId"; CampusChoice2Cbo.DataSource = container.Campuses.ToList(); }
static void Main(string[] args) { // TODO: Replace with your local URI. string serviceUri = "http://localhost/WebAPI2.OData.v4.Endpoint.ProductService/"; var container = new Default.Container(new Uri(serviceUri)); var product = new Product() { Name = "Product#2", Category = "Other", Price = 10.99M }; AddProduct(container, product); ListAllProducts(container); Console.ReadLine(); }
/// <summary> /// Returns Container from V1 ODATA Version 8.9 /// </summary> /// <param name="webserverAddress"></param> /// <param name="username"></param> /// <param name="password"></param> /// <returns>Container from CxSASTOData</returns> internal static Default.Container ConnectToOData(Uri webserverAddress, string username, string password) { Console.WriteLine($"Connecting to OData ({webserverAddress.AbsoluteUri}CxWebInterface/odata/v1/)"); Uri serviceUri = new Uri(webserverAddress, "/CxWebInterface/odata/v1/"); Default.Container context = new Default.Container(serviceUri); string auth = Convert.ToBase64String(Encoding.ASCII.GetBytes($"{username}:{password}")); //Registering the handle to the BuildingRequest event. context.BuildingRequest += (sender, e) => { e.Headers.Add("Authorization", $"Basic {auth}"); }; Console.WriteLine("Connected to OData!"); return(context); }
static void Main(string[] args) { //Example of using Service with ODataClient string serviceUri = "http://localhost:57507/odata"; var container = new Default.Container(new Uri(serviceUri)); var countryService = new CountryService(); var cityService = new CityService(); //Create var country = new ClimateDBContext.Models.Country() { CountryName = "Finland", Region = WorldRegions.Eurasia }; countryService.AddCountry(container, country); //Get/Read var countries = countryService.GetCountries(container); //Update countryService.UpdateCountry(container, 2, "Republic of China"); //Delete countryService.DeleteCountry(container, 3); }
private static void AddCase(Default.Container container) { var c1 = new testClient.Org.Naima.Services.Cases.Models.Case() { Status = "Open", Id = 1, PatientId = 1, DoctorId = 1, CareProviderId = 1 }; var c2 = new testClient.Org.Naima.Services.Cases.Models.Case() { Status = "Closed", Id = 2, PatientId = 1, DoctorId = 2, CareProviderId = 2 }; var c3 = new testClient.Org.Naima.Services.Cases.Models.Case() { Status = "Open", Id = 3, PatientId = 2, DoctorId = 2, CareProviderId = 2 }; container.AddToCases(c1); container.AddToCases(c2); container.AddToCases(c3); var serviceResponse = container.SaveChanges(); foreach (var operationResponse in serviceResponse) { Console.WriteLine("Response: {0}", operationResponse.StatusCode); } }
private static void AddCareProvider(Default.Container container) { var cp1 = new testClient.Org.Naima.Services.Cases.Models.CareProvider() { Name = "Ramlal", Id = 1, LocationId = 1 }; var cp2 = new testClient.Org.Naima.Services.Cases.Models.CareProvider() { Name = "Mohan", Id = 2, LocationId = 2 }; container.AddToCareProviders(cp1); container.AddToCareProviders(cp2); var serviceResponse = container.SaveChanges(); foreach (var operationResponse in serviceResponse) { Console.WriteLine("Response: {0}", operationResponse.StatusCode); } }