public ActionResult Licence(Guid id)
{
var model = new LicenceModel();
using (var db = new DB())
{
db.CreateCommand("LoadLicence");
db.AddParameter("Guid", SqlDbType.UniqueIdentifier, id);
var result = db.Execute();
result.Read();
model.NoOfLicences = (int)result["NoOfLicences"];
model.LicenceCode = (string)result["Licence"];
}
return View(model);
}
public void SaveAndSendMessage()
{
try
{
using (DB db = new DB())
{
db.CreateCommand("SaveMessage");
db.AddParameter("EmailAddress", System.Data.SqlDbType.NVarChar, Email);
db.AddParameter("MessageType", System.Data.SqlDbType.NVarChar, MessageType);
db.AddParameter("Message", System.Data.SqlDbType.NVarChar, Message);
db.ExecuteNonReader();
db.CommitTransaction();
}
}
catch { }
}
public void Save()
{
try
{
using (var db = new DB())
{
db.CreateCommand("SaveTrialInfo");
db.AddParameter("Guid", SqlDbType.UniqueIdentifier, Guid);
db.AddParameter("UtcDate", SqlDbType.DateTime, UtcDate);
db.AddParameter("LocalDate", SqlDbType.DateTime, LocalDate);
db.AddParameter("Event", SqlDbType.VarChar, Event);
db.ExecuteNonReader();
db.CommitTransaction();
}
}
catch { }
}
private Guid GenerateNewLicence(string email, int copies)
{
var licenceGen = new LicenceGenerator();
var licence = licenceGen.NewLicence(email, copies, new[] { "mongo" });
var guid = Guid.NewGuid();
using (var db = new DB())
{
db.StartTransaction();
db.CreateCommand("UpsertUser");
db.AddParameter("EmailAddress", SqlDbType.NVarChar, email);
var result = db.Execute();
result.Read();
var userId = (long)result["UserId"];
result.Close();
db.CreateCommand("SaveLicence");
db.AddParameter("UserId", SqlDbType.BigInt, userId);
db.AddParameter("Licence", SqlDbType.VarChar, licence);
db.AddParameter("Guid", SqlDbType.UniqueIdentifier, guid);
db.AddParameter("NoOfLicences", SqlDbType.Int, copies);
db.AddParameter("ValidModules", SqlDbType.VarChar, "mongo");
long price = 0;
if (copies < 5)
{
price = copies * 5000;
}
else if (copies < 10)
{
price = copies * 4750;
}
else
{
price = copies * 45;
}
db.AddParameter("Price", SqlDbType.BigInt, price);
db.ExecuteNonReader();
db.CommitTransaction();
}
return guid;
}
private void SaveExchangeRatesToDatabase()
{
try
{
using (DB db = new DB())
{
db.CreateCommand("SaveCurrentExchangeRates");
db.AddParameter("AUD", System.Data.SqlDbType.Float, _aud);
db.AddParameter("CAD", System.Data.SqlDbType.Float, _cad);
db.AddParameter("EUR", System.Data.SqlDbType.Float, _eur);
db.AddParameter("USD", System.Data.SqlDbType.Float, _usd);
db.ExecuteNonReader();
db.CommitTransaction();
}
}
catch { }
}
private void LoadExchangeRatesFromDatabase()
{
try
{
using (DB db = new DB())
{
db.CreateCommand("LoadCurrentExchangeRates");
var reader = db.Execute();
if (reader.Read())
{
_aud = (double)reader["AUD"];
_cad = (double)reader["CAD"];
_eur = (double)reader["EUR"];
_usd = (double)reader["USD"];
_date = (DateTime)reader["Date"];
_success = true;
}
}
}
catch { }
}
private static void DoLogEvent(string eventToken)
{
try
{
using (DB db = new DB())
{
db.CreateCommand("SaveEvent");
db.AddParameter("Event", System.Data.SqlDbType.VarChar, eventToken);
db.ExecuteNonReader();
db.CommitTransaction();
}
}
catch { }
}