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 { } }