public GetNotificationsResponse GetNotifications(LacesRequest request) { GetNotificationsResponse response = new GetNotificationsResponse(); try { if (request.SecurityString == ConfigurationManager.AppSettings[Constants.APP_SETTING_SECURITY_TOKEN]) { StoredProcedure proc = new StoredProcedure(Constants.CONNECTION_STRING, Constants.STORED_PROC_GET_NOTIFICATIONS); proc.AddInput("@userId", request.UserId, System.Data.SqlDbType.Int); DataSet resultSet = proc.ExecuteDataSet(); if (resultSet.Tables.Count > 0 && resultSet.Tables[0].Rows != null && resultSet.Tables[0].Rows.Count > 0) { response.Notifications = new List <Notification>(); foreach (DataRow row in resultSet.Tables[0].Rows) { Notification alert = new Notification(); alert.CreatedDate = Convert.ToDateTime(row["CreatedDate"]); alert.NotificationType = Convert.ToInt32(row["NotificationTypeId"]); alert.ProductId = Convert.ToInt32(row["ProductId"]); alert.UserName = Convert.ToString(row["UserName"]); response.Notifications.Add(alert); } response.Success = true; response.Message = "Notifications retrieved succesfully."; } else { response.Success = true; response.Message = "Could not find any notifications to display."; } } else { response.Success = false; response.Message = "Invalid security token."; } } catch { response = new GetNotificationsResponse(); response.Success = false; response.Message = "An unexpected error has occurred; please verify the format of your request."; } return(response); }
public GetInterestFeedResponse GetInterestFeed(LacesRequest request) { GetInterestFeedResponse response = new GetInterestFeedResponse(); try { if (request.SecurityString == ConfigurationManager.AppSettings[Constants.APP_SETTING_SECURITY_TOKEN]) { StoredProcedure proc = new StoredProcedure(Constants.CONNECTION_STRING, Constants.STORED_PROC_GET_INTEREST_FEED); proc.AddInput("@userId", request.UserId, System.Data.SqlDbType.Int); DataSet resultSet = proc.ExecuteDataSet(); if (resultSet.Tables.Count > 0 && resultSet.Tables[0].Rows != null && resultSet.Tables[0].Rows.Count > 0) { response.Products = new List <int>(); foreach (DataRow row in resultSet.Tables[0].Rows) { response.Products.Add(Convert.ToInt32(row["ProductId"])); } response.Success = true; response.Message = "Operation complete."; } else { response.Success = true; response.Message = "Could not find any products to display."; } } else { response.Success = false; response.Message = "Invalid security token."; } } catch { response = new GetInterestFeedResponse(); response.Success = false; response.Message = "An unexpected error has occurred; please verify the format of your request."; } return(response); }
public LacesResponse UpdateAlertCheckTime(LacesRequest request) { LacesResponse response = new LacesResponse(); try { if (request.SecurityString == ConfigurationManager.AppSettings[Constants.APP_SETTING_SECURITY_TOKEN]) { LacesDataModel.User.User user = new LacesDataModel.User.User(request.UserId); user.LastAlertCheck = DateTime.Now; if (user.Update()) { response.Success = true; response.Message = "Operation complete."; } else { response.Success = false; response.Message = "An error occurred when communicating with the database."; } } else { response.Success = false; response.Message = "Invalid security token."; } } catch (Exception ex) { response = new LacesResponse(); response.Success = false; if (ex.Message.Contains("find user")) { response.Message = ex.Message; } else { response.Message = "An unexpected error has occurred; please verify the format of your request."; } } return(response); }
public GetFollowingFeedResponse GetFollowingFeed(LacesRequest request) { GetFollowingFeedResponse response = new GetFollowingFeedResponse(); try { if (request.SecurityString == ConfigurationManager.AppSettings[Constants.APP_SETTING_SECURITY_TOKEN]) { StoredProcedure proc = new StoredProcedure(Constants.CONNECTION_STRING, Constants.STORED_PROC_GET_FOLLOWING_FEED); proc.AddInput("@userId", request.UserId, System.Data.SqlDbType.Int); DataSet resultSet = proc.ExecuteDataSet(); if (resultSet.Tables.Count > 0 && resultSet.Tables[0].Rows != null && resultSet.Tables[0].Rows.Count > 0) { response.Products = new List <FeedItem>(); foreach (DataRow row in resultSet.Tables[0].Rows) { FeedItem item = new FeedItem(); int feedResultType = Convert.ToInt32(row["FeedResultType"]); item.CreatedDate = Convert.ToDateTime(row["CreatedDate"]); switch (feedResultType) { case 0: item.FeedResultTypeMessage = string.Empty; break; case 1: item.FeedResultTypeMessage = Convert.ToString(row["UserName"]) + " liked this."; break; case 2: item.FeedResultTypeMessage = Convert.ToString(row["UserName"]) + " commented on this."; break; } item.ProductId = Convert.ToInt32(row["ProductId"]); response.Products.Add(item); } } else { response.Success = true; response.Message = "Could not find any products to display."; } } else { response.Success = false; response.Message = "Invalid security token."; } } catch { response = new GetFollowingFeedResponse(); response.Success = false; response.Message = "An unexpected error has occurred; please verify the format of your request."; } return(response); }