/// <summary>
/// use to write cancel subscription objects to mongo DB
/// </summary>
/// <returns>true if successful</returns>
public bool WriteunsubscribeData(CancelledSubscription info)
{
try
{
//Write object to Mongo DB Collection
var mongoDatabase = MongoConnection.Connect();
mongoDatabase.GetCollection<CancelledSubscription>(CancelledSubscriptionCollection).Insert(info);
return true;
}
catch (Exception ex)
{
Logger.WriteErrorLog(ex);
return false;
}
}
/// <summary>
/// Unsubscribes User
/// </summary>
/// <param name="_username">User name</param>
/// <param name="_message">comments</param>
/// <returns>true if success</returns>
public bool CancelSubscription(string _username, string _message)
{
try
{
//Update Status in SQL Server
using (var cn = new SqlConnection(@"Data Source=(LocalDB)"))
{
string _sql = @"UPDATE [dbo].[System_Users] SET Active = 0 WHERE [Username] = @e";
var cmd = new SqlCommand(_sql, cn);
cmd.Parameters
.Add(new SqlParameter("@e", SqlDbType.NVarChar))
.Value = _username;
cn.Open();
cmd.ExecuteNonQuery();
}
CancelledSubscription info = new CancelledSubscription();
info.Date = DateTimeOffset.Now;
info.Username = _username;
info.Message = _message;
Mongo MongoWrite = new Mongo();
MongoWrite.WriteunsubscribeData(info);
return true;
}
catch (Exception ex)
{
Logger.WriteErrorLog(ex);
return false;
}
}