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