public async Task <IOrderedEnumerable <mdisk> > GetStorage(string date = "", int minSize = 0, string region = "europe-west", string currency = "usd")
{
DateTime?dt;
VmList vml = new VmList(configuration);
String regionSlug;
try
{
dt = excelAzureBackend.excelAzureHelpers.parseDTString(date);
regionSlug = await vml.FindRegionSlug(region);
var validCurrency = excelAzureHelpers.validateCurrency(currency);
}
catch (Exception)
{
this.Response.StatusCode = 400;
return(null);
}
mdisk md = new mdisk(configuration);
List <mdisk> mdiskList = await md.GetMdisks(regionSlug, currency, dt);
var result = mdiskList.Where(i => i.size >= minSize && i.pricemonth.HasValue).OrderBy(x => x.pricemonth);
return(result);
}
public async Task <string> GetStorageCSV(int minSize = 0, string region = "europe-west", string currency = "usd")
{
mdisk md = new mdisk(configuration);
List <mdisk> mdiskList = await md.GetMdisks(region, currency);
var result = mdiskList.Where(i => i.size >= minSize && i.pricemonth.HasValue).OrderBy(x => x.pricemonth);
StringBuilder s = new StringBuilder();
DataTable dt = JsonConvert.DeserializeObject <DataTable>(JsonConvert.SerializeObject(result));
foreach (DataColumn column in dt.Columns)
{
s.Append(column.ColumnName + ";");
}
s.Append(Environment.NewLine);
foreach (DataRow row in dt.Rows)
{
for (var i = 0; i < dt.Columns.Count; i++)
{
s.Append(row[i] + ";");
}
s.Append(Environment.NewLine);
}
return(s.ToString());
}
public async Task <IOrderedEnumerable <mdisk> > GetStorage(int minSize = 0, string region = "europe-west", string currency = "usd")
{
mdisk md = new mdisk(configuration);
List <mdisk> mdiskList = await md.GetMdisks(region, currency);
var result = mdiskList.Where(i => i.size >= minSize && i.pricemonth.HasValue).OrderBy(x => x.pricemonth);
return(result);
}
public async Task <string> StoreMdisk(string region = "europe-west", string currency = "usd")
{
client = new HttpClient();
mdisk mdk = new mdisk(configuration);
excelAzureHelpers xhlp = new excelAzureHelpers(configuration);
var url = mdisk.mdiskUrl + currency;
var response = await client.GetAsync(url);
var result = await response.Content.ReadAsStringAsync();
var uri = await storeBlob(result, DateTime.UtcNow, "mdisk", currency, null);
return("Stored mdisks at " + uri.AbsoluteUri);
}
public async Task <string> GetStorageCSV(int minSize = 0, string region = "europe-west", string currency = "usd", string date = null)
{
DateTime?dt;
Models.VmList vml = new Models.VmList(configuration);
String regionSlug;
try
{
dt = excelAzureBackend.excelAzureHelpers.parseDTString(date);
regionSlug = await vml.FindRegionSlug(region);
var validCurrency = excelAzureHelpers.validateCurrency(currency);
}
catch (Exception)
{
this.Response.StatusCode = 400;
return("");
}
mdisk md = new mdisk(configuration);
List <mdisk> mdiskList = await md.GetMdisks(region, currency, dt);
var result = mdiskList.Where(i => i.size >= minSize && i.pricemonth.HasValue).OrderBy(x => x.pricemonth);
StringBuilder s = new StringBuilder();
DataTable datbl = JsonConvert.DeserializeObject <DataTable>(JsonConvert.SerializeObject(result));
foreach (DataColumn column in datbl.Columns)
{
s.Append(column.ColumnName + ";");
}
s.Append(Environment.NewLine);
foreach (DataRow row in datbl.Rows)
{
for (var i = 0; i < datbl.Columns.Count; i++)
{
s.Append(row[i] + ";");
}
s.Append(Environment.NewLine);
}
return(s.ToString());
}
public async Task <string> GetStorageCSV2(int minSize = 0, string region = "europe-west", string currency = "usd", bool store = false, string date = null)
{
DateTime?dt;
VmList vml = new VmList(configuration);
String regionSlug;
try
{
dt = excelAzureBackend.excelAzureHelpers.parseDTString(date);
regionSlug = await vml.FindRegionSlug(region);
var validCurrency = excelAzureHelpers.validateCurrency(currency);
}
catch (Exception)
{
this.Response.StatusCode = 400;
return("");
}
UltraSSDs ussds = new UltraSSDs(configuration);
var ussdisks = await ussds.GetUltraSSDs(region, currency, dt);
mdisk md = new mdisk(configuration);
List <mdisk> mdiskList = await md.GetMdisks(regionSlug, currency, dt);
List <mdisk> ussdMdiskList = new List <mdisk>();
foreach (var item in mdiskList)
{
var compare_ussd = ussds.findUSSD(ussdisks, item.size, item.iops, item.speed, item.pricemonth);
if (compare_ussd.Count <UltraSSD>() > 0)
{
var ussdPriceMonth = ussds.calculatePriceMonth(compare_ussd[0], item.iops, item.speed);
// If the USSD is cheaper, replace the disk with USSD
string mdiskname = item.name.Split("-")[1];
item.name = "ultrassd-" + mdiskname; item.displayName = compare_ussd[0].displayName; item.isPreview = false; item.size = compare_ussd[0].size; item.pricemonth = ussdPriceMonth; item.priceyear = ussdPriceMonth * 12; item.snapshotPrice = null; item.transactionPrice = null; item.snapshotPriceLrs = null; item.snapshotPriceZrs = null;
//ussdMdiskList.Add(new mdisk(configuration) { name = compare_ussd[0].name, displayName = compare_ussd[0].displayName, isPreview = false, size = compare_ussd[0].size, iops = item.iops, speed = item.speed, pricemonth = ussdPriceMonth, priceyear = ussdPriceMonth*12, snapshotPrice = null, transactionPrice = null });
}
}
ussdMdiskList.ForEach(p => mdiskList.Add(p));
var result = mdiskList.Where(i => i.size >= minSize && i.pricemonth.HasValue).OrderBy(x => x.pricemonth);
StringBuilder s = new StringBuilder();
DataTable datbl = JsonConvert.DeserializeObject <DataTable>(JsonConvert.SerializeObject(result));
foreach (DataColumn column in datbl.Columns)
{
s.Append(column.ColumnName + ";");
}
s.Append(Environment.NewLine);
foreach (DataRow row in datbl.Rows)
{
for (var i = 0; i < datbl.Columns.Count; i++)
{
s.Append(row[i] + ";");
}
s.Append(Environment.NewLine);
}
return(s.ToString());
}
public async Task <string> GetStorageCSV(int minSize = 0, string region = "europe-west", string currency = "usd", bool store = false, string date = null)
{
DateTime?dt;
VmList vml = new VmList(configuration);
String regionSlug;
try
{
dt = excelAzureBackend.excelAzureHelpers.parseDTString(date);
regionSlug = await vml.FindRegionSlug(region);
var validCurrency = excelAzureHelpers.validateCurrency(currency);
}
catch (Exception)
{
this.Response.StatusCode = 400;
return("");
}
mdisk md = new mdisk(configuration);
List <mdisk> mdiskList = await md.GetMdisks(regionSlug, currency, dt);
var result = mdiskList.Where(i => i.size >= minSize && i.pricemonth.HasValue).OrderBy(x => x.pricemonth);
if (store)
{
string EndpointUri = configuration.GetValue <string>("CosmosDBSettings:EndpointUri");
string PrimaryKey = configuration.GetValue <string>("CosmosDBSettings:PrimaryKey");
string databaseName = configuration.GetValue <string>("CosmosDBSettings:databaseName");
DocumentClient Dbclient;
DboMdisks dbomdisks = new DboMdisks();
dbomdisks.mdisks = result.ToList <mdisk>();
dbomdisks.region = region;
dbomdisks.currency = currency;
dbomdisks.date = DateTime.Now;
// Save result to DocumentDB
Dbclient = new DocumentClient(new Uri(EndpointUri), PrimaryKey);
await Dbclient.CreateDocumentAsync(UriFactory.CreateDocumentCollectionUri(databaseName, "mdisks"), dbomdisks);
}
StringBuilder s = new StringBuilder();
DataTable datbl = JsonConvert.DeserializeObject <DataTable>(JsonConvert.SerializeObject(result));
foreach (DataColumn column in datbl.Columns)
{
s.Append(column.ColumnName + ";");
}
s.Append(Environment.NewLine);
foreach (DataRow row in datbl.Rows)
{
for (var i = 0; i < datbl.Columns.Count; i++)
{
s.Append(row[i] + ";");
}
s.Append(Environment.NewLine);
}
return(s.ToString());
}
