private SqlQuery BuildSqlQuery(IEnumerable <FilterCriteria> filters, DataSetSchema schema, string orderByColumn, string orderDirection,
int pageNum, int pageSize)
{
orderDirection = orderDirection == "ASC" ? "ASC" : "DESC";
var queryDetail = new SqlQuery();
var parameters = new List <SqlParameter>
{
new SqlParameter
{
ParameterName = "@pageNum",
SqlDbType = SqlDbType.Int,
Direction = ParameterDirection.Input,
Value = pageNum
},
new SqlParameter
{
ParameterName = "@pageSize",
SqlDbType = SqlDbType.Int,
Direction = ParameterDirection.Input,
Value = pageSize
}
};
//get where clause
var whereClause = GetWhereClause(filters, schema, parameters);
var orderBy = schema.Definition.ColumnSelectList.Contains(orderByColumn) ? orderByColumn : schema.Definition.DefaultSortColumn;
var orderByDirection = orderDirection.ToUpper() == "ASC" ? "ASC" : "DESC";
var sqlResults = String.Format(@"DECLARE @lbound int,@ubound int,@recct int
SET @pageNum = ABS(@pageNum)
SET @pageSize = ABS(@pageSize)
IF @pageNum < 1 SET @pageNum = 1
IF @pageSize < 1 SET @pageSize = 1
SET @lbound = ((@pageNum - 1) * @pageSize)
SET @ubound = @lbound + @pageSize + 1
IF @lbound >= @recct BEGIN
SET @ubound = @recct + 1
SET @lbound = @ubound - (@pageSize + 1)
END
SELECT {0} FROM(SELECT ROW_NUMBER() OVER(ORDER BY {4} {2}) AS row, *
FROM {1}{3}) AS tbl {5}",
schema.Definition.ColumnSelectList,
schema.Definition.TableName,
orderByDirection,
whereClause.Length > 0 ? String.Format(" Where {0}", whereClause) : "",
orderBy,
pageSize > 0 ? "WHERE row > @lbound AND row < @ubound" : String.Format("ORDER BY {0} {1}", orderBy, orderByDirection));
var sqlCount = String.Format(@"SELECT COUNT(*) FROM {0} {1}", schema.Definition.TableName, whereClause.Length > 0 ? String.Format(" Where {0}", whereClause) : "");
var sqlTotals = String.Format(@"SELECT Top 1 {0} FROM {1} {2}", schema.Definition.ColumnSumSql, schema.Definition.TableName, whereClause.Length > 0 ? String.Format(" Where {0}", whereClause) : "");
queryDetail.Sql = String.Format(@"{0} {1} {2}", sqlCount, sqlResults, sqlTotals);
queryDetail.Params = parameters.ToArray();
return(queryDetail);
}
private void PopulateDsSchemaWithEsdValues(DataSetSchema schemaDetail)
{
var esdService = _esdFunctionService; //new EsdFunctionService();
//esdService.XmlContent = GetFunctionServicesXmlContentAndSaveToSession();
//esdService.ProcessXmlContent();
schemaDetail.EsdFunctions = esdService.GetFunctions();
schemaDetail.EsdServices = esdService.GetServices();
schemaDetail.CurrentMappedEsdFunctionService = esdService.GetLinkedFunctionsServices(schemaDetail.Id).Select(x => x);
}
public void GetFeatured_returns_all_featured_orderedby_dateupdated_ascending()
{
//arrange
var ds1 = new List <DataSetDetail>()
{
new DataSetDetail()
{
DateUpdated = new DateTime(2011, 1, 1)
}, new DataSetDetail()
{
DateUpdated = new DateTime(2010, 1, 1)
}
};
var schema1 = new DataSetSchema()
{
Category = new Category()
{
Title = "category", IsDisabled = false
}, DataSets = ds1, IsApproved = true, IsFeatured = true, DateUpdated = new DateTime(2000, 1, 1)
};
_repositoryDataSetSchema.Add(schema1);
var schema2 = new DataSetSchema()
{
Category = new Category()
{
Title = "category", IsDisabled = false
}, DataSets = ds1, IsApproved = true, IsFeatured = true, DateUpdated = new DateTime(1998, 1, 1)
};
_repositoryDataSetSchema.Add(schema2);
var schema3 = new DataSetSchema()
{
Category = new Category()
{
Title = "categoryurl", IsDisabled = false
}, DataSets = ds1, IsApproved = false, IsFeatured = true, DateUpdated = new DateTime(2001, 1, 1)
};
_repositoryDataSetSchema.Add(schema3);
var sut = new DataSetSchemaService(_repositoryDataSetSchema, _dataSetSchemaDefinitionService,
_repositoryDataSetDetail, _sqlTableUtility);
//act
var result = sut.GetFeatured();
//assert
Assert.AreEqual(new DateTime(1998, 1, 1), result[0].DateUpdated);
//cleanup
_repositoryDataSetSchema.Delete(schema1);
_repositoryDataSetSchema.Delete(schema2);
_repositoryDataSetSchema.Delete(schema3);
}
public void CheckOrderByDirection_when_order_direction_is_NOT_null_and_NOT_empty_returns_orderDirection()
{
//arrange
var formatter = new SqlOrderByColumnAndDirectionFormatter();
//action
var orderdirection = "notEmpty";
var schema = new DataSetSchema();
var result = formatter.CheckOrderByDirection(schema, orderdirection);
//assert
Assert.AreEqual("notEmpty", result);
}
private void SetViewBagValues(DataSetSchema schemaDetail)
{
ViewBag.Title = String.Format("Download {0} - DataShare", schemaDetail.Title);
ViewBag.SchemaTitle = schemaDetail.Title;
ViewBag.ShortDescription = schemaDetail.ShortDescription;
//Remove all whitespace and make sure it's ok to pass this to js
ViewBag.FullDescription = (schemaDetail.Description != null)
? schemaDetail.Description.RemoveWhiteSpaces().Replace("\"", "\'")
: "";
ViewBag.SchemaId = schemaDetail.Id;
ViewBag.IsExternalData = schemaDetail.IsExternalData;
}
private ActionResult ReturnDownloadFile(string fileTitle, string schema, DataSetSchema schemaDetail, string downloadFormat)
{
var fileDetail = _dataSetDetailService.GetData(fileTitle, schema);
if (fileDetail == null)
{
return(ReturnErrorView());
}
schemaDetail.Definition = schemaDetail.Definition ?? new DataSetSchemaDefinition();
return(this.DownloadDataSet(downloadFormat, fileDetail, fileTitle,
schemaDetail.Definition.Columns, _systemConfigurationService));
}
public void CheckOrderByDirection_when_schema_is_null_and_orderdirection_is_empty_returns_ASC()
{
//arrange
var formatter = new SqlOrderByColumnAndDirectionFormatter();
//action
var orderdirection = "";
DataSetSchema schema = null;
var result = formatter.CheckOrderByDirection(schema, orderdirection);
//assert
Assert.AreEqual("ASC", result);
}
private void SaveEsdLinks(DataSetSchema dsSchema)
{
var xlist = new List <string>();
if (dsSchema.CurrentMappedEsdFunctionService != null)
{
foreach (var x in dsSchema.CurrentMappedEsdFunctionService)
{
xlist.Add(Convert.ToString(x));
}
}
_esdFunctionService.SaveLinkedFunctionServices(dsSchema.Id, xlist);
}
public string CheckOrderByColumn(DataSetSchema schema, string orderByColumn)
{
if (string.IsNullOrEmpty(orderByColumn) && schema != null && schema.Definition != null)
{
return(schema.Definition.DefaultSortColumn);
}
if (!string.IsNullOrEmpty(orderByColumn) && !orderByColumn.StartsWith("["))
{
return(String.Format("[{0}]", orderByColumn));
}
return(orderByColumn);
}
CheckOrderByColumn_when_orderBycolumn_is_NOTnullOrEmpty_and_orderByColumn_does_not_startWith_bracket_returns_orderBy_enclosed_by_brackets
()
{
//arrange
var formatter = new SqlOrderByColumnAndDirectionFormatter();
string orderbyColumn = "col1";
var schema = new DataSetSchema();
//act
var result = formatter.CheckOrderByColumn(schema, orderbyColumn);
//assert
Assert.AreEqual("[col1]", result);
//clean up
}
CheckOrderByColumn_when_orderBycolumn_is_NOT_nullOrEmpty_and_orderByColumn_starts_with_and_datasetcolumns_are_empty_returns_orderBycolumn
()
{
//arrange
var formatter = new SqlOrderByColumnAndDirectionFormatter();
string orderbyColumn = "[col1_v2]";
var schema = new DataSetSchema();
//act
var result = formatter.CheckOrderByColumn(schema, orderbyColumn);
//assert
Assert.AreEqual("[col1_v2]", result);
//clean up
}
public void GetOverDue_returns_DataSetSchemaList_where_schema_is_online()
{
//arrange
var ds1 = new List <DataSetDetail>()
{
new DataSetDetail()
{
DateCreated = new DateTime(2011, 1, 1)
}
};
var schema1 = new DataSetSchema()
{
Category = new Category()
{
Title = "category", IsDisabled = false
}, IsApproved = true, UploadFrequency = 0
};
_repositoryDataSetSchema.Add(schema1);
var schema2 = new DataSetSchema()
{
Category = new Category()
{
Title = "category", IsDisabled = false
}, IsApproved = false, UploadFrequency = 1, DataSets = ds1
};
_repositoryDataSetSchema.Add(schema2);
var schema3 = new DataSetSchema()
{
Category = new Category()
{
Title = "category", IsDisabled = false
}, IsApproved = true, UploadFrequency = 2, DataSets = ds1
};
_repositoryDataSetSchema.Add(schema3);
var sut = new DataSetSchemaService(_repositoryDataSetSchema, _dataSetSchemaDefinitionService,
_repositoryDataSetDetail, _sqlTableUtility);
//act
var result = sut.GetOverDue();
//assert
Assert.AreEqual(2, result[0].UploadFrequency);
//cleanup
_repositoryDataSetSchema.Delete(schema1);
_repositoryDataSetSchema.Delete(schema2);
_repositoryDataSetSchema.Delete(schema3);
}
public string CheckOrderByDirection(DataSetSchema schema, string orderDirection)
{
if (!string.IsNullOrEmpty(orderDirection))
{
return(orderDirection);
}
if (schema != null && schema.Definition != null)
{
return(schema.Definition.DefaultSortColumnDirection);
}
return("ASC");
}
Ajax_SearchSchema_when_numberToShow_is_null_use_settingsValue_from_config_file_returns_result_from_search_schema()
{
//arrange
string category = "";
string schema = "";
int currentPage = 1;
string orderByColumn = "";
string orderByDirection = "";
IList <FilterCriteria> filter = new List <FilterCriteria>();
string download = "";
bool getVisualisationData = false;
string chartType = "";
string xAxis = "";
string yAxis = "";
int? chartCurrentPage = null;
int? chartNumberToShow = null;
string yAxisAggregate = "";
DataSetSchema schemaDetail = new DataSetSchema()
{
Definition = new DataSetSchemaDefinition()
{
}
};
var mock = new Mock <IDataSetDetailService>();
mock.Setup(x => x.SearchSchema(filter, schemaDetail, currentPage, 103, orderByColumn, orderByDirection, true)).Returns(new ViewControllerData()
{
DataGraph = "fromSearchSchema"
});
_datasetDetailService = mock.Object;
var mock2 = new Mock <IDataSetSchemaService>();
mock2.Setup(x => x.Get(schema)).Returns(schemaDetail);
_dataSchemaService = mock2.Object;
var sut = new ViewController(_dataSchemaService, _datasetDetailService, _categoryService, _sysConfigService);
//action
var result = (JsonNetResult)sut.Ajax(category, schema, currentPage, null, orderByColumn, orderByDirection, filter,
download, getVisualisationData, chartType, xAxis, yAxis, chartCurrentPage,
chartNumberToShow, yAxisAggregate);
var unboxedResult = (ViewControllerData)result.Data;
//assert
Assert.AreEqual(unboxedResult.DataGraph, "fromSearchSchema");
//cleanup
}
private ActionResult ReturnDownloadCsvData(IList <FilterCriteria> filter,
DataSetSchema schemaDetail, string orderByColumn, string orderByDirection)
{
var results = _dataSetDetailService.SearchSchema(filter,
schemaDetail,
orderByColumn,
orderByDirection);
var csv = results.Data.AppendBody(_systemConfigurationService)
.ToCsv(",",
schemaDetail.Definition == null
? new List <DataSetSchemaColumn>()
: schemaDetail.Definition.Columns);
return(new CsvResult(csv, schemaDetail.FriendlyUrl));
}
public void GetOverDue_returns_DataSetSchemaList_where_lastuploadeddate_lessthan_overdue_date_and_date_last_reminded_is_lessthan_overdue_date()
{
//arrange
var ds1 = new List <DataSetDetail>()
{
new DataSetDetail()
{
DateCreated = DateTime.Now.AddDays(-4)
}
}; // overdue date is alway -3 ( so this is not overdue)
var schema1 = new DataSetSchema()
{
Category = new Category()
{
Title = "category", IsDisabled = false
}, IsApproved = true, UploadFrequency = 1, DataSets = ds1
};
_repositoryDataSetSchema.Add(schema1);
var ds2 = new List <DataSetDetail>()
{
new DataSetDetail()
{
DateCreated = new DateTime(1998, 1, 1)
}
};
var schema2 = new DataSetSchema()
{
Category = new Category()
{
Title = "category", IsDisabled = false
}, DateLastReminded = new DateTime(1998, 1, 1), IsApproved = true, UploadFrequency = 2, DataSets = ds2
};
_repositoryDataSetSchema.Add(schema2);
var sut = new DataSetSchemaService(_repositoryDataSetSchema, _dataSetSchemaDefinitionService,
_repositoryDataSetDetail, _sqlTableUtility);
//act
var result = sut.GetOverDue();
//assert
Assert.AreEqual(2, result[0].UploadFrequency);
//cleanup
_repositoryDataSetSchema.Delete(schema1);
_repositoryDataSetSchema.Delete(schema2);
}
public void CheckOrderByDirection_when_schema_is_not_null_and_definition_is_not_null_and_schema_definition_columns_is_null_returns_ASC()
{
//arrange
var formatter = new SqlOrderByColumnAndDirectionFormatter();
//action
var orderdirection = "";
var schema = new DataSetSchema()
{
Definition = new DataSetSchemaDefinition()
{
}
};
var result = formatter.CheckOrderByDirection(schema, orderdirection);
//assert
Assert.AreEqual("ASC", result);
}
public DataSetSchema AnalyzeFileDiskAction(int id)
{
APIRequest source = db.APIRequests.Find(id);
DataSetSchema schema = null;
try
{
int year = (source.sampleYear != null)? (int)source.sampleYear:0;
int month = (source.sampleMonth != null) ? (int)source.sampleMonth : 0;
int weeky = (source.sampleWeeky != null) ? (int)source.sampleWeeky : 0;
int day = (source.sampleDay != null) ? (int)source.sampleDay : 0;
string url = apiCaller.replaceURIPlaceHolders(source.url, year, month, weeky, day);
string safeFileName = url.Replace('/', '_').Replace(':', '_').TrimStart().TrimEnd();
string downloadedFilePath = HttpContext.Server.MapPath("~/App_Data/" + safeFileName);
source.onDisk = "N/A";
bool fileExists = System.IO.File.Exists(downloadedFilePath);
if (System.IO.File.Exists(downloadedFilePath))
{
var fileModel = apiCaller.AnalyzeFileOnDisk(safeFileName);
long length = new System.IO.FileInfo(downloadedFilePath).Length;
var dataset = Microsoft.Research.Science.Data.DataSet.Open(downloadedFilePath);
schema = dataset.GetSchema();
if (schema.Variables.Length > 1)
{
source.onDisk = "OK";
source.fileSize = (int)length / 1000000;
source.schema = fileModel.schema;
}
}
}
catch (Exception e)
{
source.onDisk = "Error: " + e.Message;
}
db.Entry(source).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(schema);
}
public void Get_when_schema_definition_columns_is_null_exist_throws_argumentnullexception()
{
//arrange
var cat = new DataSetSchema()
{
Title = "schemaname", Definition = new DataSetSchemaDefinition(), Category = new Category()
{
Title = "categoryname"
}
};
_repositoryDataSetSchema.Add(cat);
var service = new DataSetSchemaColumnService(_repositoryDataSetSchemaColumn, _repositoryDataSetSchema, _sqlrepo);
//act
var result = service.Get("categoryname", "schemaname", "columnname");
//assert - no need to assert as throwing error
//cleanup
}
VisualiseSchema_will_return_type_of_view_controller_data()
{
//arrange
IList <FilterCriteria> filter = null;
DataSetSchema schema = null;
int pageNumber = 0;
int pageSize = 0;
string chartType = null;
string xAxis = null;
string yAxis = null;
string yAxisAggregate = null;
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.VisualiseSchema(filter, schema, pageNumber, pageSize, chartType, xAxis, yAxis, yAxisAggregate);
//assert
Assert.AreEqual(typeof(ViewControllerData), result.GetType());
}
public void GetFeatured_returns_all_is_featured()
{
//arrange
var ds1 = new List <DataSetDetail>()
{
new DataSetDetail()
{
DateUpdated = new DateTime(2011, 1, 1)
}, new DataSetDetail()
{
DateUpdated = new DateTime(2010, 1, 1)
}
};
var schema1 = new DataSetSchema()
{
Category = new Category()
{
Title = "category", IsDisabled = false
}, Title = "btitle", DataSets = ds1, IsApproved = true, IsFeatured = false
};
_repositoryDataSetSchema.Add(schema1);
//this is featured.
var schema2 = new DataSetSchema()
{
Category = new Category()
{
Title = "category", IsDisabled = false
}, Title = "atitle", DataSets = ds1, IsApproved = true, IsFeatured = true
};
_repositoryDataSetSchema.Add(schema2);
var sut = new DataSetSchemaService(_repositoryDataSetSchema, _dataSetSchemaDefinitionService,
_repositoryDataSetDetail, _sqlTableUtility);
//act
var result = sut.GetFeatured();
//assert
Assert.AreEqual(1, result.Count);
//cleanup
_repositoryDataSetSchema.Delete(schema1);
_repositoryDataSetSchema.Delete(schema2);
}
public void Get_when_friendlyurl_is_found_return_datasetschema()
{
//arrange
var schema1 = new DataSetSchema()
{
Id = 1, Title = "friendlyurl"
};
_repositoryDataSetSchema.Add(schema1);
var sut = new DataSetSchemaService(_repositoryDataSetSchema, _dataSetSchemaDefinitionService,
_repositoryDataSetDetail, _sqlTableUtility);
//act
var result = sut.Get("friendlyurl");
//assert
Assert.AreEqual(1, result.Id);
//cleanup
_repositoryDataSetSchema.Delete(schema1);
}
public void GetByFriendlyUrl_show_all_is_false_return_only_online_schema_with_datasetdetail_ordered_by_desc_dateupdated()
{
//arrange
var ds1 = new List <DataSetDetail>()
{
new DataSetDetail()
{
DateUpdated = new DateTime(2011, 1, 1)
}
, new DataSetDetail()
{
DateUpdated = new DateTime(2010, 1, 1)
}
};
var schema1 = new DataSetSchema()
{
Category = new Category()
{
Title = "categoryurl", IsDisabled = false
}, Title = "schemaurl", DataSets = ds1, IsApproved = true
};
var ds2 = new List <DataSetDetail>();
var schema2 = new DataSetSchema()
{
Category = new Category()
{
Title = "categoryurl"
}, Title = "schemaurl", IsDisabled = true, DataSets = ds2
};
_repositoryDataSetSchema.Add(schema1);
_repositoryDataSetSchema.Add(schema2);
var sut = new DataSetSchemaService(_repositoryDataSetSchema, _dataSetSchemaDefinitionService,
_repositoryDataSetDetail, _sqlTableUtility);
//act
var result = sut.GetByFriendlyUrl("categoryurl", "schemaurl", false);
//assert
Assert.AreEqual(new DateTime(2011, 1, 1), result[0].DateUpdated);
//cleanup
_repositoryDataSetSchema.Delete(schema1);
_repositoryDataSetSchema.Delete(schema2);
}
public void Index_when_schema_is_not_null_and_schema_detail_is_not_null_and_schema_is_not_online_and_preview_is_not_true_returns_partial_view_offline()
{
//arrange
var schema = "schemanotNull";
var schemaDetail = new DataSetSchema();
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get(schema)).Returns(schemaDetail);
_dataSchemaService = mock.Object;
var sut = new ViewController(_dataSchemaService, _datasetDetailService, _categoryService, _sysConfigService);
//action
var filter = new List <FilterCriteria>();
var result = (PartialViewResult)sut.Index("category", schema, 1, 1, "", "", filter, "", "previewNotTrue");
//assert
Assert.AreEqual("Offline", result.ViewName);
//cleanup
_dataSchemaService = null;
}
public void Save(DataSetSchema schemaData)
{
var schema = _repository.GetQuery().FirstOrDefault(s => s.Id == schemaData.Id);
schema.UploadFrequency = schemaData.UploadFrequency;
schema.OwnerEmail = schemaData.OwnerEmail;
schema.Description = schemaData.Description;
schema.IsExternalData = schemaData.IsExternalData;
schema.IsFeatured = schemaData.IsFeatured;
schema.IsAllDataOverwittenOnUpload = schemaData.IsAllDataOverwittenOnUpload;
schema.ShortDescription = schemaData.ShortDescription;
if (String.IsNullOrEmpty(schema.SchemaDefinitionFromUrl))
{
schema.Title = schemaData.Title;
}
_repository.SaveChanges();
}
ImportFromUrl_when_columnDefinitions_contains_publisherlabel_returns_importdatasetschemaresult_with_error_message_with_xml_schema_cannot_contain_reserved_columns()
{
//arrange
var dschema = new DataSetSchema()
{
SchemaDefinitionFromUrl = "http://dummyurl"
};
var obj = new SchemaRestDefinition()
{
ErrorMessage = "",
RestSchema = new RestSchema()
{
},
RestColumnDefinitions = new RestColumnDefinitions()
{
ColumnDefinitions = new List <RestColumnDefinition>()
{
new RestColumnDefinition()
{
Name = "publisherLabel"
}
}
}
};
var mock = new Mock <IXmlToObjectService>();
mock.Setup(x => x.GetXmlFromUrl("http://dummyurl")).Returns("<SchemaRestDefinition></SchemaRestDefinition>");
mock.Setup(x => x.ConvertXml <SchemaRestDefinition>("<SchemaRestDefinition></SchemaRestDefinition>"))
.Returns(obj);
_xmlToObjectService = mock.Object;
_dataSetSchemaService = new Mock <IDataSetSchemaService>().Object;
var service = new DataShareSchemaImportService(_xmlToObjectService, _dataSetSchemaService,
_dataSetSchemaColumnService);
//act
var result = service.ImportFromUrl(dschema);
//assert
Assert.AreEqual("Error: Columns cannot contain reserved column names - PublisherUri/PublisherLabel/Publisher Uri/Publisher Label. http://dummyurl"
, result.ErrorMessage);
//cleanup
_xmlToObjectService = null;
}
public void Index_when_schema_is_not_null_and_schema_detail_is_not_null_schema_is_online_Filter_has_value_and_Not_external_data_will_use_Search_schema_to_return_viewControllerData()
{
//arrange
var schema = "schemanotNull";
var schemaDetail = new DataSetSchema()
{
IsDisabled = false, IsApproved = true, IsExternalData = false, Category = new Category()
{
IsDisabled = false
}
};
var filter = new List <FilterCriteria>()
{
new FilterCriteria()
{
}
};
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get(schema)).Returns(schemaDetail);
_dataSchemaService = mock.Object;
var mock2 = new Mock <IDataSetDetailService>();
mock2.Setup(x => x.SearchSchema(filter, schemaDetail, 1, 1, "", "", true)).Returns(new ViewControllerData()
{
Count = 1234
});
_datasetDetailService = mock2.Object;
var sut = new ViewController(_dataSchemaService, _datasetDetailService, _categoryService, _sysConfigService);
//action
var result = (ViewResult)sut.Index("category", schema, 1, 1, "", "", filter, "", "");
var model = (ViewControllerData)result.Model;
//assert
Assert.AreEqual(1234, model.Count);
//cleanup
_dataSchemaService = null;
_datasetDetailService = null;
}
public void Create_when_schema_is_externaldata_will_save_in_schema_definition_in_repository()
{
//arrange
var schematoAdd = new DataSetSchema()
{
Id = 10, Title = "sampletitle", IsExternalData = true
};
var sut = new DataSetSchemaService(_repositoryDataSetSchema, _dataSetSchemaDefinitionService,
_repositoryDataSetDetail, _sqlTableUtility);
//act
sut.Create(schematoAdd);
var result = _repositoryDataSetSchema.GetQuery().FirstOrDefault(x => x.Id == 10);
//assert
Assert.AreEqual("sampletitle", result.Title);
//cleanup
_repositoryDataSetSchema.Delete(schematoAdd);
}
private InventoryDatasetResource[] GetResources(Category category, DataSetSchema dataSetSchema)
{
var xList = new List <InventoryDatasetResource>();
if (dataSetSchema.DataSets == null)
{
return(xList.ToArray());
}
var datasets = dataSetSchema.DataSets.ToList();
AddDocumentResource(ref xList, dataSetSchema, category);
AddResource(ref xList, dataSetSchema, category, "csv", datasets, "download", "Download");
AddResource(ref xList, dataSetSchema, category, "xml", datasets, "download", "Download");
AddResource(ref xList, dataSetSchema, category, "json", datasets, "api", "Service");
AddResource(ref xList, dataSetSchema, category, "xml", datasets, "api", "Service");
return(xList.ToArray());
}
public void LoadList_When_schema_is_not_null_and_schemadetail_is_null_returns_view_error()
{
//arrange
DataSetSchema nullobj = null;
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get("schema")).Returns(nullobj);
_datasetschemaservice = mock.Object;
_mockHttpContextBase.SetupGet(x => x.Response).Returns(_mockResponseBase.Object);
var controller = new DownloadController(_datasetschemaservice, _datasetdetailservice, _categoryservice, _systemConfigurationService);
controller.ControllerContext = new ControllerContext(_mockHttpContextBase.Object, new RouteData(), controller);
//act
var result = (ViewResult)controller.Index(null, "schema", null, null, null, null, null, null);
//assert
Assert.AreEqual("Error", result.ViewName);
//cleanup
}
