public void SetSuperadmin(string eventSessionId, bool enable) { ROMasterDataContext db = new ROMasterDataContext(); Session session = (from s in db.Sessions where s.Id == eventSessionId select s).Single(); session.RegonlineSuperAdmin = enable; db.SubmitChanges(); }
public static string GetEncryptString(string strToEncrypt) { var db = new ROMasterDataContext(ConfigReader.DefaultProvider.EnvironmentConfiguration.ROMasterConnection); return db.fn_Encrypt(strToEncrypt); }
public void VerifyFinalizeBilling(EventType type) { var db = new DataAccess.ROMasterDataContext(ConfigReader.DefaultProvider.EnvironmentConfiguration.ROMasterConnection); var finalBilling = (from i in db.CustomerInvoiceItems where i.EventId == eventId select i).ToList(); if (finalBilling.Count == 0) { Assert.Fail("CustomerInvoiceItems did not return any values, there is no data to verify"); } switch (type) { case EventType.ProEvent: for (int i = 0; i < finalBilling.Count; i++) { VerifyTool.VerifyValue(TxnIntegrityConstants.EventFinalAmount[i].ToString(), finalBilling[i].Amount.ToString(), "Customer Invoice Item Event Amount = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.EventFinalCCAmount[i].ToString(), finalBilling[i].CCAmount.ToString(), "Customer Invoice Item Event CCAmount = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.EventFinalCCCost.ToString(), finalBilling[i].CCCost.ToString(), "Customer Invoice Item Event CCCost = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.EventFinalRegCount[i], finalBilling[i].RegCount, "Customer Invoice Item Event RegCount = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.EventFinalItemId[i], finalBilling[i].ItemId, "Customer Invoice Item Event TypeId = {0}"); } break; case EventType.Membership: for (int i = 0; i < finalBilling.Count; i++) { VerifyTool.VerifyValue(TxnIntegrityConstants.MembershipFinalAmount[i].ToString(), finalBilling[i].Amount.ToString(), "Customer Invoice Item Membership Amount = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.MembershipFinalCCAmount[i].ToString(), finalBilling[i].CCAmount.ToString(), "Customer Invoice Item Membership CCAmount = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.MembershipFinalCCCost.ToString(), finalBilling[i].CCCost.ToString(), "Customer Invoice Item Membership CCCost = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.MembershipFinalRegCount[i], finalBilling[i].RegCount, "Customer Invoice Item Membership RegCount = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.MembershipFinalItemId[i], finalBilling[i].ItemId, "Customer Invoice Item Membership TypeId = {0}"); } break; case EventType.Endurance_USD: for (int i = 0; i < finalBilling.Count; i++) { VerifyTool.VerifyValue(TxnIntegrityConstants.EnduranceFinalAmount[i].ToString(), finalBilling[i].Amount.ToString(), "Customer Invoice Item MerchNonMerch Amount = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.EnduranceFinalCCAmount[i].ToString(), finalBilling[i].CCAmount.ToString(), "Customer Invoice Item MerchNonMerch CCAmount = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.EnduranceFinalCCCost.ToString(), finalBilling[i].CCCost.ToString(), "Customer Invoice Item MerchNonMerch CCCost = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.EnduranceFinalRegCount[i], finalBilling[i].RegCount, "Customer Invoice Item MerchNonMerch RegCount = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.EnduranceFinalItemId[i], finalBilling[i].ItemId, "Customer Invoice Item MerchNonMerch TypeId = {0}"); } break; case EventType.Endurance_Pound: for (int i = 0; i < finalBilling.Count; i++) { if (i > 0) { VerifyTool.VerifyValue(((decimal)(System.Data.SqlTypes.SqlDecimal.Round((TxnIntegrityConstants.DiffCurrencyFinalAmount[i] / Convert.ToDecimal(GetExchangeRate(eventId))), 2))).ToString("0.0000"), finalBilling[i].Amount.ToString(), "Customer Invoice Item DiffCurrencies Amount = {0}"); } else { VerifyTool.VerifyValue(TxnIntegrityConstants.DiffCurrencyFinalAmount[i].ToString(), finalBilling[i].Amount.ToString(), "Customer Invoice Item DiffCurrencies Amount = {0}"); } if (i == 1) { VerifyTool.VerifyValue(((decimal)System.Data.SqlTypes.SqlDecimal.Round((TxnIntegrityConstants.DiffCurrencyFinalCCAmount[i] / Convert.ToDecimal(GetExchangeRate(eventId))),2)).ToString("0.0000"), finalBilling[i].CCAmount.ToString(), "Customer Invoice Item DiffCurrencies CCAmount = {0}"); } else { VerifyTool.VerifyValue(TxnIntegrityConstants.DiffCurrencyFinalCCAmount[i].ToString(), finalBilling[i].CCAmount.ToString(), "Customer Invoice Item DiffCurrencies CCAmount = {0}"); } VerifyTool.VerifyValue(TxnIntegrityConstants.DiffCurrencyFinalCCCost.ToString(), finalBilling[i].CCCost.ToString(), "Customer Invoice Item DiffCurrencies CCCost = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.DiffCurrencyFinalRegCount[i], finalBilling[i].RegCount, "Customer Invoice Item DiffCurrencies RegCount = {0}"); VerifyTool.VerifyValue(TxnIntegrityConstants.DiffCurrencyFinalItemId[i], finalBilling[i].ItemId, "Customer Invoice Item DiffCurrencies TypeId = {0}"); } break; } }
/// <summary> /// Fetch event website url through database /// </summary> /// <param name="eventID"></param> /// <returns></returns> public string Fetch_EventWebsiteUrl(int eventID) { ROMasterDataContext db = new ROMasterDataContext(); Shortcut shortcut = (from s in db.Shortcuts where s.EventId == eventID select s).Single(); return ConfigReader.DefaultProvider.AccountConfiguration.BaseUrl + shortcut.Description; }