public string SavecounterParty(CounterParty counterParty) { using (LoanPriceEntities context = new LoanPriceEntities()) { if (counterParty.ID <= 0) { if (context.CounterParties.Where(s => s.Name == counterParty.Name).Count() == 0) { context.AddToCounterParties(counterParty); context.SaveChanges(); return("CounterParty is added successfully"); } else { return("Entry of the same Name is already exists."); } } else { if (context.CounterParties.Where(s => s.Name == counterParty.Name && s.ID != counterParty.ID).Count() == 0) { context.CounterParties.Attach(counterParty); context.ObjectStateManager.ChangeObjectState(counterParty, System.Data.EntityState.Modified); context.SaveChanges(); return("CounterParty is Updated successfully"); } else { return("Entry of the same Name is already exists."); } } } }
public static List <CounterParty> GetCounterParty() { List <CounterParty> list = new List <CounterParty>(); ISheet sheet; HSSFWorkbook hssfwb = new HSSFWorkbook(File.OpenRead(HostingEnvironment.MapPath("~/SeedFiles/CounterParty.xls"))); sheet = hssfwb.GetSheetAt(0); for (int row = 1; row <= sheet.LastRowNum; row++) { CounterParty con = new CounterParty(); if (sheet.GetRow(row) != null) { con.Name = sheet.GetRow(row).GetCell(1).StringCellValue; con.Identifier = sheet.GetRow(row).GetCell(2).StringCellValue; con.PropCode = sheet.GetRow(row).GetCell(3).StringCellValue; con.PipelineID = 0; con.IsActive = sheet.GetRow(row).GetCell(5).NumericCellValue == 0 ? false : true; con.CreatedBy = sheet.GetRow(row).GetCell(6).StringCellValue; con.CreatedDate = DateTime.Now; con.ModifiedBy = sheet.GetRow(row).GetCell(8).StringCellValue; con.ModifiedDate = DateTime.Now; list.Add(con); } } return(list); }
public CounterParty UpdateConterparty(CounterParty counterparty) { counterparty.CounterpartyType = "PrivatePerson"; counterparty.CounterpartyProperty = "Recipient"; var result = _jsonLogic.ModifyObject <CounterParty>("Counterparty", "update", counterparty); return(result); }
public void Delete(int id) { using (LoanPriceEntities context = new LoanPriceEntities()) { CounterParty group = context.CounterParties.FirstOrDefault(c => c.ID == id); if (group != null) { context.CounterParties.DeleteObject(group); context.SaveChanges(); } } }
public int GetcounterPartyFromName(string name) { using (LoanPriceEntities context = new LoanPriceEntities()) { CounterParty group = context.CounterParties.FirstOrDefault(c => c.Name == name); if (group != null) { return(group.ID); } else { return(0); } } }
public UPRD.DTO.CounterPartyDTO Parse(CounterParty item) { UPRD.DTO.CounterPartyDTO cp = new UPRD.DTO.CounterPartyDTO(); cp.ID = item.ID; cp.CreatedBy = item.CreatedBy; cp.Identifier = item.Identifier; cp.IsActive = item.IsActive; cp.ModifiedBy = item.ModifiedBy; cp.ModifiedDate = item.ModifiedDate; cp.Name = item.Name; cp.PipelineID = item.PipelineID; cp.PropCode = item.PropCode; cp.Name = item.Name; return(cp); }
public CounterPartiesDTO Parse(CounterParty item) { CounterPartiesDTO itemObj = new CounterPartiesDTO(); itemObj.ID = item.ID; itemObj.Name = item.Name; itemObj.Identifier = item.Identifier; itemObj.PropCode = item.PropCode; itemObj.PipeDuns = item.PipeDuns; itemObj.IsActive = item.IsActive; itemObj.CreatedBy = item.CreatedBy; itemObj.CreatedDate = item.CreatedDate; itemObj.ModifiedBy = item.ModifiedBy; itemObj.ModifiedDate = item.ModifiedDate; return(itemObj); }
public CounterParty Create(CounterPartyDTO item) { CounterParty C = new CounterParty(); C.ID = item.ID; C.CreatedBy = item.CreatedBy; C.Identifier = item.Identifier; C.IsActive = item.IsActive; C.ModifiedBy = item.ModifiedBy; C.ModifiedDate = item.ModifiedDate; C.Name = item.Name; C.PipelineID = item.PipelineID; C.PropCode = item.PropCode; C.Name = item.Name; return(C); }
public Result <IReadOnlyList <PublisherGame> > GetNewPublisherGamesFromTrade(Instant completionTime) { var dateOfAcquisition = completionTime.ToEasternDate(); var proposerGameDictionary = Proposer.PublisherGames.Where(x => x.MasterGame is not null).ToDictionary(x => x.GetMasterGameYearWithCounterPick() !); var counterPartyGameDictionary = CounterParty.PublisherGames.Where(x => x.MasterGame is not null).ToDictionary(x => x.GetMasterGameYearWithCounterPick() !); List <PotentialPublisherSlot> newlyOpenProposerSlotNumbers = new List <PotentialPublisherSlot>(); foreach (var game in ProposerMasterGames) { var existingPublisherGame = proposerGameDictionary[game]; newlyOpenProposerSlotNumbers.Add(new PotentialPublisherSlot(existingPublisherGame.SlotNumber, game.CounterPick)); } List <PotentialPublisherSlot> newlyOpenCounterPartySlotNumbers = new List <PotentialPublisherSlot>(); foreach (var game in CounterPartyMasterGames) { var existingPublisherGame = counterPartyGameDictionary[game]; newlyOpenCounterPartySlotNumbers.Add(new PotentialPublisherSlot(existingPublisherGame.SlotNumber, game.CounterPick)); } var alreadyOpenProposerSlotNumbers = Proposer.GetPublisherSlots(LeagueYear.Options).Where(x => x.PublisherGame is null).Select(x => new PotentialPublisherSlot(x.SlotNumber, x.CounterPick)); var alreadyOpenCounterPartySlotNumbers = CounterParty.GetPublisherSlots(LeagueYear.Options).Where(x => x.PublisherGame is null).Select(x => new PotentialPublisherSlot(x.SlotNumber, x.CounterPick)); var allOpenProposerSlotNumbers = alreadyOpenProposerSlotNumbers.Concat(newlyOpenProposerSlotNumbers).Distinct().OrderBy(x => x.CounterPick).ThenBy(x => x.SlotNumber).ToList(); var allOpenCounterPartySlotNumbers = alreadyOpenCounterPartySlotNumbers.Concat(newlyOpenCounterPartySlotNumbers).Distinct().OrderBy(x => x.CounterPick).ThenBy(x => x.SlotNumber).ToList(); List <PublisherGame> newPublisherGames = new List <PublisherGame>(); foreach (var game in ProposerMasterGames) { var existingPublisherGame = proposerGameDictionary[game]; var eligibilityFactors = LeagueYear.GetEligibilityFactorsForMasterGame(game.MasterGameYear.MasterGame, dateOfAcquisition); var openSlotNumbers = allOpenCounterPartySlotNumbers.Where(x => x.CounterPick == game.CounterPick).Select(x => x.SlotNumber); var slotResult = SlotEligibilityService.GetTradeSlotResult(CounterParty, LeagueYear.Options, game, eligibilityFactors, openSlotNumbers); if (!slotResult.HasValue) { return(Result.Failure <IReadOnlyList <PublisherGame> >($"Cannot find an appropriate slot for: {game.MasterGameYear.MasterGame.GameName}")); } allOpenCounterPartySlotNumbers = allOpenCounterPartySlotNumbers.Where(x => !(x.SlotNumber == slotResult.Value && x.CounterPick == game.CounterPick)).ToList(); PublisherGame newPublisherGame = new PublisherGame(CounterParty.PublisherID, Guid.NewGuid(), game.MasterGameYear.MasterGame.GameName, completionTime, game.CounterPick, existingPublisherGame.ManualCriticScore, existingPublisherGame.ManualWillNotRelease, existingPublisherGame.FantasyPoints, game.MasterGameYear, slotResult.Value, null, null, null, TradeID); newPublisherGames.Add(newPublisherGame); } foreach (var game in CounterPartyMasterGames) { var existingPublisherGame = counterPartyGameDictionary[game]; var eligibilityFactors = LeagueYear.GetEligibilityFactorsForMasterGame(game.MasterGameYear.MasterGame, dateOfAcquisition); var openSlotNumbers = allOpenProposerSlotNumbers.Where(x => x.CounterPick == game.CounterPick).Select(x => x.SlotNumber); var slotResult = SlotEligibilityService.GetTradeSlotResult(Proposer, LeagueYear.Options, game, eligibilityFactors, openSlotNumbers); if (!slotResult.HasValue) { return(Result.Failure <IReadOnlyList <PublisherGame> >($"Cannot find an appropriate slot for: {game.MasterGameYear.MasterGame.GameName}")); } allOpenProposerSlotNumbers = allOpenProposerSlotNumbers.Where(x => !(x.SlotNumber == slotResult.Value && x.CounterPick == game.CounterPick)).ToList(); PublisherGame newPublisherGame = new PublisherGame(Proposer.PublisherID, Guid.NewGuid(), game.MasterGameYear.MasterGame.GameName, completionTime, game.CounterPick, existingPublisherGame.ManualCriticScore, existingPublisherGame.ManualWillNotRelease, existingPublisherGame.FantasyPoints, game.MasterGameYear, slotResult.Value, null, null, null, TradeID); newPublisherGames.Add(newPublisherGame); } return(newPublisherGames); }