private async Task <Aatf> CreateAatf(DatabaseWrapper database, FacilityType facilityType, DateTime date, short year, string approvalNumber = null, string name = null) { var country = database.WeeeContext.Countries.First(); var competentAuthorityDataAccess = new CommonDataAccess(database.WeeeContext); var competentAuthority = await competentAuthorityDataAccess.FetchCompetentAuthority(CompetentAuthority.England); var organisation = Organisation.CreatePartnership("Dummy"); var contact = new AatfContact("First Name", "Last Name", "Manager", "1 Address Lane", "Address Ward", "Town", "County", "Postcode", country, "01234 567890", "*****@*****.**"); if (approvalNumber == null) { approvalNumber = "12345678"; } if (name == null) { name = "name"; } return(new Aatf(name, competentAuthority, approvalNumber, AatfStatus.Approved, organisation, AddressHelper.GetAatfAddress(database), A.Fake <AatfSize>(), date, contact, facilityType, year, database.WeeeContext.LocalAreas.First(), database.WeeeContext.PanAreas.First())); }
public async Task GetAatfsDataAccess_ReturnsAatfsList() { using (var database = new DatabaseWrapper()) { var helper = new ModelHelper(database.Model); var dataAccess = new GetAatfsDataAccess(database.WeeeContext); var genericDataAccess = new GenericDataAccess(database.WeeeContext); var competentAuthorityDataAccess = new CommonDataAccess(database.WeeeContext); var competentAuthority = await competentAuthorityDataAccess.FetchCompetentAuthority(CompetentAuthority.England); var country = await database.WeeeContext.Countries.SingleAsync(c => c.Name == "UK - England"); var aatfContact = new AatfContact("first", "last", "position", "address1", "address2", "town", "county", "postcode", country, "telephone", "email"); var organisation = Organisation.CreatePartnership("Koalas"); var aatfAddress = AddressHelper.GetAatfAddress(database); var aatfSize = AatfSize.Large; var aatf = ObligatedWeeeIntegrationCommon.CreateAatf(database, organisation); await genericDataAccess.Add <Aatf>(aatf); var aatfList = await dataAccess.GetAatfs(); aatfList.Should().Contain(aatf); } }
public IEnumerable <SelectListItem> GetMedioSelectionList() { using (var context = new CCEntities()) { var commonDA = new CommonDataAccess(context); return(commonDA.GetMedioSelectionList()); } }
public ProjectHandler(ProjectDataAccess projectDataAccess, CommonDataAccess commonDataAccess) { _projectDataAccess = projectDataAccess; _commonDataAccess = commonDataAccess; _statusDictionary = _commonDataAccess.GetConstant("Status"); _roleDictionary = _commonDataAccess.GetConstant("Role"); }
public IEnumerable <SelectListItem> GetSubcategoriaSelectionListByIdCategoria(int idCategoria) { using (var context = new CCEntities()) { var commonDA = new CommonDataAccess(context); return(commonDA.GetSubcategoriaSelectionListByIdCategoria(idCategoria)); } }
public async Task GetAatfsDataAccess_ReturnsLatestAesList() { using (var database = new DatabaseWrapper()) { var helper = new ModelHelper(database.Model); var dataAccess = new GetAatfsDataAccess(database.WeeeContext); var genericDataAccess = new GenericDataAccess(database.WeeeContext); var competentAuthorityDataAccess = new CommonDataAccess(database.WeeeContext); var competentAuthority = await competentAuthorityDataAccess.FetchCompetentAuthority(CompetentAuthority.England); var country = await database.WeeeContext.Countries.SingleAsync(c => c.Name == "UK - England"); var aatfContact = new AatfContact("first", "last", "position", "address1", "address2", "town", "county", "postcode", country, "telephone", "email"); var organisation = Organisation.CreatePartnership("Koalas"); var aatfAddress = AddressHelper.GetAatfAddress(database); var aatfSize = AatfSize.Large; var aatfId = Guid.NewGuid(); var aatf = new Aatf("KoalaBears", competentAuthority, "WEE/AB1289YZ/ATF", AatfStatus.Approved, organisation, aatfAddress, aatfSize, DateTime.Now, aatfContact, FacilityType.Ae, 2019, database.WeeeContext.LocalAreas.First(), database.WeeeContext.PanAreas.First(), aatfId); var aatf1 = new Aatf("KoalaBears", competentAuthority, "WEE/AB1289YZ/ATF", AatfStatus.Approved, organisation, aatfAddress, aatfSize, Convert.ToDateTime("20/01/2020"), aatfContact, FacilityType.Ae, 2020, database.WeeeContext.LocalAreas.First(), database.WeeeContext.PanAreas.First(), aatfId); await genericDataAccess.AddMany <Aatf>(new List <Aatf>() { aatf1, aatf }); var aatfList = await dataAccess.GetLatestAatfs(); aatfList.Should().Contain(aatf1); aatfList.Should().NotContain(aatf); } }
public async Task GetFilteredAatfsDataAccess_ByName_ReturnsFilteredAatfsList() { using (var database = new DatabaseWrapper()) { var helper = new ModelHelper(database.Model); var dataAccess = new GetAatfsDataAccess(database.WeeeContext); var genericDataAccess = new GenericDataAccess(database.WeeeContext); var competentAuthorityDataAccess = new CommonDataAccess(database.WeeeContext); var competentAuthority = await competentAuthorityDataAccess.FetchCompetentAuthority(CompetentAuthority.England); var country = await database.WeeeContext.Countries.SingleAsync(c => c.Name == "UK - England"); var aatfContact = new AatfContact("first", "last", "position", "address1", "address2", "town", "county", "postcode", country, "telephone", "email"); var organisation = Organisation.CreatePartnership("Koalas"); var aatfAddress = AddressHelper.GetAatfAddress(database); var aatfSize = AatfSize.Large; var aatf = new Aatf("KoalaBears", competentAuthority, "WEE/AB1289YZ/ATF", AatfStatus.Approved, organisation, aatfAddress, aatfSize, DateTime.Now, aatfContact, FacilityType.Aatf, 2019, database.WeeeContext.LocalAreas.First(), database.WeeeContext.PanAreas.First()); await genericDataAccess.Add <Aatf>(aatf); var filteredListWithAatf = await dataAccess.GetFilteredAatfs(new Core.AatfReturn.AatfFilter { Name = "k" }); var filteredListWithoutAatf = await dataAccess.GetFilteredAatfs(new Core.AatfReturn.AatfFilter { Name = "z" }); filteredListWithAatf.Should().Contain(aatf); filteredListWithoutAatf.Should().NotContain(aatf); } }
public void GetDataforEmployeecard() { LogManager.WriteLog("[GetDataforEmployeecard]- Start", LogManager.enumLogLevel.Info); DataTable dtEMPCard; int Message_ID = 0; try { dtEMPCard = CommonDataAccess.GetEmployeeCardPollingData(); LogManager.WriteLog("[GetDataforEmployeecard] | Number of Employeecards to Process: " + dtEMPCard.Rows.Count.ToString(), LogManager.enumLogLevel.Info); if ((dtEMPCard == null) || (dtEMPCard.Rows.Count == 0)) { LogManager.WriteLog("No cards to be broadcasted", LogManager.enumLogLevel.Info); return; } foreach (DataRow row in dtEMPCard.Rows) { EmployeeMasterCardThreadData threadData = new EmployeeMasterCardThreadData() { EmployeeCardNo = row["EmployeeCard"].ToString(), EmployeeFlags = row["EmployeeFlags"].ToString(), InstallationNo = Convert.ToInt32(row["Installation_No"]) }; bool canAdd = true; Message_ID = EmployeecardSend(threadData.EmployeeCardNo, threadData.EmployeeFlags, threadData.InstallationNo); LogManager.WriteLog("GetDataforEmployeecard | Master card Information " + threadData.EmployeeCardNo.ToString() + "sent to Installation: " + threadData.InstallationNo.ToString() + ", MessageID: " + Message_ID.ToString() , LogManager.enumLogLevel.Info); if (canAdd) { threadData.MessageID = Message_ID; if (!_requestCollection.ContainsKey(Message_ID)) { _requestCollection.Add(Message_ID, threadData); } } } LogManager.WriteLog("[GetDataforEmployeecard]- End", LogManager.enumLogLevel.Info); } catch (Exception Ex) { ExceptionManager.Publish(Ex); } }
//public List<DocumentTypeEntity> GetActiveDocumentTypes(int documentCategory) //{ // _commonDataAccess = new CommonDataAccess(_context); // return _commonDataAccess.GetActiveDocumentTypes(documentCategory); //} //public List<DocumentTypeEntity> GetDocumentTypeList(List<AttachmentTypeEntity> attachTypes, int documentCategory) //{ // _commonDataAccess = new CommonDataAccess(_context); // return _commonDataAccess.GetDocumentTypeList(attachTypes, documentCategory); //} //public IEnumerable<BranchEntity> GetBranchList(BranchSearchFilter searchFilter) //{ // _commonDataAccess = new CommonDataAccess(_context); // return _commonDataAccess.GetBranchList(searchFilter); //} //public List<BranchEntity> GetBranchesByName(string searchTerm, int pageSize, int pageNum) //{ // _commonDataAccess = new CommonDataAccess(_context); // return _commonDataAccess.GetBranchesByName(searchTerm, pageSize, pageNum); //} //public int GetBranchCountByName(string searchTerm, int pageSize, int pageNum) //{ // _commonDataAccess = new CommonDataAccess(_context); // return _commonDataAccess.GetBranchCountByName(searchTerm, pageSize, pageNum); //} //public List<BranchEntity> GetBranchesByName(string searchTerm, int pageSize, int pageNum, int? userId) //{ // _commonDataAccess = new CommonDataAccess(_context); // return _commonDataAccess.GetBranchesByName(searchTerm, pageSize, pageNum, userId); //} //public int GetBranchCountByName(string searchTerm, int pageSize, int pageNum, int? userId) //{ // _commonDataAccess = new CommonDataAccess(_context); // return _commonDataAccess.GetBranchCountByName(searchTerm, pageSize, pageNum, userId); //} //public ParameterEntity GetCacheParamByName(string paramName) //{ // List<ParameterEntity> parameters = this.GetCacheParameters(); // return parameters.FirstOrDefault(x => x.ParamName.ToUpper(CultureInfo.InvariantCulture).Equals(paramName.ToUpper(CultureInfo.InvariantCulture))); //} //public ParameterEntity GetParamByName(string paramName) //{ // _commonDataAccess = new CommonDataAccess(_context); // return _commonDataAccess.GetParamByName(paramName); //} //public string GetValueParamByName(string paramName) //{ // var parameter = GetCacheParamByName(paramName); // return parameter != null ? parameter.ParamValue : string.Empty; //} //public string GetDescParamByName(string paramName) //{ // var parameter = GetCacheParamByName(paramName); // return parameter != null ? parameter.ParamDesc : string.Empty; //} //public IDictionary<string, string> GetCustomerProductSelectList() //{ // return this.GetCustomerProductSelectList(null); //} //public IDictionary<string, string> GetCustomerProductSelectList(string textName, int? textValue = null) //{ // IDictionary<string, string> dic = new Dictionary<string, string>(); // if (!string.IsNullOrWhiteSpace(textName)) // { // dic.Add(textValue.ConvertToString(), textName); // } // dic.Add(Constants.CustomerProduct.Loan, Resource.Ddl_CustomerProduct_Loan); // dic.Add(Constants.CustomerProduct.Funding, Resource.Ddl_CustomerProduct_Funding); // dic.Add(Constants.CustomerProduct.HP, Resource.Ddl_CustomerProduct_HP); // dic.Add(Constants.CustomerProduct.Insurance, Resource.Ddl_CustomerProduct_Insurance); // return dic; //} //public IDictionary<string, string> GetCustomerTypeSelectList() //{ // return this.GetCustomerTypeSelectList(null); //} //public IDictionary<string, string> GetCustomerTypeSelectList(string textName, int? textValue = null) //{ // IDictionary<string, string> dic = new Dictionary<string, string>(); // if (!string.IsNullOrWhiteSpace(textName)) // { // dic.Add(textValue.ConvertToString(), textName); // } // dic.Add(Constants.CustomerType.Customer.ToString(CultureInfo.InvariantCulture), Resource.Ddl_CustomerType_Customer); // dic.Add(Constants.CustomerType.Prospect.ToString(CultureInfo.InvariantCulture), Resource.Ddl_CustomerType_Prospect); // dic.Add(Constants.CustomerType.Employee.ToString(CultureInfo.InvariantCulture), Resource.Ddl_CustomerType_Employee); // return dic; //} public IDictionary <string, string> GetPrefixNameSelectList() { _commonDataAccess = new CommonDataAccess(_context); var lst = _commonDataAccess.GetPrefixNameActive(); return((from x in lst select new { key = x.PrefixNameId.ToString(), value = x.PrefixName }).ToDictionary(t => t.key, t => t.value)); }
public async Task GetCompetentAuthorityById_AuthorityShouldBeReturned(Guid id, string abbreviation) { using (var database = new DatabaseWrapper()) { var helper = new ModelHelper(database.Model); var dataAccess = new CommonDataAccess(database.WeeeContext); var result = await dataAccess.FetchCompetentAuthorityById(id); result.Abbreviation.Should().Be(abbreviation); } }
public async Task FetchnvoicedMemberUploadsAsync_WithSpecifiedAuthority_OOnlyReturnsInvoicedMemberUploadsForTheSpecifiedAuthority() { using (DatabaseWrapper wrapper = new DatabaseWrapper()) { // Arrange ModelHelper helper = new ModelHelper(wrapper.Model); AspNetUser user = helper.GetOrCreateUser("TestUser"); Weee.Tests.Core.Model.Country country = new Weee.Tests.Core.Model.Country(); country.Id = new Guid("FA20ED45-5488-491D-A117-DFC09C9C1BA2"); country.Name = "Test Country"; CompetentAuthority databaseAuthority1 = new CompetentAuthority(); databaseAuthority1.Id = new Guid("DDE398F6-809E-416D-B70D-B36606F221FC"); databaseAuthority1.Name = "Test Authority 1"; databaseAuthority1.Abbreviation = "T1"; databaseAuthority1.Country = country; databaseAuthority1.Email = "TestEmailAddress"; databaseAuthority1.AnnualChargeAmount = 0; wrapper.Model.CompetentAuthorities.Add(databaseAuthority1); InvoiceRun invoiceRunForAuthority1 = new InvoiceRun(); invoiceRunForAuthority1.Id = new Guid("CE7A2617-AE16-403E-A7BF-BF01AD223872"); invoiceRunForAuthority1.CompetentAuthority = databaseAuthority1; invoiceRunForAuthority1.IssuedByUserId = user.Id; invoiceRunForAuthority1.IssuedDate = new DateTime(2015, 1, 1); wrapper.Model.InvoiceRuns.Add(invoiceRunForAuthority1); var scheme = helper.CreateScheme(); scheme.CompetentAuthorityId = databaseAuthority1.Id; var memberUpload = helper.CreateSubmittedMemberUpload(scheme, invoiceRunForAuthority1); wrapper.Model.SaveChanges(); UKCompetentAuthority domainAuthority1 = wrapper.WeeeContext.UKCompetentAuthorities.Find(databaseAuthority1.Id); CommonDataAccess dataAccess = new CommonDataAccess(wrapper.WeeeContext); // Act IReadOnlyList <Domain.Scheme.MemberUpload> results = await dataAccess.FetchInvoicedMemberUploadsAsync(domainAuthority1); // Assert Assert.NotNull(results); Assert.Equal(1, results.Count); Assert.Equal(memberUpload.Id, results[0].Id); } }
public static List <Employeecarddata> GetEmployeeCardPollingData() { DataTable dtEmpcard = CommonDataAccess.GetEmployeeCardPollingData(); List <Employeecarddata> empcardData = new List <Employeecarddata>(); foreach (DataRow row in dtEmpcard.Rows) { empcardData.Add(new Employeecarddata { EmployeeCard = row["EmployeeCard"].ToString(), //EMPCardEDType=Convert.ToInt32( row["EMPCard_ED_Type"]), EmployeeFlags = row["EmployeeFlags"].ToString(), Installation_No = Convert.ToInt32(row["Installation_No"]) }); //PollingStatus =Convert.ToBoolean(row["Polling_Status"]) } return(empcardData); }
public List <PrefixNameEntity> AutoCompleteSearchPrefixName(string keyword, int limit) { _commonDataAccess = new CommonDataAccess(_context); var query = _context.MS_PREFIX_NAME.AsQueryable(); query = query.Where(q => q.active_status == Constants.ApplicationStatus.Active); if (!string.IsNullOrEmpty(keyword)) { query = query.Where(q => q.prefix_name.Contains(keyword)); } query = query.OrderBy(q => q.prefix_name); return(query.Take(limit).Select(item => new PrefixNameEntity { PrefixNameId = item.prefix_name_id, PrefixName = item.prefix_name }).ToList()); }
public async Task Remove_GivenNullEntity_EntityStateShouldNotBeUpdated() { using (var database = new DatabaseWrapper()) { var dataAccess = new GenericDataAccess(database.WeeeContext); var competentAuthorityDataAccess = new CommonDataAccess(database.WeeeContext); var organisation = Organisation.CreateSoleTrader("Test Organisation"); var aatf = ObligatedWeeeIntegrationCommon.CreateAatf(database, organisation); database.WeeeContext.Aatfs.Add(ObligatedWeeeIntegrationCommon.CreateAatf(database, organisation)); await database.WeeeContext.SaveChangesAsync(); dataAccess.Remove <Aatf>(null); database.WeeeContext.ChangeTracker.Entries().Count(e => e.State == EntityState.Deleted).Should().Be(0); } }
public bool Parse(int formId, int formNo) { string tableName = string.Format("tb_{0}", formId); Object obj = CommonDataAccess.GetColomnValue(ConditionSubField, tableName, formNo);; if (obj != null) { string columnType = CommonDataAccess.GetColumnType(tableName, ConditionSubField); Compare compare = (Compare)Assembly.Load("SimpleFlow.BusinessRules").CreateInstance("SimpleFlow.BusinessRules.Compare" + columnType.ToUpper()); compare.VariableA = obj; compare.VariableB = ConditionSubValue; compare.Operator = ConditionSubOperator; return(compare.GetResult()); } return(false); }
private async Task <Aatf> CreateAatf(DatabaseWrapper database, Organisation organisation, DateTime?approvalDate) { var competentAuthorityDataAccess = new CommonDataAccess(database.WeeeContext); var country = await database.WeeeContext.Countries.SingleAsync(c => c.Name == "France"); var competentAuthority = await competentAuthorityDataAccess.FetchCompetentAuthority(CompetentAuthority.England); var aatf = ObligatedWeeeIntegrationCommon.CreateAatf(database, organisation); if (!approvalDate.HasValue) { aatf.UpdateDetails("name", competentAuthority, "12345678", AatfStatus.Approved, organisation, AatfSize.Large, null, aatf.LocalArea, aatf.PanArea); } database.WeeeContext.Aatfs.Add(aatf); await database.WeeeContext.SaveChangesAsync(); return(aatf); }
protected virtual void Dispose(bool disposing) { if (this.disposed) { return; } if (disposing) { if (this.instance != null) { this.instance.Dispose(); this.instance = null; } ////Clean all memeber and release resource. } // Free any unmanaged objects here. disposed = true; }
private async Task <List <Aatf> > CreateMultipleAatf(DatabaseWrapper database, FacilityType facilityType, DateTime date, short year) { var country = database.WeeeContext.Countries.First(); var competentAuthorityDataAccess = new CommonDataAccess(database.WeeeContext); var competentAuthority = await competentAuthorityDataAccess.FetchCompetentAuthority(CompetentAuthority.England); var organisation = Organisation.CreatePartnership("Dummy"); var contact = new AatfContact("First Name", "Last Name", "Manager", "1 Address Lane", "Address Ward", "Town", "County", "Postcode", country, "01234 567890", "*****@*****.**"); var aatfList = new List <Aatf>(); aatfList.Add(new Aatf("B", competentAuthority, "12345678", AatfStatus.Approved, organisation, AddressHelper.GetAatfAddress(database), A.Fake <AatfSize>(), date, contact, facilityType, year, database.WeeeContext.LocalAreas.First(), database.WeeeContext.PanAreas.First())); aatfList.Add(new Aatf("A", competentAuthority, "12345679", AatfStatus.Approved, organisation, AddressHelper.GetAatfAddress(database), A.Fake <AatfSize>(), date, contact, facilityType, year, database.WeeeContext.LocalAreas.First(), database.WeeeContext.PanAreas.First())); return(aatfList); }
public void ProcessResponse(EmployeeMasterCardThreadDataResponse threadData) { if (_requestCollection.Count <= 0) { return; } lock (_lockRes) { if (_requestCollection.ContainsKey(threadData.MessageID)) { EmployeeMasterCardThreadData Requestitem = _requestCollection[threadData.MessageID]; if (threadData.Ack) { CommonDataAccess.UpdateEmployeeCardPolling(Requestitem.EmployeeCardNo, Requestitem.InstallationNo); LogManager.WriteLog("ProcessResponse_EmployeeMasterCard | ACK Updated for EmployeeCard:" + Requestitem.EmployeeCardNo.ToString() + "| in Installation No " + Requestitem.InstallationNo.ToString() , LogManager.enumLogLevel.Info); } else { LogManager.WriteLog("ProcessResponse_EmployeeMasterCard | NACK received for EmployeeCard:" + Requestitem.EmployeeCardNo.ToString() + "| in Installation No " + Requestitem.InstallationNo.ToString() , LogManager.enumLogLevel.Info); } _emppollingCollection.Add(new Employeecarddata { EmployeeCard = Requestitem.EmployeeCardNo, Installation_No = Requestitem.InstallationNo, PollingStatus = threadData.Ack }); _requestCollection.Remove(threadData.MessageID); } } }
public async Task FetchLookup_GivenId_ObjectIsRetrieved(string objectType, string id, string name) { using (var database = new DatabaseWrapper()) { var helper = new ModelHelper(database.Model); var dataAccess = new CommonDataAccess(database.WeeeContext); if (objectType == "LocalArea") { var result = await dataAccess.FetchLookup <LocalArea>(Guid.Parse(id)); result.Name.Should().Be(name); } else if (objectType == "PanArea") { var result = await dataAccess.FetchLookup <PanArea>(Guid.Parse(id)); result.Name.Should().Be(name); } } }
private void LoadFilterData() { LogManager.WriteLog("UCAnalysisDetails:GetActiveZones", LogManager.enumLogLevel.Info); DataTable dt_zones = new CommonDataAccess().GetActiveZones(); DataRow drMc = dt_zones.NewRow(); drMc["Zone_No"] = -1; drMc["Zone_Name"] = "-- All Machines --"; dt_zones.Rows.InsertAt(drMc, 0); if (dt_zones.Rows.Count > 0) { dt_zones.DefaultView.Sort = "Zone_Name"; cmbFilter.ItemsSource = ((System.ComponentModel.IListSource)dt_zones).GetList(); } cmbFilter.DataContext = dt_zones; cmbFilter.DisplayMemberPath = "Zone_Name"; cmbFilter.SelectedValuePath = "Zone_No"; cmbFilter.SelectedIndex = 0; cmbView.Items.Add("Position"); cmbView.Items.Add("Zone"); cmbView.SelectedIndex = 0; }
public async Task FetchSubmittedNonInvoicedMemberUploadsAsync_WithSpecifiedAuthority_OnlyReturnsNonInvoicedMemberUploadsForTheSpecifiedAuthority() { using (DatabaseWrapper wrapper = new DatabaseWrapper()) { // Arrange ModelHelper helper = new ModelHelper(wrapper.Model); Weee.Tests.Core.Model.Country country = new Weee.Tests.Core.Model.Country(); country.Id = new Guid("FA20ED45-5488-491D-A117-DFC09C9C1BA2"); country.Name = "Test Country"; CompetentAuthority databaseAuthority1 = new CompetentAuthority(); databaseAuthority1.Id = new Guid("DDE398F6-809E-416D-B70D-B36606F221FC"); databaseAuthority1.Name = "Test Authority 1"; databaseAuthority1.Abbreviation = "T1"; databaseAuthority1.Country = country; databaseAuthority1.Email = "TestEmailAddress"; wrapper.Model.CompetentAuthorities.Add(databaseAuthority1); var scheme = helper.CreateScheme(); scheme.CompetentAuthorityId = databaseAuthority1.Id; var memberUpload = helper.CreateSubmittedMemberUpload(scheme); wrapper.Model.SaveChanges(); UKCompetentAuthority domainAuthority1 = wrapper.WeeeContext.UKCompetentAuthorities.Find(databaseAuthority1.Id); CommonDataAccess dataAccess = new CommonDataAccess(wrapper.WeeeContext); // Act IReadOnlyList<Domain.Scheme.MemberUpload> results = await dataAccess.FetchSubmittedNonInvoicedMemberUploadsAsync(domainAuthority1); // Assert Assert.NotNull(results); Assert.Equal(1, results.Count); Assert.Equal(memberUpload.Id, results[0].Id); } }
public DataTable GetWeekCollectionSummary() { DataTable dtWeekSummary = new DataTable(); string SiteCode = CommonDataAccess.GetSettingValue("TICKET_LOCATION_CODE"); string EnterpriseURL = GetEnterpriseURL(); int NoOfRecords = int.Parse(ConfigManager.Read("NoOfRecords")); Proxy WebProxy = new Proxy(SiteCode); try { dtWeekSummary = WebProxy.GetWeeklyCollectionDetails(SiteCode, 0, NoOfRecords); foreach (DataRow dr in dtWeekSummary.Rows) { dr["StartDate"] += " - " + dr["EndDate"].ToString(); } } catch (Exception ex) { ExceptionManager.Publish(ex); dtWeekSummary = new DataTable(); } return(dtWeekSummary); }
public static int CreateId(string type) { return(CommonDataAccess.CreateId(type)); }
public async Task FetchnvoicedMemberUploadsAsync_WithSpecifiedAuthority_OOnlyReturnsInvoicedMemberUploadsForTheSpecifiedAuthority() { using (DatabaseWrapper wrapper = new DatabaseWrapper()) { // Arrange ModelHelper helper = new ModelHelper(wrapper.Model); AspNetUser user = helper.GetOrCreateUser("TestUser"); Weee.Tests.Core.Model.Country country = new Weee.Tests.Core.Model.Country(); country.Id = new Guid("FA20ED45-5488-491D-A117-DFC09C9C1BA2"); country.Name = "Test Country"; CompetentAuthority databaseAuthority1 = new CompetentAuthority(); databaseAuthority1.Id = new Guid("DDE398F6-809E-416D-B70D-B36606F221FC"); databaseAuthority1.Name = "Test Authority 1"; databaseAuthority1.Abbreviation = "T1"; databaseAuthority1.Country = country; databaseAuthority1.Email = "TestEmailAddress"; wrapper.Model.CompetentAuthorities.Add(databaseAuthority1); InvoiceRun invoiceRunForAuthority1 = new InvoiceRun(); invoiceRunForAuthority1.Id = new Guid("CE7A2617-AE16-403E-A7BF-BF01AD223872"); invoiceRunForAuthority1.CompetentAuthority = databaseAuthority1; invoiceRunForAuthority1.IssuedByUserId = user.Id; invoiceRunForAuthority1.IssuedDate = new DateTime(2015, 1, 1); wrapper.Model.InvoiceRuns.Add(invoiceRunForAuthority1); var scheme = helper.CreateScheme(); scheme.CompetentAuthorityId = databaseAuthority1.Id; var memberUpload = helper.CreateSubmittedMemberUpload(scheme, invoiceRunForAuthority1); wrapper.Model.SaveChanges(); UKCompetentAuthority domainAuthority1 = wrapper.WeeeContext.UKCompetentAuthorities.Find(databaseAuthority1.Id); CommonDataAccess dataAccess = new CommonDataAccess(wrapper.WeeeContext); // Act IReadOnlyList<Domain.Scheme.MemberUpload> results = await dataAccess.FetchInvoicedMemberUploadsAsync(domainAuthority1); // Assert Assert.NotNull(results); Assert.Equal(1, results.Count); Assert.Equal(memberUpload.Id, results[0].Id); } }
private void btnTosRun_Click(object sender, EventArgs e) { var ret = MessageBox.Show(ConfigurationManager.ConnectionStrings["OracleConnection"].ToString(), "确认数据库连接", MessageBoxButtons.YesNo); if (ret != System.Windows.Forms.DialogResult.Yes) return; try { CM.TOS.V4.Common.TOSFramework.Start(); Thread.GetDomain().SetData(".appPath", @"c:\Test"); Thread.GetDomain().SetData(".appVPath", "/"); TextWriter tw = new StringWriter(); string address = "http://www.cmhit.com/"; HttpWorkerRequest wr = new TestWorkerRequest("login.aspx", null, tw, address); HttpContext.Current = new HttpContext(wr); // 构造 HTTP 调用上下文对象 HttpContext ctxt = new HttpContext(wr); using (CM.CTOS.Common.Core.TosRuntimeContext context = CM.CTOS.Common.Core.TosSessionRuntime.InitializeRuntime( CM.CTOS.Utility.LoginUserInfo.TicketIDInitValue, "SQL", Guid.NewGuid().ToString(), "127.0.0.1")) { using (CM.CTOS.Common.Data.IPsersistenceToken token = CM.CTOS.Common.Core.TosSessionRuntime.CurrentContext.PreparePersistContext()) { CommonDataAccess cda = new CommonDataAccess(); var db = cda.db; var cmd = db.GetSqlStringCommand(this.txtsql.Text); int i = cda.TosExecuteNonQuery(cmd); token.EndTransaction(); MessageBox.Show("OK - 执行成功行数:" + i.ToString()); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { CM.TOS.V4.Common.TOSFramework.End(); } }
public async Task <IActionResult> GetOrderDetails([FromHeader(Name = "Grid-Authorization-Token")] string token, [FromRoute] int orderID) { try { if (string.IsNullOrEmpty(token)) { return(Ok(new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = true, Message = EnumExtensions.GetDescription(CommonErrors.TokenEmpty) })); } AdminUsersDataAccess _adminUsersDataAccess = new AdminUsersDataAccess(_iconfiguration); DatabaseResponse tokenAuthResponse = await _adminUsersDataAccess.AuthenticateAdminUserToken(token); if (tokenAuthResponse.ResponseCode == (int)DbReturnValue.AuthSuccess) { if (!((AuthTokenResponse)tokenAuthResponse.Results).IsExpired) { if (!ModelState.IsValid) { return(StatusCode((int)HttpStatusCode.OK, new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = true, Message = string.Join("; ", ModelState.Values .SelectMany(x => x.Errors) .Select(x => x.ErrorMessage)) })); } CommonDataAccess commonData = new CommonDataAccess(_iconfiguration); var orderList = await commonData.GetOrderDetails(orderID); if (orderList == null || orderList.OrderID == 0) { return(Ok(new ServerResponse { HasSucceeded = false, Message = EnumExtensions.GetDescription(DbReturnValue.NotExists) })); } else { // DownloadFile DatabaseResponse awsConfigResponse = await commonData.GetConfiguration(ConfiType.AWS.ToString()); if (awsConfigResponse != null && awsConfigResponse.ResponseCode == (int)DbReturnValue.RecordExists) { MiscHelper configHelper = new MiscHelper(); GridAWSS3Config awsConfig = configHelper.GetGridAwsConfig((List <Dictionary <string, string> >)awsConfigResponse.Results); AmazonS3 s3Helper = new AmazonS3(awsConfig); DownloadResponse FrontImageDownloadResponse = new DownloadResponse(); DownloadResponse BackImageDownloadResponse = new DownloadResponse(); if (!string.IsNullOrEmpty(orderList.DocumentURL)) { FrontImageDownloadResponse = await s3Helper.DownloadFile(orderList.DocumentURL.Remove(0, awsConfig.AWSEndPoint.Length)); if (FrontImageDownloadResponse.HasSucceed) { orderList.FrontImage = FrontImageDownloadResponse.FileObject != null?configHelper.GetBase64StringFromByteArray(FrontImageDownloadResponse.FileObject, orderList.DocumentURL.Remove(0, awsConfig.AWSEndPoint.Length)) : null; orderList.DocumentURL = ""; } else { orderList.DocumentURL = ""; orderList.FrontImage = ""; } } if (!string.IsNullOrEmpty(orderList.DocumentBackURL)) { BackImageDownloadResponse = await s3Helper.DownloadFile(orderList.DocumentBackURL.Remove(0, awsConfig.AWSEndPoint.Length)); if (BackImageDownloadResponse.HasSucceed) { orderList.BackImage = BackImageDownloadResponse.FileObject != null?configHelper.GetBase64StringFromByteArray(BackImageDownloadResponse.FileObject, orderList.DocumentBackURL.Remove(0, awsConfig.AWSEndPoint.Length)) : null; orderList.DocumentBackURL = ""; } else { orderList.DocumentBackURL = ""; orderList.BackImage = ""; } } return(Ok(new ServerResponse { HasSucceeded = true, Message = StatusMessages.SuccessMessage, Result = orderList })); } else { // unable to get aws config LogInfo.Warning(EnumExtensions.GetDescription(CommonErrors.FailedToGetConfiguration)); return(Ok(new OperationResponse { HasSucceeded = false, Message = EnumExtensions.GetDescription(CommonErrors.FailedToGetConfiguration) })); } } } else { //Token expired LogInfo.Warning(EnumExtensions.GetDescription(CommonErrors.ExpiredToken)); return(Ok(new OperationResponse { HasSucceeded = false, Message = EnumExtensions.GetDescription(DbReturnValue.TokenExpired), IsDomainValidationErrors = true })); } } else { // token auth failure LogInfo.Warning(EnumExtensions.GetDescription(DbReturnValue.TokenAuthFailed)); return(Ok(new OperationResponse { HasSucceeded = false, Message = EnumExtensions.GetDescription(DbReturnValue.TokenAuthFailed), IsDomainValidationErrors = false })); } } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, IsDomainValidationErrors = false })); } }
public string GetSettingValue(string settingname) { string servicelist = (CommonDataAccess.GetSettingValue(settingname)) != null?CommonDataAccess.GetSettingValue("ServiceNames") : string.Empty; return(servicelist); }
public void PrintSlip(DataRow drFillDetails, string strFillType) { ValuetoWords objWords = new ValuetoWords(); VaultSlipXml xml = null; try { filename = "Print.txt"; filepath = System.Windows.Forms.Application.StartupPath + "\\" + filename; if (File.Exists(filepath)) { File.Delete(filepath); } outputfile = new FileStream(filepath, FileMode.OpenOrCreate, FileAccess.Write); writer = new StreamWriter(outputfile); writer.BaseStream.Seek(0, SeekOrigin.End); xml = new VaultSlipXml(writer); xml.ParseXmlFile(); ModuleName module = ModuleName.AttendantPay; string Type = string.Empty; // Header=0, //PrintedDate, //SiteName, //Vault_Name, //SerialNo, //Manufacturer, //Type, //Fill_User, //FillDate, //Initial_Balance, //Fill_Amount, //CurrentBalance, //Signature // required values for xml string sVersion = CommonDataAccess.GetVersion(); Double dAmount = Double.Parse(drFillDetails["FillAmount"].ToString()); if (dAmount < 0) { dAmount = dAmount * -1; } string AmtInWords = objWords.ConvertValueToWords(dAmount, CommonDataAccess.GetSettingValue("Region") == "US" ? "en-US" : CommonDataAccess.GetSettingValue("Region") == "UK" ? "en-GB" : CommonDataAccess.GetSettingValue("Region") == "IT" ? "it-IT" : "en-US"); // fill the values //xml[VaultSlipXmlFields.Header].Value = "Fill slip"; xml[VaultSlipXmlFields.PrintedDate].Value = DateTime.Now.ToString("dd-MMM-yyyy HH:mm:ss"); xml[VaultSlipXmlFields.SiteName].Value = Settings.SiteName; xml[VaultSlipXmlFields.Vault_Name].Value = drFillDetails["Name"].ToString(); xml[VaultSlipXmlFields.SerialNo].Value = drFillDetails["Serial_NO"].ToString(); xml[VaultSlipXmlFields.Manufacturer].Value = drFillDetails["Manufacturer_Name"].ToString(); xml[VaultSlipXmlFields.Type].Value = drFillDetails["Type_Prefix"].ToString(); xml[VaultSlipXmlFields.Fill_User].Value = SecurityHelper.CurrentUser.DisplayName; xml[VaultSlipXmlFields.FillDate].Value = DateTime.Parse(drFillDetails["CreatedDate"].ToString()).ToString("dd-MMM-yyyy HH:mm:ss"); xml[VaultSlipXmlFields.Fill_Amount].Value = CommonUtilities.GetCurrency(double.Parse(drFillDetails["FillAmount"].ToString())); if (strFillType != string.Empty) { xml[VaultSlipXmlFields.Fill_Type].Value = strFillType; } xml[VaultSlipXmlFields.Initial_Balance].Value = CommonUtilities.GetCurrency(double.Parse(drFillDetails["TotalAmountOnFill"].ToString())); xml[VaultSlipXmlFields.CurrentBalance].Value = CommonUtilities.GetCurrency(double.Parse(drFillDetails["CurrentBalance"].ToString())); xml[VaultSlipXmlFields.Signature].Value = string.Empty; xml.Write(); writer.Close(); _textSettings = xml.TextSettings; PrintSlippage(xml.TextSettings); } catch (Exception ex) { ExceptionManager.Publish(ex); } finally { if (xml != null) { xml.Dispose(); xml = null; } } }
public CommonRepository() { this.instance = new CommonDataAccess(); }
public DataTable GetWeekCollectionDetails(int WeekID) { DataTable dtWeeklyInvoice = new DataTable(); string SiteCode = CommonDataAccess.GetSettingValue("TICKET_LOCATION_CODE"); string EnterpriseURL = GetEnterpriseURL(); string TotalPowerCollectionDuration; try { Proxy WebProxy = new Proxy(SiteCode); dtWeeklyInvoice = WebProxy.GetWeeklyCollectionDetails(SiteCode, WeekID, 0); dtWeeklyInvoice.Columns.Add("Payout", System.Type.GetType("System.Decimal")); dtWeeklyInvoice.Columns.Add("Hold", System.Type.GetType("System.Decimal")); dtWeeklyInvoice.Columns.Add("Duration"); foreach (DataRow dr in dtWeeklyInvoice.Rows) { double DecWinOrLoss; double MeterWinOrLoss; TotalPowerCollectionDuration = "0"; DecWinOrLoss = Convert.ToDouble(dr["Declared_Notes"]) + Convert.ToDouble(dr["DecTicketBalance"]) - Convert.ToDouble(dr["DecHandpay"]) + Convert.ToDouble(dr["Net_Coin"]); MeterWinOrLoss = Convert.ToDouble(dr["RDC_Notes"]) + (Convert.ToDouble(dr["DecTicketBalance"]) - Convert.ToDouble(dr["Ticket_Var"])) - Convert.ToDouble(dr["RDCHandpay"]) + Convert.ToDouble(dr["RDC_Coins"]); dr["Cash_Take"] = DecWinOrLoss; dr["RDC_Take"] = MeterWinOrLoss; dr["Take_Var"] = DecWinOrLoss - MeterWinOrLoss; dr["Ticket_Balance"] = Convert.ToDouble(dr["DecTicketBalance"]); dr["RDC_Ticket_Balance"] = Convert.ToDouble(dr["DecTicketBalance"]) - Convert.ToDouble(dr["Ticket_Var"]);; if (WeekID != 0) { if (Convert.ToDouble(dr["Handle"]) > 0) { dr["Payout"] = ((Convert.ToDouble(dr["Handle"]) - MeterWinOrLoss) / Convert.ToDouble(dr["Handle"])) * 100; dr["Hold"] = 100 - (((Convert.ToDouble(dr["Handle"]) - MeterWinOrLoss) / Convert.ToDouble(dr["Handle"])) * 100); } else { dr["Payout"] = "0"; dr["Hold"] = "100"; } } else { dr["Payout"] = "0"; dr["Hold"] = "100"; } if (Convert.ToInt64(dr["Collection_Total_Power_Duration"]) / 3600 > 0) { TotalPowerCollectionDuration = (Convert.ToInt64(dr["Collection_Total_Power_Duration"]) / 3600).ToString(); } if ((Convert.ToInt64(dr["Collection_Total_Power_Duration"]) % 3600) / 60 > 0) { TotalPowerCollectionDuration = TotalPowerCollectionDuration + "." + ((Convert.ToInt64(dr["Collection_Total_Power_Duration"]) % 3600) / 60).ToString(); } dr["Duration"] = TotalPowerCollectionDuration; } } catch (Exception ex) { ExceptionManager.Publish(ex); } return(dtWeeklyInvoice); }
public static DataTable GetColumns(string tableName) { return(CommonDataAccess.GetColumns(tableName)); }
public static string CreateFormId() { return(CommonDataAccess.CreateFormId()); }
public async Task <IActionResult> UpdateNRICDetails([FromHeader(Name = "Grid-Authorization-Token")] string token, [FromForm] NRICDetails request) { try { if (string.IsNullOrEmpty(token)) { return(Ok(new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = true, Message = EnumExtensions.GetDescription(CommonErrors.TokenEmpty) })); } AdminUsersDataAccess _adminUsersDataAccess = new AdminUsersDataAccess(_iconfiguration); DatabaseResponse tokenAuthResponse = await _adminUsersDataAccess.AuthenticateAdminUserToken(token); if (tokenAuthResponse.ResponseCode == (int)DbReturnValue.AuthSuccess) { if (!((AuthTokenResponse)tokenAuthResponse.Results).IsExpired) { if (!ModelState.IsValid) { return(StatusCode((int)HttpStatusCode.OK, new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = true, Message = string.Join("; ", ModelState.Values .SelectMany(x => x.Errors) .Select(x => x.ErrorMessage)) })); } if (!string.IsNullOrEmpty(request.IdentityCardNumber)) { EmailValidationHelper _helper = new EmailValidationHelper(); if (!_helper.NRICValidation(null, request.IdentityCardNumber, out string _warningmsg)) { LogInfo.Warning("NRIC Validation with type: " + _warningmsg); return(Ok(new OperationResponse { HasSucceeded = false, Message = "Document details are invalid", IsDomainValidationErrors = false })); } } int deliveryStatusNumber = request.IDVerificationStatus; var authToken = (AuthTokenResponse)tokenAuthResponse.Results; MiscHelper configHelper = new MiscHelper(); CommonDataAccess _commonDataAccess = new CommonDataAccess(_iconfiguration); NRICDetailsRequest personalDetails = new NRICDetailsRequest { OrderID = request.OrderID, IdentityCardNumber = request.IdentityCardNumber, IdentityCardType = request.IdentityCardType, Nationality = request.Nationality, NameInNRIC = request.NameInNRIC, DOB = request.DOB, Expiry = request.Expiry, Remarks = request.Remarks, IDVerificationStatus = request.IDVerificationStatus, }; if (request.FrontImage != null || request.BackImage != null) { string IDCardNumberForImage = string.Empty; DatabaseResponse awsConfigResponse = await _commonDataAccess.GetConfiguration(ConfiType.AWS.ToString()); if (awsConfigResponse != null && awsConfigResponse.ResponseCode == (int)DbReturnValue.RecordExists) { GridAWSS3Config awsConfig = configHelper.GetGridAwsConfig((List <Dictionary <string, string> >)awsConfigResponse.Results); // Check for IdentityCardNumber //Start if (string.IsNullOrEmpty(request.IdentityCardNumber)) { var orderDetailsForIDCard = await _commonDataAccess.GetOrderDetails(request.OrderID); IDCardNumberForImage = orderDetailsForIDCard.IdentityCardNumber; } else { IDCardNumberForImage = request.IdentityCardNumber; } //End AmazonS3 s3Helper = new AmazonS3(awsConfig); if (request.FrontImage != null) { string fileNameFront = IDCardNumberForImage.Substring(1, IDCardNumberForImage.Length - 2) + "_Front_" + DateTime.Now.ToString("yyMMddhhmmss") + Path.GetExtension(request.FrontImage.FileName); //Grid_IDNUMBER_yyyymmddhhmmss.extension UploadResponse s3UploadResponse = await s3Helper.UploadFile(request.FrontImage, fileNameFront); if (s3UploadResponse.HasSucceed) { personalDetails.FrontImage = awsConfig.AWSEndPoint + s3UploadResponse.FileName; } else { LogInfo.Warning(EnumExtensions.GetDescription(CommonErrors.S3UploadFailed)); } } if (request.BackImage != null) { string fileNameBack = IDCardNumberForImage.Substring(1, IDCardNumberForImage.Length - 2) + "_Back_" + DateTime.Now.ToString("yyMMddhhmmss") + Path.GetExtension(request.BackImage.FileName); //Grid_IDNUMBER_yyyymmddhhmmss.extension UploadResponse s3UploadResponse = await s3Helper.UploadFile(request.BackImage, fileNameBack); if (s3UploadResponse.HasSucceed) { personalDetails.BackImage = awsConfig.AWSEndPoint + s3UploadResponse.FileName; } else { LogInfo.Warning(EnumExtensions.GetDescription(CommonErrors.S3UploadFailed)); } } } else { // unable to get aws config LogInfo.Warning(EnumExtensions.GetDescription(CommonErrors.FailedToGetConfiguration)); } } var returnResponse = await _commonDataAccess.UpdateNRICDetails(authToken.CustomerID, deliveryStatusNumber, personalDetails); if (returnResponse.ResponseCode == (int)DbReturnValue.UpdateSuccessSendEmail) { var emailDetails = (EmailResponse)returnResponse.Results; DatabaseResponse configResponse = new DatabaseResponse(); DatabaseResponse tokenCreationResponse = new DatabaseResponse(); string finalURL = string.Empty; // Fetch the URL if (emailDetails.VerificationStatus == 2) // Rejected then token { configResponse = ConfigHelper.GetValueByKey(ConfigKeys.NRICReUploadLink.GetDescription(), _iconfiguration); tokenCreationResponse = await _adminOrderDataAccess.CreateTokenForVerificationRequests(request.OrderID); var tokenCreation = (VerificationRequestResponse)tokenCreationResponse.Results; finalURL = configResponse.Results.ToString() + tokenCreation.RequestToken; } else { var result = await _commonDataAccess.UpdateTokenForVerificationRequests(request.OrderID); } //Sending message start // Send email to customer email ConfigDataAccess _configAccess = new ConfigDataAccess(_iconfiguration); DatabaseResponse registrationResponse = await _adminOrderDataAccess.GetEmailNotificationTemplate(emailDetails.VerificationStatus == 2?NotificationEvent.ICValidationReject.GetDescription() : NotificationEvent.ICValidationChange.GetDescription()); string[] changelog = emailDetails.ChangeLog.Split(";"); string finallog = ""; foreach (string log in changelog) { if (!string.IsNullOrWhiteSpace(log)) { finallog = finallog + "• " + log.Trim() + "<br/>"; } } var notificationMessage = MessageHelper.GetMessage(emailDetails.Email, emailDetails.Name, emailDetails.VerificationStatus == 2 ? NotificationEvent.ICValidationReject.GetDescription() : NotificationEvent.ICValidationChange.GetDescription(), ((EmailTemplate)registrationResponse.Results).TemplateName, _iconfiguration, string.IsNullOrWhiteSpace(finalURL) ? "-" : finalURL, string.IsNullOrWhiteSpace(emailDetails.Remark) ? "-" : emailDetails.Remark.Replace(";", "<br />"), string.IsNullOrWhiteSpace(emailDetails.ChangeLog) ? "-" : finallog); var notificationResponse = await _adminOrderDataAccess.GetConfiguration(ConfiType.Notification.ToString()); MiscHelper parser = new MiscHelper(); var notificationConfig = parser.GetNotificationConfig((List <Dictionary <string, string> >)notificationResponse.Results); Publisher customerNotificationPublisher = new Publisher(_iconfiguration, notificationConfig.SNSTopic); await customerNotificationPublisher.PublishAsync(notificationMessage); try { DatabaseResponse notificationLogResponse = await _adminOrderDataAccess.CreateEMailNotificationLogForDevPurpose( new NotificationLogForDevPurpose { EventType = NotificationEvent.OrderSuccess.ToString(), Message = JsonConvert.SerializeObject(notificationMessage) }); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); } //Sending message Stop return(Ok(new ServerResponse { HasSucceeded = true, Message = StatusMessages.SuccessMessage, Result = null })); } else if (returnResponse.ResponseCode == (int)DbReturnValue.UpdateSuccess) { var emailDetails = (EmailResponse)returnResponse.Results; DatabaseResponse configResponse = new DatabaseResponse(); DatabaseResponse tokenCreationResponse = new DatabaseResponse(); string finalURL = string.Empty; if (emailDetails.VerificationStatus == 2) // Rejected then token { configResponse = ConfigHelper.GetValueByKey(ConfigKeys.NRICReUploadLink.GetDescription(), _iconfiguration); tokenCreationResponse = await _adminOrderDataAccess.CreateTokenForVerificationRequests(request.OrderID); var tokenCreation = (VerificationRequestResponse)tokenCreationResponse.Results; finalURL = configResponse.Results.ToString() + tokenCreation.RequestToken; DatabaseResponse registrationResponse = await _adminOrderDataAccess.GetEmailNotificationTemplate(NotificationEvent.ICValidationReject.GetDescription()); var notificationMessage = MessageHelper.GetMessage(emailDetails.Email, emailDetails.Name, NotificationEvent.ICValidationReject.GetDescription(), ((EmailTemplate)registrationResponse.Results).TemplateName, _iconfiguration, string.IsNullOrWhiteSpace(finalURL) ? "-" : finalURL, string.IsNullOrWhiteSpace(emailDetails.Remark) ? "-" : emailDetails.Remark.Replace(";", "<br />"), string.IsNullOrWhiteSpace(emailDetails.ChangeLog) ? "-" : emailDetails.ChangeLog); var notificationResponse = await _adminOrderDataAccess.GetConfiguration(ConfiType.Notification.ToString()); MiscHelper parser = new MiscHelper(); var notificationConfig = parser.GetNotificationConfig((List <Dictionary <string, string> >)notificationResponse.Results); Publisher customerNotificationPublisher = new Publisher(_iconfiguration, notificationConfig.SNSTopic); await customerNotificationPublisher.PublishAsync(notificationMessage); try { DatabaseResponse notificationLogResponse = await _adminOrderDataAccess.CreateEMailNotificationLogForDevPurpose( new NotificationLogForDevPurpose { EventType = NotificationEvent.OrderSuccess.ToString(), Message = JsonConvert.SerializeObject(notificationMessage) }); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); } } else { var result = await _commonDataAccess.UpdateTokenForVerificationRequests(request.OrderID); } //Sending message start // Send email to customer email ConfigDataAccess _configAccess = new ConfigDataAccess(_iconfiguration); return(Ok(new ServerResponse { HasSucceeded = true, Message = StatusMessages.SuccessMessage, Result = null })); } else { LogInfo.Error("UpdateNRICDetails failed for " + request.OrderID + " Order Id " + DbReturnValue.UpdationFailed); return(Ok(new OperationResponse { HasSucceeded = false, Message = EnumExtensions.GetDescription(DbReturnValue.UpdationFailed), IsDomainValidationErrors = false })); } } else { //Token expired LogInfo.Warning(EnumExtensions.GetDescription(CommonErrors.ExpiredToken)); return(Ok(new OperationResponse { HasSucceeded = false, Message = EnumExtensions.GetDescription(DbReturnValue.TokenExpired), IsDomainValidationErrors = true })); } } else { // token auth failure LogInfo.Warning(EnumExtensions.GetDescription(DbReturnValue.TokenAuthFailed)); return(Ok(new OperationResponse { HasSucceeded = false, Message = EnumExtensions.GetDescription(DbReturnValue.TokenAuthFailed), IsDomainValidationErrors = false })); } } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, IsDomainValidationErrors = false })); } }