public async Task <DatabaseResponse> ValidateResetPasswordToken(string token) { try { SqlParameter[] parameters = { new SqlParameter("@Token", SqlDbType.NVarChar) }; parameters[0].Value = token; _DataHelper = new DataAccessHelper("Customer_ValidateResetPasswordToken", parameters, _configuration); int result = await _DataHelper.RunAsync(); // 124 /125 DatabaseResponse response = new DatabaseResponse(); response = new DatabaseResponse { ResponseCode = result }; return(response); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw (ex); } finally { _DataHelper.Dispose(); } }
public async Task <IActionResult> GetConfigValue([FromHeader] string Token, [FromRoute] string ConfigKey) { try { if (string.IsNullOrEmpty(ConfigKey)) { return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.DomainValidationError, IsDomainValidationErrors = true })); } ConfigDataAccess _configAccess = new ConfigDataAccess(_iconfiguration); return(Ok(new ServerResponse { HasSucceeded = true, Message = StatusMessages.SuccessMessage, Result = await _configAccess.GetConfigValue(ConfigKey, Token) })); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, IsDomainValidationErrors = false })); } }
public List <RewardDetails> GetRewardDetails(string RequestUrl, int AccountID, DateTime FromDate, DateTime ToDate) { List <RewardDetails> _resp = null; try { ApiClient client = new ApiClient(new Uri(RequestUrl)); var requestUrl = GetRequestUrl(RequestUrl, ref client); RequestObject req = new RequestObject(); string html = string.Empty; string url = requestUrl + $"{AccountID}?startDate={FromDate.ToString("yyyyMMdd")}&endDate={ToDate.ToString("yyyyMMdd")}"; HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url); request.AutomaticDecompression = DecompressionMethods.GZip; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) using (Stream stream = response.GetResponseStream()) using (StreamReader reader = new StreamReader(stream)) { html = reader.ReadToEnd(); } _resp = JsonConvert.DeserializeObject <List <RewardDetails> >(html); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw; } return(_resp); }
public Rewards GetRewardSummary(string RequestUrl, int AccountID) { Rewards _resp = null; try { ApiClient client = new ApiClient(new Uri(RequestUrl)); var requestUrl = GetRequestUrl(RequestUrl, ref client); RequestObject req = new RequestObject(); string html = string.Empty; string url = requestUrl + $"{AccountID}"; HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url); request.AutomaticDecompression = DecompressionMethods.GZip; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) using (Stream stream = response.GetResponseStream()) using (StreamReader reader = new StreamReader(stream)) { html = reader.ReadToEnd(); } _resp = JsonConvert.DeserializeObject <Rewards>(html); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw; } return(_resp); }
public async Task <DatabaseResponse> ResetPassword(ResetPassword resetPassword) { try { SqlParameter[] parameters = { new SqlParameter("@Token", SqlDbType.NVarChar), new SqlParameter("@Password", SqlDbType.NVarChar) }; parameters[0].Value = resetPassword.ResetToken; parameters[1].Value = new Sha2().Hash(new Base64Helper().base64Decode(resetPassword.NewPassword)); _DataHelper = new DataAccessHelper("Customer_ResetPassword", parameters, _configuration); int result = await _DataHelper.RunAsync(); return(new DatabaseResponse { ResponseCode = result }); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw (ex); } finally { _DataHelper.Dispose(); } }
public async Task <List <Bundle> > GetBundleList(string code) { try { if (code != "") { SqlParameter[] parameters = { new SqlParameter("@UserCode", SqlDbType.NVarChar) }; parameters[0].Value = code; _DataHelper = new DataAccessHelper("Catelog_GetBundlesListing", parameters, _configuration); } else { _DataHelper = new DataAccessHelper("Catelog_GetBundlesListing", _configuration); } DataTable dt = new DataTable(); await _DataHelper.RunAsync(dt); List <Bundle> bundleList = new List <Bundle>(); if (dt.Rows.Count > 0) { bundleList = (from model in dt.AsEnumerable() select new Bundle() { BundleID = model.Field <int>("BundleID"), BundleName = model.Field <string>("BundleName"), PortalDescription = model.Field <string>("PortalDescription"), PlanMarketingName = model.Field <string>("PlanMarketingName"), PortalSummaryDescription = model.Field <string>("PortalSummaryDescription"), ServiceName = model.Field <string>("ServiceName"), ActualServiceFee = model.Field <double>("ActualServiceFee"), ActualSubscriptionFee = model.Field <double>("ActualSubscriptionFee"), ApplicableServiceFee = model.Field <double>("ApplicableServiceFee"), ApplicableSubscriptionFee = model.Field <double>("ApplicableSubscriptionFee"), TotalData = model.Field <double>("TotalData"), TotalSMS = model.Field <double>("TotalSMS"), TotalVoice = model.Field <double>("TotalVoice"), PromotionText = model.Field <string>("PromotionText"), PricingDescription = model.Field <string>("PricingDescription") }).ToList(); } return(bundleList); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw (ex); } finally { _DataHelper.Dispose(); } }
private static int GetIntervel() { try { DatabaseResponse intervelConfigResponse = new DatabaseResponse(); intervelConfigResponse = ConfigHelper.GetValueByKey(ConfigKeys.BuddyTrialIntervel.ToString(), _connectionString); if (intervelConfigResponse != null && intervelConfigResponse.ResponseCode == (int)DbReturnValue.RecordExists) { string configValue = (string)intervelConfigResponse.Results; return(int.Parse(configValue)); } else { return(0); } } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(0); } }
static void Main(string[] args) { try { LogInfo.Initialize(Configuration); LogInfo.Information("Buddy Console App is Started"); _connectionString = Configuration.GetConnectionString("DefaultConnection"); _timeInterval = GetIntervel(); bool complete = false; var t = new Thread(() => { bool toggle = false; while (!complete) { toggle = !toggle; TimerCallback(); Thread.Sleep(_timeInterval); } }); t.Start(); complete = false; t.Join(); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); } }
/// <summary> /// Grids the process vas addition. /// </summary> /// <param name="ChangeRequestID">The change request identifier.</param> /// <param name="Status">The status.</param> /// <param name="ValidFrom">The valid from.</param> /// <param name="ValidTo">The valid to.</param> /// <returns></returns> public async Task <int> Grid_ProcessVASAddition(int ChangeRequestID, int Status, DateTime ValidFrom, DateTime ValidTo) { try { SqlParameter[] parameters = { new SqlParameter("@ChangeRequestID", SqlDbType.Int), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@ValidFrom", SqlDbType.Date), new SqlParameter("@ValidTo", SqlDbType.Date), }; parameters[0].Value = ChangeRequestID; parameters[1].Value = Status; parameters[2].Value = ValidFrom.Date; parameters[3].Value = ValidTo.Date; _DataHelper = new DataAccessHelper("Grid_ProcessVASAddition", parameters, _configuration); DataTable dt = new DataTable(); return(await _DataHelper.RunAsync()); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw; } finally { _DataHelper.Dispose(); } }
/// <summary> /// Grids the update order status. /// </summary> /// <param name="request">The request.</param> /// <returns></returns> public async Task <int> Grid_UpdateOrderStatus(UpdateOrderStatus request) { try { SqlParameter[] parameters = { new SqlParameter("@OrderID", SqlDbType.Int), new SqlParameter("@OrderNumber", SqlDbType.NVarChar), new SqlParameter("@Orderstatus", SqlDbType.NVarChar), new SqlParameter("@error_reason", SqlDbType.NVarChar), }; parameters[0].Value = request.OrderID; parameters[1].Value = request.OrderNumber; parameters[2].Value = request.Orderstatus; parameters[3].Value = request.error_reason; _DataHelper = new DataAccessHelper("Grid_UpdateOrderStatus", parameters, _configuration); DataTable dt = new DataTable(); return(await _DataHelper.RunAsync()); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw; } finally { _DataHelper.Dispose(); } }
public async Task <DatabaseResponse> ValidateUserCode(string UserCode) { try { string ename = ""; SqlParameter[] parameters = { new SqlParameter("@UserCode", SqlDbType.NVarChar), }; parameters[0].Value = UserCode; DataSet ds = new DataSet("ds"); _DataHelper = new DataAccessHelper("Customers_ValidateUserCode", parameters, _configuration); int result = await _DataHelper.RunAsync(ds); //103/150, if (ds.Tables[0].Rows.Count > 0) { ename = ds.Tables[0].Rows[0][0].ToString().Trim(); } DatabaseResponse response = new DatabaseResponse(); response = new DatabaseResponse { ResponseCode = result, Results = ename }; return(response); } catch (Exception e) { LogInfo.Error(new ExceptionHelper().GetLogString(e, ErrorLevel.Critical)); throw e; } }
/// <summary> /// Updates the customer account accessibility. /// </summary> /// <param name="Token">The token.</param> /// <param name="CustomerID">The customer identifier.</param> /// <param name="Status">The status.</param> /// <returns></returns> public async Task <DatabaseResponse> UpdateCustomerAccountAccessibility(string Token, int CustomerID, int Status) { try { SqlParameter[] parameters = { new SqlParameter("@CustomerID", SqlDbType.Int), new SqlParameter("@UpdatorToken", SqlDbType.VarChar), new SqlParameter("@Status", SqlDbType.Int) }; parameters[0].Value = CustomerID; parameters[1].Value = Token; parameters[2].Value = Status; _DataHelper = new DataAccessHelper("Admin_UpdateCustomerAccountAccessibility", parameters, _configuration); int result = await _DataHelper.RunAsync(); //101,106,102,143 - admin token not matching return(new DatabaseResponse { ResponseCode = result }); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw ex; } finally { _DataHelper.Dispose(); } }
/// <summary> /// Updates the message queue object to table. /// </summary> /// <param name="updateQueue">The update queue.</param> /// <returns></returns> private async Task <int> UpdateMessageQueueObjectToTable(MessageQueueRequest updateQueue) { var _DataHelper = new DataAccessHelper(Core.Enums.DbObjectNames.z_UpdateStatusInMessageQueueRequests, _connectionString); try { SqlParameter[] parameters = { new SqlParameter("@MessageQueueRequestID", SqlDbType.Int), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@PublishedOn", SqlDbType.DateTime), new SqlParameter("@NumberOfRetries", SqlDbType.Int), new SqlParameter("@LastTriedOn", SqlDbType.DateTime), }; parameters[0].Value = updateQueue.MessageQueueRequestID; parameters[1].Value = updateQueue.Status; parameters[2].Value = updateQueue.PublishedOn; parameters[3].Value = updateQueue.NumberOfRetries; parameters[4].Value = updateQueue.LastTriedOn; _DataHelper = new DataAccessHelper(Core.Enums.DbObjectNames.z_UpdateStatusInMessageQueueRequests, parameters, _connectionString); return(await _DataHelper.RunAsync()); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); Console.WriteLine("Critical error in UpdateMessageQueueObjectToTable. Exception is as follows \n " + ex); return(0); } finally { _DataHelper.Dispose(); } }
/// <summary> /// Creates the e mail notification log. /// </summary> /// <param name="log">The log.</param> /// <returns></returns> public async Task <DatabaseResponse> CreateEMailNotificationLog(NotificationLog log) { try { SqlParameter[] parameters = { new SqlParameter("@CustomerID", SqlDbType.Int), new SqlParameter("@Email", SqlDbType.NVarChar), new SqlParameter("@EmailSubject", SqlDbType.NVarChar), new SqlParameter("@EmailBody", SqlDbType.NVarChar), new SqlParameter("@ScheduledOn", SqlDbType.DateTime), new SqlParameter("@EmailTemplateID", SqlDbType.Int), new SqlParameter("@SendOn", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int) }; parameters[0].Value = log.CustomerID; parameters[1].Value = log.Email; parameters[2].Value = log.EmailSubject; parameters[3].Value = log.EmailBody; parameters[4].Value = log.ScheduledOn; parameters[5].Value = log.EmailTemplateID; parameters[6].Value = log.SendOn; parameters[7].Value = log.Status; _DataHelper = new DataAccessHelper("z_EmailNotificationsLogEntry", parameters, _configuration); DataTable dt = new DataTable(); int result = await _DataHelper.RunAsync(dt); // 107 /100 DatabaseResponse response = new DatabaseResponse(); response = new DatabaseResponse { ResponseCode = result }; return(response); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw (ex); } finally { _DataHelper.Dispose(); } }
/// <summary> /// Grids the state of the update subscriber. /// </summary> /// <param name="SubscriberID">The subscriber identifier.</param> /// <param name="state">The state.</param> /// <param name="error_reason">The error reason.</param> /// <returns></returns> public async Task <int> Grid_UpdateSubscriberState(int SubscriberID, string state, string error_reason) { try { SqlParameter[] parameters = { new SqlParameter("@SubscriberID", SqlDbType.Int), new SqlParameter("@state", SqlDbType.NVarChar), new SqlParameter("@error_reason", SqlDbType.NVarChar), }; parameters[0].Value = SubscriberID; parameters[1].Value = state; parameters[2].Value = error_reason; _DataHelper = new DataAccessHelper("Grid_UpdateSubscriberState", parameters, _configuration); DataTable dt = new DataTable(); return(await _DataHelper.RunAsync()); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw; } finally { _DataHelper.Dispose(); } }
public async Task <IActionResult> GetPageFAQ([FromHeader(Name = "Grid-General-Token")] string Token, [FromRoute] string Pagename) { try { if (string.IsNullOrEmpty(Pagename)) { return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.DomainValidationError, IsDomainValidationErrors = true })); } TokenValidationHelper tokenValidationHelper = new TokenValidationHelper(); if (!tokenValidationHelper.ValidateGenericToken(Token, _iconfiguration)) { return(Ok(new OperationResponse { HasSucceeded = false, Message = Core.Extensions.EnumExtensions.GetDescription(DbReturnValue.TokenAuthFailed), IsDomainValidationErrors = true })); } FaqPageDataAccess _FaqPageDataAccess = new FaqPageDataAccess(_iconfiguration); List <FaqPages> faqresult = await _FaqPageDataAccess.GetPageFAQ(Pagename); string faqmessage; if (faqresult != null && faqresult.Count > 0) { faqmessage = StatusMessages.SuccessMessage; } else { faqmessage = "Faq not found"; } return(Ok(new ServerResponse { HasSucceeded = true, Message = faqmessage, Result = faqresult })); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, IsDomainValidationErrors = false })); } }
public async Task <DatabaseResponse> ValidatePostcode(string _postcode) { try { PostCodeRequest _postcodedata = new PostCodeRequest(); DatabaseResponse configResponse = ConfigHelper.GetValue("Postcode", _configuration); List <Dictionary <string, string> > _result = ((List <Dictionary <string, string> >)configResponse.Results); _postcodedata.APIKey = _result.Single(x => x["key"] == "PostcodeApiKey")["value"]; _postcodedata.APISecret = _result.Single(x => x["key"] == "PostcodeSecret")["value"]; _postcodedata.Postcode = _postcode; string Postcodeurl = _result.Single(x => x["key"] == "Postcodeurl")["value"]; byte[] buffer; string postData = string.Empty; postData = string.Format("APIKey={0}&APISecret={1}&Postcode={2}", _postcodedata.APIKey, _postcodedata.APISecret, _postcode); buffer = Encoding.UTF8.GetBytes(postData); System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12; HttpWebRequest myRequest = (HttpWebRequest)WebRequest.Create(Postcodeurl); myRequest.Method = "POST"; myRequest.ContentType = "application/x-www-form-urlencoded"; myRequest.ContentLength = buffer.Length; Stream newStream = myRequest.GetRequestStream(); await newStream.WriteAsync(buffer, 0, buffer.Length); newStream.Close(); HttpWebResponse myHttpWebResponse = (HttpWebResponse)myRequest.GetResponse(); Stream streamResponse = myHttpWebResponse.GetResponseStream(); StreamReader streamRead = new StreamReader(streamResponse); Char[] readBuffer = new Char[256]; int count = streamRead.Read(readBuffer, 0, 256); StringBuilder Result = new StringBuilder(); while (count > 0) { String resultData = new String(readBuffer, 0, count); Result.Append(resultData); count = streamRead.Read(readBuffer, 0, 256); } streamRead.Close(); streamResponse.Close(); myHttpWebResponse.Close(); dynamic data = JsonConvert.DeserializeObject(Result.ToString()); return(new DatabaseResponse { Results = data }); } catch (Exception e) { LogInfo.Error(new ExceptionHelper().GetLogString(e, ErrorLevel.Critical)); throw e; } }
public async Task <string> SendOrderSuccessSMSNotification(CustomerDetails customer, IConfiguration _configuration) { string status = string.Empty; try { ConfigDataAccess _configAccess = new ConfigDataAccess(_configuration); DatabaseResponse smsTemplateResponse = await _configAccess.GetSMSNotificationTemplate(NotificationEvent.OrderSuccess.ToString()); var notificationMessage = MessageHelper.GetSMSMessage(NotificationEvent.OrderSuccess.ToString(), ((SMSTemplates)smsTemplateResponse.Results).TemplateName, customer.Name, customer.DeliveryEmail, customer.ShippingContactNumber, customer.OrderNumber, customer.SlotDate.ToString("dd MMM yyyy"), new DateTime(customer.SlotFromTime.Ticks).ToString("hh:mm tt") + " to " + new DateTime(customer.SlotToTime.Ticks).ToString("hh:mm tt")); DatabaseResponse notificationResponse = await _configAccess.GetConfiguration(ConfiType.Notification.ToString()); MiscHelper parser = new MiscHelper(); var notificationConfig = parser.GetNotificationConfig((List <Dictionary <string, string> >)notificationResponse.Results); Publisher orderSuccessSMSNotificationPublisher = new Publisher(_configuration, notificationConfig.SNSTopic); status = await orderSuccessSMSNotificationPublisher.PublishAsync(notificationMessage); LogInfo.Information("SMS send status : " + status + " " + JsonConvert.SerializeObject(notificationMessage)); return(status); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical) + "SMS failure for OrderNumber:" + customer.OrderNumber); throw ex; } }
/// <summary> /// Grids the update billing account. /// </summary> /// <param name="AccountID">The account identifier.</param> /// <param name="BillingAccountNumber">The billing account number.</param> /// <param name="BSSProfileid">The BSS profileid.</param> /// <returns></returns> public async Task <int> Grid_UpdateBillingAccount(string AccountID, string BillingAccountNumber, string BSSProfileid) { try { SqlParameter[] parameters = { new SqlParameter("@AccountID", SqlDbType.Int), new SqlParameter("@BillingAccountNumber", SqlDbType.NVarChar), new SqlParameter("@BSSProfileid", SqlDbType.NVarChar), }; parameters[0].Value = AccountID; parameters[1].Value = BillingAccountNumber; parameters[2].Value = BSSProfileid; _DataHelper = new DataAccessHelper("Grid_UpdateBillingAccount", parameters, _configuration); DataTable dt = new DataTable(); return(await _DataHelper.RunAsync()); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw; } finally { _DataHelper.Dispose(); } }
public async Task <IActionResult> Log([FromBody] UILog logRequest) { try { if (logRequest == null || string.IsNullOrEmpty(logRequest.Message)) { return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.DomainValidationError, IsDomainValidationErrors = true })); } await Task.Run(() => { LogInfo.Error(JsonConvert.SerializeObject(logRequest)); }); return(Ok()); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, IsDomainValidationErrors = false })); } }
/// <summary> /// Grids the process change sim. /// </summary> /// <param name="ChangeRequestID">The change request identifier.</param> /// <param name="Status">The status.</param> /// <param name="SIMID">The simid.</param> /// <param name="SusbcriberStateUpdate">The susbcriber state update.</param> /// <returns></returns> public async Task <int> Grid_ProcessChangeSim(int ChangeRequestID, int Status, string SIMID, int SusbcriberStateUpdate) { try { SqlParameter[] parameters = { new SqlParameter("@ChangeRequestID", SqlDbType.Int), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@SIMID", SqlDbType.NVarChar), new SqlParameter("@SusbcriberStateUpdate", SqlDbType.Int), }; parameters[0].Value = ChangeRequestID; parameters[1].Value = Status; parameters[2].Value = SIMID; parameters[3].Value = SusbcriberStateUpdate; _DataHelper = new DataAccessHelper("Grid_ProcessChangeSim", parameters, _configuration); DataTable dt = new DataTable(); return(await _DataHelper.RunAsync()); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw; } finally { _DataHelper.Dispose(); } }
/// <summary> /// Grids the update vendor tracking code. /// </summary> /// <param name="DeliveryinformationID">The deliveryinformation identifier.</param> /// <param name="TrackingCode">The tracking code.</param> /// <returns></returns> public async Task <int> Grid_UpdateVendorTrackingCode(int DeliveryinformationID, string TrackingCode) { try { SqlParameter[] parameters = { new SqlParameter("@DeliveryinformationID", SqlDbType.Int), new SqlParameter("@TrackingCode", SqlDbType.NVarChar) }; parameters[0].Value = DeliveryinformationID; parameters[1].Value = TrackingCode; _DataHelper = new DataAccessHelper("Grid_UpdateVendorTrackingCode", parameters, _configuration); DataTable dt = new DataTable(); return(await _DataHelper.RunAsync()); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw; } finally { _DataHelper.Dispose(); } }
public async Task <IActionResult> GetTokenDetails([FromRoute] string token) { try { if (!ModelState.IsValid) { new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = true, Message = string.Join("; ", ModelState.Values .SelectMany(x => x.Errors) .Select(x => x.ErrorMessage)) }; } AccountDataAccess _AccountAccess = new AccountDataAccess(_iconfiguration); DatabaseResponse response = await _AccountAccess.AuthenticateToken(token); if (response.ResponseCode == 105) { //Authentication success var _accesstoken = new AccessToken(); _accesstoken = (AccessToken)response.Results; // return basic user info (without password) and token to store client side return(Ok(new OperationResponse { HasSucceeded = true, Message = EnumExtensions.GetDescription(DbReturnValue.AuthSuccess), ReturnedObject = _accesstoken })); } else { return(Ok(new OperationResponse { HasSucceeded = false, Message = EnumExtensions.GetDescription(DbReturnValue.ReasonUnknown), IsDomainValidationErrors = true })); } } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, IsDomainValidationErrors = false })); } }
public async Task <List <OrderList> > GetOrdersList(int?deliveryStatus, DateTime?fromDate, DateTime?toDate) { try { SqlParameter[] parameters = { new SqlParameter("@IDVerificationStatus", SqlDbType.Int), new SqlParameter("@FromDate", SqlDbType.DateTime), new SqlParameter("@ToDate", SqlDbType.DateTime) }; parameters[0].Value = deliveryStatus; parameters[1].Value = fromDate; parameters[2].Value = toDate; _DataHelper = new DataAccessHelper(DbObjectNames.Admin_GetOrderListForNRIC, parameters, _configuration); DataTable dt = new DataTable(); await _DataHelper.RunAsync(dt); List <OrderList> orderLists = new List <OrderList>(); if (dt.Rows.Count > 0) { orderLists = (from model in dt.AsEnumerable() select new OrderList() { OrderID = model.Field <int>("OrderID"), OrderNumber = model.Field <string>("OrderNumber"), IDVerificationStatus = model.Field <string>("IDVerificationStatus"), IsIDReUploaded = model.Field <int?>("IsIDReUploaded"), IDVerificationStatusNumber = model.Field <int?>("IDVerificationStatusNumber"), OrderStatus = model.Field <string>("OrderStatus"), OrderStatusNumber = model.Field <int?>("OrderStatusNumber"), RejectionCount = model.Field <int?>("RejectionCount"), Name = model.Field <string>("Name"), OrderDate = model.Field <DateTime?>("OrderDate"), DeliveryDate = model.Field <DateTime?>("DeliveryDate"), DeliveryFromTime = model.Field <TimeSpan?>("DeliveryFromTime"), DeliveryToTime = model.Field <TimeSpan?>("DeliveryToTime"), IdentityCardNumber = model.Field <string>("IdentityCardNumber"), IdentityCardType = model.Field <string>("IdentityCardType") }).ToList(); } return(orderLists); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw (ex); } finally { _DataHelper.Dispose(); } }
/// <summary> /// Gets the email notification template. /// </summary> /// <param name="templateName">Name of the template.</param> /// <returns></returns> public async Task <DatabaseResponse> GetEmailNotificationTemplate(string templateName) { try { SqlParameter[] parameters = { new SqlParameter("@TemplateName", SqlDbType.NVarChar) }; parameters[0].Value = templateName; _DataHelper = new DataAccessHelper("z_GetEmailTemplateByName", parameters, _configuration); DataTable dt = new DataTable(); int result = await _DataHelper.RunAsync(dt); // 109 /105 DatabaseResponse response = new DatabaseResponse(); EmailTemplate template = new EmailTemplate(); if (dt != null && dt.Rows.Count > 0) { template = (from model in dt.AsEnumerable() select new EmailTemplate() { EmailTemplateID = model.Field <int>("EmailTemplateID"), EmailBody = model.Field <string>("EmailBody"), EmailSubject = model.Field <string>("EmailSubject"), TemplateName = model.Field <string>("TemplateName") }).FirstOrDefault(); response = new DatabaseResponse { ResponseCode = result, Results = template }; } else { response = new DatabaseResponse { ResponseCode = result }; } return(response); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw (ex); } finally { _DataHelper.Dispose(); } }
public async Task <DatabaseResponse> GetForgetPassword(string email) { try { SqlParameter[] parameters = { new SqlParameter("@EmailAddress", SqlDbType.VarChar) }; parameters[0].Value = email; _DataHelper = new DataAccessHelper("Customer_ForgotPassword", parameters, _configuration); DataTable dt = new DataTable(); int result = await _DataHelper.RunAsync(dt); //111/107/109 ForgetPassword changePasswordToken = new ForgetPassword(); DatabaseResponse response = new DatabaseResponse(); if (dt != null && dt.Rows.Count > 0) { changePasswordToken = (from model in dt.AsEnumerable() select new ForgetPassword() { CustomerId = model.Field <int>("CustomerID"), Token = model.Field <string>("Token"), Name = model.Field <string>("Name"), Email = model.Field <string>("Email") }).FirstOrDefault(); response = new DatabaseResponse { ResponseCode = result, Results = changePasswordToken }; } else { response = new DatabaseResponse { ResponseCode = result }; } return(response); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw ex; } finally { _DataHelper.Dispose(); } }
public DatabaseResponse GetAdminUserPermissionsByToken(string token) { try { SqlParameter[] parameters = { new SqlParameter("@AuthToken", SqlDbType.VarChar), }; parameters[0].Value = token; _DataHelper = new DataAccessHelper("Admin_GetPermissionsByToken", parameters, _configuration); DataTable dt = new DataTable(); int result = _DataHelper.Run(dt); DatabaseResponse response = new DatabaseResponse(); if (dt != null && dt.Rows.Count > 0) { List <Permission> permissionList = new List <Permission>(); permissionList = (from model in dt.AsEnumerable() select new Permission() { RolePermission = model.Field <string>("Permission"), }).ToList(); List <string> permissions = permissionList.Select(item => item.RolePermission).ToList(); response = new DatabaseResponse { ResponseCode = result, Results = permissions }; } else { response = new DatabaseResponse { ResponseCode = result } }; return(response); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw ex; } finally { _DataHelper.Dispose(); } }
public async Task <DatabaseResponse> CreateAdminUser(RegisterAdminUser adminuser, int AdminUserID) { try { SqlParameter[] parameters = { new SqlParameter("@FullName", SqlDbType.NVarChar), new SqlParameter("@Email", SqlDbType.NVarChar), new SqlParameter("@Password", SqlDbType.NVarChar), new SqlParameter("@RoleID", SqlDbType.Int), new SqlParameter("@CreatedBy", SqlDbType.Int) }; parameters[0].Value = adminuser.FullName; parameters[1].Value = adminuser.Email; parameters[2].Value = new Sha2().Hash(adminuser.Password); parameters[3].Value = adminuser.RoleID; parameters[4].Value = AdminUserID; _DataHelper = new DataAccessHelper("Admin_CreateAdminUser", parameters, _configuration); DataTable dt = new DataTable(); int result = await _DataHelper.RunAsync(dt); AdminUsers newCustomer = new AdminUsers(); if (dt != null && dt.Rows.Count > 0) { newCustomer = (from model in dt.AsEnumerable() select new AdminUsers() { AdminUserID = model.Field <int>("AdminUserID"), Email = model.Field <string>("Email"), Password = model.Field <string>("Password"), Name = model.Field <string>("Name"), Role = model.Field <string>("Role"), }).FirstOrDefault(); } return(new DatabaseResponse { ResponseCode = result, Results = adminuser }); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw (ex); } finally { _DataHelper.Dispose(); } }
/// <summary> /// Changes the request offset voucher. /// </summary> /// <param name="SubscriberID">The subscriber identifier.</param> /// <param name="AdminUserID">The admin user identifier.</param> /// <returns></returns> public async Task <DatabaseResponse> ChangeRequestOffsetVoucher(int SubscriberID, int AdminUserID) { try { SqlParameter[] parameters = { new SqlParameter("@SubscriberID", SqlDbType.Int), new SqlParameter("@AdminUserID", SqlDbType.Int) }; parameters[0].Value = SubscriberID; parameters[1].Value = AdminUserID; _DataHelper = new DataAccessHelper(DbObjectNames.Admin_AssignChangeRequestOffsetVoucher, parameters, _configuration); int result = await _DataHelper.RunAsync(); // 105 /102 DatabaseResponse response = new DatabaseResponse(); if (result == (int)DbReturnValue.RecordExists) { response = new DatabaseResponse { ResponseCode = result, Results = "voucher has been assigned for selected subscriber" }; } else if (result == (int)DbReturnValue.VoucherNotApplicable_CR) { response = new DatabaseResponse { ResponseCode = result, Results = DbReturnValue.VoucherNotApplicable_CR.GetDescription() }; } else if (result == (int)DbReturnValue.ExistingVoucher) { response = new DatabaseResponse { ResponseCode = result, Results = DbReturnValue.ExistingVoucher.GetDescription() }; } else { response = null; } return(response); } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw (ex); } finally { _DataHelper.Dispose(); } }
/// <summary> /// Pushes the messages from message queue table. /// </summary> /// <returns></returns> public async Task PushMessagesFromMessageQueueTable() { MessageQueueResponse responseData = new MessageQueueResponse(); try { //Get 1 first message from table responseData = await GetMessageFromMessageQueueTable(); if (responseData != null) {//Push message var pushResult = await PublishMessageToQueue(responseData.Source, responseData.MessageBody, null, responseData.SNSTopic, responseData.MessageAttribute); if (pushResult.Trim().ToUpper() == "OK") {//Update the message queue MessageQueueRequest messageQueueRequest = new MessageQueueRequest(); messageQueueRequest.LastTriedOn = DateTime.Now; messageQueueRequest.MessageQueueRequestID = responseData.MessageQueueRequestID; messageQueueRequest.NumberOfRetries = responseData.NumberOfRetries + 1; messageQueueRequest.PublishedOn = DateTime.Now; messageQueueRequest.Status = 1; await UpdateMessageQueueObjectToTable(messageQueueRequest); LogInfo.Information("Ended successfully processing of MessageQueueRequestID = " + responseData.MessageQueueRequestID); } else { MessageQueueRequest messageQueueRequest = new MessageQueueRequest(); messageQueueRequest.LastTriedOn = DateTime.Now; messageQueueRequest.MessageQueueRequestID = responseData.MessageQueueRequestID; messageQueueRequest.NumberOfRetries = responseData.NumberOfRetries + 1; messageQueueRequest.PublishedOn = responseData.PublishedOn; messageQueueRequest.Status = 0; await UpdateMessageQueueObjectToTable(messageQueueRequest); LogInfo.Information("Ended Unsuccessfully processing of MessageQueueRequestID = " + responseData.MessageQueueRequestID); } } } catch (Exception ex) { LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); MessageQueueRequest messageQueueRequest = new MessageQueueRequest(); messageQueueRequest.LastTriedOn = DateTime.Now; messageQueueRequest.MessageQueueRequestID = responseData.MessageQueueRequestID; messageQueueRequest.NumberOfRetries = responseData.NumberOfRetries + 1; messageQueueRequest.PublishedOn = responseData.PublishedOn; messageQueueRequest.Status = 0; await UpdateMessageQueueObjectToTable(messageQueueRequest); throw ex; } }