public void Put_WithMockedModel_ShouldBeCalledOnce()
{
// Arrange
var actualId = 8412;
var dummyString = Guid.NewGuid().ToString().Replace("-", "");
var mockRepository = new Mock <IEntryPlatformRepository>();
var dbModel = new EntryPlatformModel()
{
EntryId = 8413,
PlatformId = 8414,
Description = dummyString,
};
mockRepository
.Setup(m => m.Update(dbModel));
var controller = new EntryPlatformController(mockRepository.Object);
// Act
controller.Put(actualId, dbModel);
// Assert
mockRepository
.Verify(m => m.Update(
It.Is <EntryPlatformModel>(
i => i.Id == actualId && i.Description == dummyString)),
Times.Once());
}
public void InsertThenUpdate_ShouldReflectChanges()
{
// Arrange
var expectedValue = "*****@*****.**";
var dummyString = Guid.NewGuid().ToString().Replace("-", "");
var dbModel = new EntryPlatformModel()
{
EntryId = 6,
PlatformId = 1,
Description = dummyString,
};
// Act
var newId = new EntryPlatformRepository(AppState.ConnectionString)
.Insert(dbModel);
var dbModel2 = new EntryPlatformRepository(AppState.ConnectionString)
.Select(newId);
dbModel2.Description = expectedValue;
new EntryPlatformRepository(AppState.ConnectionString)
.Update(dbModel2);
var actualValue = new EntryPlatformRepository(AppState.ConnectionString)
.Select(newId)
.Description;
// Assert
Assert.AreEqual(expectedValue, actualValue);
}
public void Get_WithParameter42_ShouldReturnDbModel()
{
// Arrange
var actualId = 8412;
var mockRepository = new Mock <IEntryPlatformRepository>();
var expectedValue = new EntryPlatformModel()
{
Id = actualId,
EntryId = 8414,
PlatformId = 8415,
Description = "blanditiis"
};
mockRepository
.Setup(m => m.Select(actualId))
.Returns(expectedValue);
var controller = new EntryPlatformController(mockRepository.Object);
// Act
var result = controller.Get(actualId) as JsonResult;
var actualValue = (EntryPlatformModel)result.Value;
// Assert
Assert.AreEqual(expectedValue, actualValue);
}
public int Insert(EntryPlatformModel obj)
{
var storedProc = "sp_insert_entry_platform";
var insertObj = new
{
entry_id = obj.EntryId,
platform_id = obj.PlatformId,
description = obj.Description
};
return(Insert(storedProc, insertObj));
}
public void Update(EntryPlatformModel obj)
{
var storedProc = "sp_update_entry_platform";
var updateObj = new
{
id = obj.Id,
entry_id = obj.EntryId,
platform_id = obj.PlatformId,
description = obj.Description
};
Update(storedProc, updateObj);
}
public void InsertAndSelect_ShouldEqualInserted()
{
// Arrange
var dbModel = new EntryPlatformModel()
{
EntryId = 6,
PlatformId = 1,
Description = "voluptate",
};
var expectedValue = new EntryPlatformRepository(AppState.ConnectionString)
.Insert(dbModel);
// Act
var actualValue = new EntryPlatformRepository(AppState.ConnectionString)
.Select(expectedValue)
.Id;
// Assert
Assert.AreEqual(expectedValue, actualValue);
}
public void Post_WithMockedModel_ShouldReturnNewId()
{
// Arrange
var mockRepository = new Mock <IEntryPlatformRepository>();
var dbModel = new EntryPlatformModel();
var expectedValue = 8412;
mockRepository
.Setup(m => m.Insert(dbModel))
.Returns(expectedValue);
var controller = new EntryPlatformController(mockRepository.Object);
// Act
var result = controller.Post(dbModel) as JsonResult;
var actualValue = (int)result.Value;
// Assert
Assert.AreEqual(expectedValue, actualValue);
}
public void InsertAndDelete_ShouldNoLongerExistAfterDelete()
{
// Arrange
var expectedValue = 0;
var dbModel = new EntryPlatformModel()
{
EntryId = 6,
PlatformId = 1,
Description = "voluptate",
};
// Act
var newId = new EntryPlatformRepository(AppState.ConnectionString).Insert(dbModel);
new EntryPlatformRepository(AppState.ConnectionString).Delete(newId);
var actualValue = new EntryPlatformRepository(AppState.ConnectionString)
.Select(newId)
.Id;
// Assert
Assert.AreEqual(expectedValue, actualValue);
}
private static void Process(int column, string value, EntryModel dbModel, ExcelWorksheet ws)
{
var entryId = 0;
var entry = _entryRepository
.SelectList()
.Where(x => x.CategoryId.Equals(dbModel.CategoryId))
.Where(x => x.SubCategoryId.Equals(dbModel.SubCategoryId))
.Where(x => x.LexiconFunction.Equals(dbModel.LexiconFunction))
.Where(x => x.Recommendation.Equals(dbModel.Recommendation))
.Where(x => x.Notes.Equals(dbModel.Notes))
.FirstOrDefault();
if (entry != null)
{
entryId = entry.Id;
}
if (entryId.Equals(0))
{
entryId = _entryRepository.Insert(dbModel);
}
var platFormName = ws.Cells[_appSettings.PlatformLine, column].Value.ToString();
var playFormId = _platformRepository
.SelectList()
.Where(x => x.Description.Equals(platFormName))
.FirstOrDefault()
.Id;
var entryPlatform = new EntryPlatformModel()
{
Description = value,
EntryId = entryId,
PlatformId = playFormId
};
_entryPlatformRepository.Insert(entryPlatform);
}
public void Put(int id, [FromBody] EntryPlatformModel value)
{
value.Id = id;
EntryPlatformRepository.Update(value);
}
public JsonResult Post([FromBody] EntryPlatformModel value)
{
return(new JsonResult(EntryPlatformRepository.Insert(value)));
}
