public void SetUp()
{
var cit = new Cit {
Code = "A", Name = "Army of the Undead"
};
this.CitRepository.FindById(Arg.Any <string>()).Returns(cit);
var master = new PtlMaster {
LastFullRunJobref = "CJCAIH", LastFullRunDateTime = new DateTime(2019, 1, 1)
};
this.PtlMasterRepository.GetRecord().Returns(master);
var triggers = new List <ProductionTrigger>
{
new ProductionTrigger {
PartNumber = "A", Description = "A product", Priority = "1"
},
new ProductionTrigger {
PartNumber = "B", Description = "B nice", Priority = "2"
},
new ProductionTrigger {
PartNumber = "C", Description = "C", Priority = "3"
}
};
this.ProductionTriggerQueryRepository.FilterBy(Arg.Any <Expression <Func <ProductionTrigger, bool> > >())
.Returns(triggers.AsQueryable());
this.result = this.Sut.GetProductionTriggerReport("CJCAIH", "A");
}
public ProductionTriggersReport(string jobref, PtlMaster ptlMaster, Cit cit, IQueryRepository <ProductionTrigger> repository)
{
this.PtlMaster = ptlMaster.LastFullRunJobref == jobref ? ptlMaster : null;
this.Cit = cit;
this.Triggers = repository.FilterBy(t => t.Jobref == jobref && t.Citcode == cit.Code).OrderBy(t => t.SortOrder).ThenBy(t => t.EarliestRequestedDate).ThenBy(t => t.PartNumber);
}
public void SetUp()
{
var cit = new Cit {
Code = "S", Name = "Super Team"
};
this.CitRepository.FindById(Arg.Any <string>()).Returns(cit);
this.PtlMasterRepository.GetRecord().Returns(new PtlMaster {
LastFullRunJobref = "AAAAAA"
});
this.result = this.Sut.GetProductionTriggerReport(string.Empty, "S");
}
public static List <eChannelManager> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eChannelManager> ChannelManager = new List <eChannelManager>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
var objTblUser = (from PCM in db.tblPropertyChannelMgrMaps
join U in db.tblUserMs on PCM.iActionBy equals U.iUserId into S1
from Users in S1.DefaultIfEmpty()
join P in db.tblPropertyMs on PCM.iPropId equals P.iPropId into Prop
from Property in Prop.DefaultIfEmpty()
join CM in db.tblChannelMgrMs on PCM.iChannelMgr equals CM.iChannelMgr into ChMgr
from channelmanager in ChMgr.DefaultIfEmpty()
join C in db.tblCityMs on Property.iCityId equals C.iCityId into Cit
from City in Cit.DefaultIfEmpty()
select new
{
PCM.iPropId,
sHotelName = Property.sHotelName + " , " + City.sCity,
channelmanager.sChannelMgrName,
PCM.dtActionDate,
sActionBy = Users.sFirstName + " " + Users.sLastName
}).Distinct().Where(u => u.sHotelName.Contains(param.sSearch) || u.sChannelMgrName.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblUser.Count();
switch (param.iSortingCols)
{
case 0:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sHotelName) : objTblUser.OrderByDescending(u => u.sHotelName);
break;
case 1:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sChannelMgrName) : objTblUser.OrderByDescending(u => u.sChannelMgrName);
break;
}
////implemented paging
//List<tblUserM> lstUser = objTblUser.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
var lstUser = objTblUser.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
ChannelManager.AddRange(lstUser.Select(usr => (eChannelManager)OneFineRateAppUtil.clsUtils.ConvertToObject(usr, new eChannelManager())));
return(ChannelManager);
}
}
public async Task <IActionResult> OnGetAsync(string id)
{
if (id == null)
{
return(NotFound());
}
Cit = this.citRepository.GetByCode(id);
if (Cit == null)
{
return(NotFound());
}
return(Page());
}
public void SetUp()
{
var cit1 = new Cit {
Code = "a", Name = "A"
};
var cit2 = new Cit {
Code = "b", Name = "B"
};
this.CitService.GetAll()
.Returns(new SuccessResult <IEnumerable <Cit> >(new List <Cit> {
cit1, cit2
}));
this.Response = this.Browser.Get(
"/production/maintenance/cits",
with => { with.Header("Accept", "application/json"); }).Result;
}
public void UpdateCit(Cit cit)
{
this.serviceDbContext.Attach(cit).State = EntityState.Modified;
}
