public static bool Save(long PersonID, long CommunityID)
{
Database oDatabase = DatabaseFactory.CreateDatabase(DataHelpers.ConnectionString());
using (DbConnection connection = oDatabase.CreateConnection())
{
connection.Open();
try
{
DbCommand oCommand = oDatabase.GetStoredProcCommand("sp_CommunityNewsSummaryRepository_InsertUpdate");
oDatabase.AddInParameter(oCommand, "@CommunityID", System.Data.DbType.Int64, CommunityID);
oDatabase.AddInParameter(oCommand, "@PersonID", System.Data.DbType.Int64, PersonID);
oCommand.Connection = connection;
if (oCommand.ExecuteNonQuery() == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
System.Diagnostics.EventLog.WriteEntry("NotificationToPersonRepository", ex.Message);
return(false);
}
}
}
public static bool RemoveNotificationForUser(Guid NotificationID, int PersonID)
{
Database oDatabase = DatabaseFactory.CreateDatabase(DataHelpers.ConnectionString());
using (DbConnection connection = oDatabase.CreateConnection())
{
connection.Open();
try
{
DbCommand oCommand = oDatabase.GetStoredProcCommand("sp_RemoveNotificationForUser");
oDatabase.AddInParameter(oCommand, "@NotificationID", System.Data.DbType.Guid, NotificationID);
oDatabase.AddInParameter(oCommand, "@PersonID", System.Data.DbType.Int32, PersonID);
oCommand.Connection = connection;
if (oCommand.ExecuteNonQuery() == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
System.Diagnostics.EventLog.WriteEntry("RemoveNotificationForUser", ex.Message);
return(false);
}
}
}
public static bool Add(PersonNotification oNotification)
{
Database oDatabase = DatabaseFactory.CreateDatabase(DataHelpers.ConnectionString());
using (DbConnection connection = oDatabase.CreateConnection()){
connection.Open();
try{
DbCommand oCommand = oDatabase.GetStoredProcCommand("sp_NotificationToPersonRepository_Add");
oDatabase.AddInParameter(oCommand, "@UniqueID", System.Data.DbType.Guid, oNotification.NotificationUniqueID);
oDatabase.AddInParameter(oCommand, "@PersonID", System.Data.DbType.Int64, oNotification.PersonID);
oDatabase.AddInParameter(oCommand, "@ID", System.Data.DbType.Guid, System.Guid.NewGuid());
oDatabase.AddInParameter(oCommand, "@Day", System.Data.DbType.DateTime, oNotification.Day);
oDatabase.AddInParameter(oCommand, "@CommunityID", System.Data.DbType.Int64, oNotification.CommunityID);
oDatabase.AddInParameter(oCommand, "@SentDate", System.Data.DbType.DateTime, oNotification.SentDate);
oCommand.Connection = connection;
if (oCommand.ExecuteNonQuery() == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex) {
System.Diagnostics.EventLog.WriteEntry("NotificationToPersonRepository", ex.Message);
return(false);
}
}
}
public static bool Save(CommunityNewsSummary reminder)
{
Database oDatabase = DatabaseFactory.CreateDatabase(DataHelpers.ConnectionString());
using (DbConnection connection = oDatabase.CreateConnection())
{
connection.Open();
try
{
DbCommand oCommand;
if (reminder.ID == System.Guid.Empty)
{
oCommand = oDatabase.GetStoredProcCommand("sp_CommunityNewsSummaryRepository_Add");
reminder.ID = System.Guid.NewGuid();
}
else
{
oCommand = oDatabase.GetStoredProcCommand("sp_CommunityNewsSummaryRepository_Update");
}
oDatabase.AddInParameter(oCommand, "@CommunityID", System.Data.DbType.Int64, reminder.CommunityID);
oDatabase.AddInParameter(oCommand, "@CountAction", System.Data.DbType.Int64, reminder.ActionCount);
oDatabase.AddInParameter(oCommand, "@PersonID", System.Data.DbType.Int64, reminder.PersonID);
oDatabase.AddInParameter(oCommand, "@ID", System.Data.DbType.Guid, reminder.ID);
oCommand.Connection = connection;
if (oCommand.ExecuteNonQuery() == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
System.Diagnostics.EventLog.WriteEntry("CommunityNewsSummaryRepository", ex.Message);
return(false);
}
}
}
