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);
}
