public long SaveNote(UserSelectedContext catalogInfo, ListItemModel detail)
{
NotesListHeader header = _headerRepo.GetHeadersForCustomer(catalogInfo);
if (header == null)
{
// Create a new header for the customer
header = new NotesListHeader()
{
BranchId = catalogInfo.BranchId,
CustomerNumber = catalogInfo.CustomerId
};
header.Id = _headerRepo.Save(header);
}
long detailId = 0;
var noteDetail = _detailRepo.Get(header.Id, detail.ItemNumber);
if (noteDetail != null)
{
detailId = noteDetail.Id;
}
return(_detailRepo.Save(detail.ToListModel(header.Id, detailId)));
}
public static ListModel ToListModel(this NotesListHeader header, List <ListItemModel> items)
{
ListModel retVal = ToListModel(header);
retVal.Items = items.ToList();
return(retVal);
}
public static ListModel ToListModel(this NotesListHeader header, List <NotesListDetail> items)
{
ListModel retVal = ToListModel(header);
retVal.Items = items.Select(i => i.ToWebModel())
.ToList();
return(retVal);
}
public ListModel GetList(UserSelectedContext catalogInfo)
{
NotesListHeader header = _headerRepo.GetHeadersForCustomer(catalogInfo);
List <NotesListDetail> details = new List <NotesListDetail>();
if (header != null)
{
details = _detailRepo.GetAll(header.Id);
return(header.ToListModel(details));
}
return(null);
}
public long Save(NotesListHeader header)
{
DynamicParameters parms = new DynamicParameters();
parms.Add(PARMNAME_ID, header.Id);
parms.Add(PARMNAME_BRANCHID, header.BranchId);
parms.Add(PARMNAME_CUSTOMERNUMBER, header.CustomerNumber);
parms.Add(PARMNAME_RETURNVALUE, 0, dbType: DbType.Int64, direction: ParameterDirection.Output);
ExecuteSPCommand(SPNAME_SAVE, parms);
return(parms.Get <long>(PARMNAME_RETURNVALUE));
}
public void GoodHeader_ItemsIsNotNull()
{
// arrange
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel();
// assert
results.Items
.Should()
.NotBeNull();
}
public ListItemModel GetNote(UserSelectedContext catalogInfo, string itemNumber)
{
ListItemModel returnValue = null;
NotesListHeader header = _headerRepo.GetHeadersForCustomer(catalogInfo);
if (header != null)
{
var noteDetail = _detailRepo.Get(header.Id, itemNumber);
returnValue = noteDetail?.ToWebModel();
}
return(returnValue);
}
public void GoodHeader_ReturnsExpectedListId()
{
// arrange
int expected = 15;
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel();
// assert
results.ListId
.Should()
.Be(expected);
}
public void GoodHeader_ReturnsExpectedReadonly()
{
// arrange
bool expected = false;
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel();
// assert
results.ReadOnly
.Should()
.Be(expected);
}
public void GoodHeader_ReturnsExpectedHasContractItems()
{
// arrange
bool expected = false;
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel();
// assert
results.HasContractItems
.Should()
.Be(expected);
}
public void GoodHeader_ReturnsExpectedName()
{
// arrange
string expected = "Notes";
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel();
// assert
results.Name
.Should()
.Be(expected);
}
public void GoodHeader_ReturnsExpectedIsRecommended()
{
// arrange
bool expected = false;
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel();
// assert
results.IsRecommended
.Should()
.Be(expected);
}
public void GoodHeader_ReturnsExpectedCustomerNumber()
{
// arrange
string expected = "123456";
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel();
// assert
results.CustomerNumber
.Should()
.Be(expected);
}
public void GoodHeader_SharedWithIsNotNull()
{
// arrange
NotesListHeader header = MakeHeader();
List <NotesListDetail> details = MakeListOfDetails();
// act
ListModel results = header.ToListModel(details);
// assert
results.SharedWith
.Should()
.NotBeNull();
}
public void GoodHeader_ItemsIsNotNull()
{
// arrange
List <ListItemModel> details = MakeListOfModels();
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel(details);
// assert
results.Items
.Should()
.NotBeNull();
}
public void GoodHeader_ReturnsExpectedType()
{
// arrange
ListType expected = ListType.Notes;
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel();
// assert
results.Type
.Should()
.Be(expected);
}
public List <ListItemModel> GetNotes(UserProfile user, UserSelectedContext catalogInfo)
{
NotesListHeader header = _headerRepo.GetHeadersForCustomer(catalogInfo);
List <ListItemModel> notes = new List <ListItemModel>();
if (header != null)
{
var notedetails = _detailRepo.GetAll(header.Id);
notes = notedetails.Select(d => d.ToWebModel())
.ToList();
}
return(notes);
}
public void GoodHeader_ReturnsExpectedSharedWithCount()
{
// arrange
int expected = 0;
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel();
// assert
results.SharedWith
.Count
.Should()
.Be(expected);
}
public void GoodHeader_ReturnsExpectedName()
{
// arrange
List <ListItemModel> details = MakeListOfModels();
string expected = "Notes";
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel(details);
// assert
results.Name
.Should()
.Be(expected);
}
public void GoodHeader_ReturnsExpectedListId()
{
// arrange
List <ListItemModel> details = MakeListOfModels();
int expected = 15;
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel(details);
// assert
results.ListId
.Should()
.Be(expected);
}
public void GoodHeader_ReturnsGoodHeaderId()
{
// arrange
int expected = 4;
NotesListHeader header = MakeHeader();
INotesHeadersListRepository repo = MakeRepo();
// act
long headerId = repo.Save(header);
// assert
headerId.Should()
.Be(expected);
}
public void GoodHeader_ReturnsExpectedIsWorksheet()
{
// arrange
List <ListItemModel> details = MakeListOfModels();
bool expected = false;
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel(details);
// assert
results.IsWorksheet
.Should()
.Be(expected);
}
public void GoodHeader_ReturnsExpectedIsSharing()
{
// arrange
bool expected = false;
NotesListHeader header = MakeHeader();
List <NotesListDetail> details = MakeListOfDetails();
// act
ListModel results = header.ToListModel(details);
// assert
results.IsSharing
.Should()
.Be(expected);
}
public void GoodHeader_ItemsHasZeroCount()
{
// arrange
int expected = 0;
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel();
// assert
results.Items
.Count
.Should()
.Be(expected);
}
public void GoodHeader_ReturnsExpectedBranchId()
{
// arrange
List <NotesListDetail> details = MakeListOfDetails();
string expected = "FUT";
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel(details);
// assert
results.BranchId
.Should()
.Be(expected);
}
public void NullCustomerNumber_ThrowsSqlException()
{
// arrange
NotesListHeader header = new NotesListHeader {
BranchId = "FRT",
CreatedUtc = new DateTime(2017, 6, 30, 16, 32, 0, DateTimeKind.Utc),
ModifiedUtc = new DateTime(2017, 6, 30, 16, 33, 0, DateTimeKind.Utc)
};
INotesHeadersListRepository repo = MakeRepo();
// act
Action act = () => { repo.Save(header); };
// assert
act.Should().Throw <SqlException>();
}
public void GoodHeader_ItemsHasExpectedCount()
{
// arrange
List <ListItemModel> details = MakeListOfModels();
int expected = 2;
NotesListHeader header = MakeHeader();
// act
ListModel results = header.ToListModel(details);
// assert
results.Items
.Count
.Should()
.Be(expected);
}
public void BadContext_BadBranchIdReturnsNull()
{
// arrange
UserSelectedContext context = new UserSelectedContext()
{
CustomerId = "654321",
BranchId = "XXX"
};
INotesHeadersListRepository repo = MakeRepo();
// act
NotesListHeader results = repo.GetHeadersForCustomer(context);
// assert
results.Should()
.BeNull();
}
public static ListModel ToListModel(this NotesListHeader header)
{
return(new ListModel {
BranchId = header.BranchId,
CustomerNumber = header.CustomerNumber,
IsContractList = false,
IsFavorite = false,
IsWorksheet = false,
IsReminder = false,
IsMandatory = false,
IsRecommended = false,
IsCustomInventory = false,
Type = ListType.Notes,
ListId = header.Id,
Name = LISTNAME_NOTES,
ReadOnly = false
});
}
public void GoodContext_ReturnsExpectedBranchId()
{
// arrange
UserSelectedContext context = new UserSelectedContext()
{
CustomerId = "123456",
BranchId = "FRT"
};
INotesHeadersListRepository repo = MakeRepo();
string expected = "FRT";
// act
NotesListHeader results = repo.GetHeadersForCustomer(context);
// assert
results
.BranchId
.Should()
.Be(expected);
}
