public void UpdateActivityDates([FromBody] ActivityDates dates)
{
if (dates.ActivityOnly)
{
DBFacilitator.ExecuteCommand(
PostgreSQLConnectionString,
UPDATE_ACTIVITY_DATES_ACTIVITY_ONLY,
new List <Tuple <string, string, NpgsqlDbType> >()
{
{ new Tuple <string, string, NpgsqlDbType>(":Username", dates.Username, NpgsqlDbType.Text) },
{ new Tuple <string, string, NpgsqlDbType>(":ApplicationName", dates.AppName, NpgsqlDbType.Text) },
{ new Tuple <string, string, NpgsqlDbType>(":LastActivityDate", dates.ActivityOnly ? "Y" : "N", NpgsqlDbType.Date) }
}
);
}
else
{
DBFacilitator.ExecuteCommand(
PostgreSQLConnectionString,
UPDATE_ACTIVITY_DATES,
new List <Tuple <string, string, NpgsqlDbType> >()
{
{ new Tuple <string, string, NpgsqlDbType>(":Username", dates.Username, NpgsqlDbType.Text) },
{ new Tuple <string, string, NpgsqlDbType>(":ApplicationName", dates.AppName, NpgsqlDbType.Text) },
{ new Tuple <string, string, NpgsqlDbType>(":LastActivityDate", DateTime.Now.ToString(), NpgsqlDbType.Date) },
{ new Tuple <string, string, NpgsqlDbType>(":LastUpdatedDate", DateTime.Now.ToString(), NpgsqlDbType.Date) }
}
);
}
}
public void UpdateActivityDates(ActivityDates dates)
{
dal.UpdateActivityDates(dates.Username, dates.ActivityOnly, dates.AppName);
}
public void UpdateActivityDates(string userName, bool activityOnly, string appName)
{
var updateActivityDates = new ActivityDates(userName, activityOnly, appName);
Utility.ServiceCall(requestURL + "/updateactivitydates", JsonConvert.SerializeObject(updateActivityDates));
}