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; }