public void GoodItem_HasDefaultValue()
{
// arrange
NotesListDetail detail = new NotesListDetail();
string expected = null;
// act
// assert
detail.Note
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsNullToDate()
{
// arrange
NotesListDetail detail = MakeDetail();
// act
ListItemModel results = detail.ToWebModel();
// assert
results.ToDate
.Should()
.BeNull();
}
public void GoodItem_ReturnsValue()
{
// arrange
NotesListDetail detail = MakeDetail();
string expected = "Scooby Dooby Doo";
// act
// assert
detail.Note
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsNullProprietaryCustomers()
{
// arrange
NotesListDetail detail = MakeDetail();
// act
ListItemModel results = detail.ToWebModel();
// assert
results.ProprietaryCustomers
.Should()
.BeNull();
}
public static NotesListDetail ToListModel(this ListItemModel model, long headerId = 0, long detailId = 0)
{
NotesListDetail item = new NotesListDetail {
CatalogId = model.CatalogId,
Each = model.Each ?? false,
Id = (detailId != 0)? detailId : model.ListItemId,
ItemNumber = model.ItemNumber,
Note = model.Notes,
HeaderId = headerId,
LineNumber = model.Position
};
return(item);
}
public void GoodDetail_ReturnsExpectedCustomInveotryItemId()
{
// arrange
NotesListDetail detail = MakeDetail();
int expected = 0;
// act
ListItemModel results = detail.ToWebModel();
// assert
results.CustomInventoryItemId
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsExpectedCatalogId()
{
// arrange
NotesListDetail detail = MakeDetail();
string expected = "FUT";
// act
ListItemModel results = detail.ToWebModel();
// assert
results.CatalogId
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsExpectedCreatedUtc()
{
// arrange
NotesListDetail detail = MakeDetail();
DateTime expected = new DateTime(2017, 7, 20, 10, 44, 0, DateTimeKind.Utc);
// act
ListItemModel results = detail.ToWebModel();
// assert
results.CreatedUtc
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsQuantityOfZero()
{
// arrange
NotesListDetail detail = MakeDetail();
int expected = 0;
// act
ListItemModel results = detail.ToWebModel();
// assert
results.Quantity
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsExpectedActive()
{
// arrange
NotesListDetail detail = MakeDetail();
bool expected = true;
// act
ListItemModel results = detail.ToWebModel();
// assert
results.Active
.Should()
.Be(expected);
}
public void NullCatalogId_ThrowsSqlException()
{
// arrange
INotesDetailsListRepository repo = MakeRepo();
// act
NotesListDetail detail = MakeDetail();
detail.CatalogId = null;
Action act = () => { repo.Save(detail); };
// assert
act.Should().Throw<SqlException>();
}
public void GoodDetail_ReturnsIsDeleteAsFalse()
{
// arrange
NotesListDetail detail = MakeDetail();
bool expected = false;
// act
ListItemModel results = detail.ToWebModel();
// assert
results.IsDelete
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsExpectedType()
{
// arrange
NotesListDetail detail = MakeDetail();
ListType expected = ListType.Notes;
// act
ListItemModel results = detail.ToWebModel();
// assert
results.Type
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsExpectedPosition()
{
// arrange
NotesListDetail detail = MakeDetail();
int expected = 7;
// act
ListItemModel results = detail.ToWebModel();
// assert
results.Position
.Should()
.Be(expected);
}
public void GoodDetail_ReturnsExpectedItemNumber()
{
// arrange
NotesListDetail detail = MakeDetail();
string expected = "123456";
// act
ListItemModel results = detail.ToWebModel();
// assert
results.ItemNumber
.Should()
.Be(expected);
}
public void GoodModelWithoutHeaderId_ReturnsDefaultedHeaderId()
{
// arrange
int expected = 0;
int headerId = 1;
ListItemModel model = MakeModel();
// act
NotesListDetail results = model.ToListModel();
// assert
results.HeaderId
.Should()
.Be(expected);
}
public void GoodModel_ReturnsExpectedNote()
{
// arrange
string expected = "Fake Note";
int headerId = 1;
ListItemModel model = MakeModel();
// act
NotesListDetail results = model.ToListModel();
// assert
results.Note
.Should()
.Be(expected);
}
public void GoodModel_ReturnsExpectedLineNumber()
{
// arrange
int expected = 23;
int headerId = 1;
ListItemModel model = MakeModel();
// act
NotesListDetail results = model.ToListModel();
// assert
results.LineNumber
.Should()
.Be(expected);
}
public void GoodModel_ReturnsExpectedEach()
{
// arrange
bool expected = true;
int headerId = 1;
ListItemModel model = MakeModel();
// act
NotesListDetail results = model.ToListModel();
// assert
results.Each
.Should()
.Be(expected);
}
public static ListItemModel ToWebModel(this NotesListDetail value)
{
return(new ListItemModel {
Active = true,
ListItemId = value.Id,
Type = ListType.Notes,
ItemNumber = value.ItemNumber,
Notes = value.Note,
Each = value.Each ?? false,
CatalogId = value.CatalogId,
Position = value.LineNumber,
ModifiedUtc = value.ModifiedUtc,
CreatedUtc = value.CreatedUtc
});
}
public void PartialDetail_ReturnsNullEach() {
// arrange
INotesDetailsListRepository repo = MakeRepo();
// act
NotesListDetail detail = MakeDetail();
detail.Each = null;
repo.Save(detail);
List<NotesListDetail> details = repo.GetAll(GOOD_HEADER_ID);
// assert
details.First(x => x.ItemNumber.Equals(NEW_ITEM_NUMBER))
.Each
.Should()
.BeNull();
}
public long Save(NotesListDetail detail)
{
DynamicParameters parms = new DynamicParameters();
parms.Add(PARMNAME_ID, detail.Id);
parms.Add(PARMNAME_HEADERID, detail.HeaderId);
parms.Add(PARMNAME_ITEMNUMBER, detail.ItemNumber);
parms.Add(PARMNAME_EACH, detail.Each);
parms.Add(PARMNAME_CATALOGID, detail.CatalogId);
parms.Add(PARMNAME_NOTE, detail.Note);
parms.Add(PARMNAME_LINENUMBER, detail.LineNumber);
parms.Add(PARMNAME_RETURNVALUE, direction: ParameterDirection.Output, dbType: DbType.Int64);
ExecuteSPCommand(SPNAME_SAVE, parms);
return(parms.Get <long>(PARMNAME_RETURNVALUE));
}
