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