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