/// <summary> /// Create a new DomesticWHTRate object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="code">Initial value of the Code property.</param> /// <param name="countryId">Initial value of the countryId property.</param> public static DomesticWHTRate CreateDomesticWHTRate(global::System.Int32 id, global::System.String code, global::System.Int32 countryId) { DomesticWHTRate domesticWHTRate = new DomesticWHTRate(); domesticWHTRate.Id = id; domesticWHTRate.Code = code; domesticWHTRate.countryId = countryId; return domesticWHTRate; }
private IEnumerable<PublisherStatus> PublishContent(DataRowCollection contentRows, string sheetName) { var allStatus = new List<PublisherStatus>(); if (contentRows.Count >= 1) { using (var work = new UnitOfWork()) { var countryRepo = RepositoryContainer.GetRepository<Nest.DataAccess.Country>(work); var domesticRateRepo = RepositoryContainer.GetRepository<Nest.DataAccess.DomesticWHTRate>(work); var allCountries = countryRepo.All().ToList(); var dbHostCountry = allCountries.FirstOrDefault(b => b.Code == contentRows[1].ItemArray[0].ToString().Trim()); if (dbHostCountry == null) { allStatus.Add(new PublisherStatus() { Message = "Host Country Name Doesn't Exist In DataBase", Status = false }); allStatus.Add(new PublisherStatus { Status = false, Message = "Data uploading failed for sheet " + sheetName }); return allStatus; } //var conceptIdExistStatus = CheckConceptIdInfo(contentRows); //var idExistStatus = conceptIdExistStatus.ToList(); //allStatus.AddRange(idExistStatus); //if (idExistStatus.Any(b => b.Status == false)) //{ // allStatus.Add(new PublisherStatus // { // Status = false, // Message = "Data uploading failed for sheet " + sheetName // }); // return allStatus; //} // HostCountry = dbHostCountry; if (contentRows.Count >= 2) { for (var index = 1; index < contentRows.Count; index++) { if (string.IsNullOrEmpty(contentRows[index].ItemArray[0].ToString().Trim())) continue; var dbPartenerCountry = allCountries.FirstOrDefault(b => b.Code == contentRows[index].ItemArray[0].ToString().Trim()); if (dbPartenerCountry == null) { allStatus.Add(new PublisherStatus() { Message = "Partner Country Code " + contentRows[index].ItemArray[0].ToString().Trim() + " Doesn't Exist In DataBase", Status = false }); } if (dbPartenerCountry != null) { var dbTpTreaty = domesticRateRepo.Filter(b => b.Code == dbHostCountry.Code).FirstOrDefault(); if (dbTpTreaty == null) { dbTpTreaty = new Nest.DataAccess.DomesticWHTRate(); domesticRateRepo.Add(dbTpTreaty); } dbTpTreaty.Code = contentRows[index].ItemArray[0].ToString().Trim(); dbTpTreaty.countryId = int.Parse(contentRows[index].ItemArray[1].ToString().Trim()); dbTpTreaty.DividendRate = contentRows[index].ItemArray[2].ToString().Trim(); dbTpTreaty.InterestRate = contentRows[index].ItemArray[3].ToString().Trim(); dbTpTreaty.RoyalityRate=contentRows[index].ItemArray[4].ToString().Trim(); } } if (allStatus.Any(b => b.Status == false) == false) { work.SaveChanges(); allStatus.Add(new PublisherStatus() { Message = "Data uploaded sucessfully for sheet " + sheetName, Status = true }); } else { allStatus.Add(new PublisherStatus { Status = false, Message = "Data uploading failed for sheet " + sheetName }); } } } } return allStatus; }
/// <summary> /// Deprecated Method for adding a new object to the DomesticWHTRates EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToDomesticWHTRates(DomesticWHTRate domesticWHTRate) { base.AddObject("DomesticWHTRates", domesticWHTRate); }