public IQueryable getArea(measure pMeasure, industry pIndustry)
{
var seriesQuery = (from records in db.series
where records.measureID == pMeasure.measureID &&
records.industryID == pIndustry.industryID
select new { areaResult = records.area })
.Distinct();
var query = (from val in seriesQuery
select new { areaID = val.areaResult.areaID, areaName = val.areaResult.areaName });
return(query);
}
public IQueryable getIndustry(measure pMeasure)
{
var query = (from records in db.series
where records.measureID == pMeasure.measureID
select new { industryResult = records.industry })
.Distinct();
var t = (from val in query
select new { industryID = val.industryResult.industryID, industryName = val.industryResult.industryName });
return(t);
}
public JsonResult getArea(measureIndustry pData)
{
measure measureToSend = new measure();
industry industryToSend = new industry();
measureToSend.measureID = pData.measureID;
measureToSend.measureName = pData.measureName;
industryToSend.industryID = pData.industryID;
industryToSend.industryName = pData.industryName;
var queryResult = downloadModel.getArea(measureToSend, industryToSend);
return(Json(queryResult, "application/json"));
}
public bool Create(measure _ref)
{
bool rtval = false;
try
{
pEntity.ref_measurement_Insert(_ref.measure_id,_ref.measurement);
pEntity.SaveChanges();
rtval = true;
}
catch (Exception ex)
{
_err = ex.ToString();
a.logModule = "Measures";
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
rtval = false;
}
return rtval;
}
public JsonResult postmeasure(measure pMeasure)
{
addModel.checkMeasure(pMeasure);
return(Json(pMeasure, "application/json"));
}
public string insertFromCsv(string fileName)
{
string[] strArray;
string firstLine = string.Empty;
Regex r = new Regex(",(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))");
StreamReader sr = new StreamReader(fileName);
string headerline = sr.ReadLine();
firstLine = sr.ReadLine();
strArray = r.Split(firstLine);
area newArea = new area();
measure newMeasure = new measure();
industry newIndustry = new industry();
series newSeries = new series();
newArea.areaID = strArray[2];
newArea.areaName = strArray[1];
newMeasure.measureID = strArray[4];
newMeasure.measureName = strArray[3];
newIndustry.industryID = strArray[6];
newIndustry.industryName = strArray[5];
newSeries.areaID = newArea.areaID;
newSeries.measureID = newMeasure.measureID;
newSeries.industryID = newIndustry.industryID;
newSeries.seriesID = newArea.areaID + strArray[0];
newSeries.beginYear = "NA";
newSeries.beginPeriod = "NA";
newSeries.endYear = "NA";
newSeries.endPeriod = "NA";
newSeries.blsTable = strArray[0];
db.areas.Add(newArea);
db.industries.Add(newIndustry);
db.measures.Add(newMeasure);
db.series.Add(newSeries);
db.SaveChanges();
//start reading from 2nd line in CSV
foreach (var line in File.ReadAllLines(fileName, Encoding.GetEncoding(1250)).Skip(1))
{
strArray = r.Split(line);
//assign split string to variables
data_table newData = new data_table();
int year = Convert.ToInt32(strArray[7]);
long value = Convert.ToInt64(strArray[8]);
newData.seriesID = newSeries.seriesID;
newData.period = "NA";
newData.year = year;
newData.value = value;
db.data_table.Add(newData);
db.SaveChanges();
}
return("Updated Database");
}
public void checkMeasure(measure pMeasure)
{
db.measures.Add(pMeasure);
db.SaveChanges();
}
public static double convertSize(double size, measure unit)
{
int iUnit = (int) unit;
if (iUnit == 0 || size <= 0) return size;
iUnit--;
return convertSize(size/1024, (measure)iUnit);
}
public JsonResult getIndustry(measure pMeasure)
{
var queryResult = downloadModel.getIndustry(pMeasure);
return(Json(queryResult, "application/json"));
}
