internal int GetAlertsCount(AlertsBO alertsBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(alertsBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "uspWSGetAlertsCount";
sqlHelper.AddParameter(command, "@UserId", alertsBO.UserId, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@AlertDate", alertsBO.AlertDate, ParameterDirection.Input);
return(Convert.ToInt32(sqlHelper.ExecuteScalar(command)));
}
public int UpdateMessageStatus(AlertsBO alertsBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(alertsBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.Text);
command.CommandText = "Update MessageSentDetails set downloadStatus = 'true' where SentUserId ='" + alertsBO.UserId + "'";
SqlCommand command2 = sqlHelper.CreateCommand(CommandType.Text);
command2.CommandText = "Update VWSL_Message set downloadStatus = 'true' where SentUserId ='" + alertsBO.UserId + "'";
sqlHelper.ExecuteScalar(command);
return(Convert.ToInt32(sqlHelper.ExecuteScalar(command2)));
}
