private List <MultiLanguageInput> ConstructMultiLanguageInputList(long mlIdentifierValue)
{
List <MultiLanguageInput> tempMLIList = new List <MultiLanguageInput>();
MultiLanguageInput mli = null;
SQLParametersList paramsList = new SQLParametersList();
string query = "SELECT L.LanguageID, L.Name, L.MSNetCode, L.JavaLocaleCode, L.PhraseTerm, L.RightToLeftText, T." + MLColumnName + " AS Translation " +
" FROM Languages AS L LEFT JOIN " + MLTableName + " AS T ON T.LanguageID=L.LanguageID AND T." + MLITranslationColumn + "=@MLIdentifierValue " +
" WHERE L.LanguageID in (SELECT TLV.LanguageID FROM TransLanguagesCF_UE AS TLV) " +
" ORDER BY CASE WHEN L.LanguageID=1 THEN 1 ELSE 2 END, L.LanguageID;";
paramsList.Add("@MLIdentifierValue", System.Data.SqlDbType.BigInt).Value = mlIdentifierValue;
DataTable dt = dbAccess.ExecuteQuery(DataBases.LogixRT, System.Data.CommandType.Text, query, paramsList);
foreach (DataRow row in dt.Rows)
{
mli = new MultiLanguageInput();
mli.LanguageID = Convert.ToInt32(row["LanguageID"]);
if (mli.LanguageID == CustomerFacingLangID)
{
mli.Translation = MLDefaultLanguageStandardValue;
}
else
{
mli.Translation = row["Translation"].ToString();
}
mli.Name = (this.Page as AuthenticatedUI).PhraseLib.Lookup(row["PhraseTerm"].ToString(), defaultLanguageId);
mli.MSNetCode = row["MSNetCode"].ToString();
mli.JavaLocaleCode = row["JavaLocaleCode"].ToString();
mli.PhraseTerm = row["PhraseTerm"].ToString();
mli.RightToLeftText = row["RightToLeftText"].ToString();
mli.IdentifierValue = mlIdentifierValue;
tempMLIList.Add(mli);
}
return(tempMLIList);
}
private bool CreateSVPointsProgram(CMS.AMS.Models.SVProgram SVPointsProgram)
{
bool result = false;
SQLParametersList lst = new SQLParametersList();
try
{
if (SVPointsProgram.SVProgramID == 0)
{
lst.Add("@Name", SqlDbType.NVarChar, 200).Value = SVPointsProgram.ProgramName;
lst.Add("@Description", SqlDbType.NVarChar, 200).Value = "";
lst.Add("@ExpirePeriod", SqlDbType.Int).Value = 1;
lst.Add("@Value", SqlDbType.NVarChar, 200).Value = "1";
lst.Add("@OneUnitPerRec", SqlDbType.Bit).Value = 0;
lst.Add("@SVExpireType", SqlDbType.Int).Value = 1;
lst.Add("@SVExpirePeriodType", SqlDbType.Int).Value = 1;
lst.Add("@ExpireTOD", SqlDbType.VarChar, 5).Value = "";
lst.Add("@ExpireDate", SqlDbType.DateTime).Value = Convert.ToDateTime("12/31/2025 23:59");
lst.Add("@ExpireCentralServerTZ", SqlDbType.Bit).Value = 0;
lst.Add("@SVTypeID", SqlDbType.Int).Value = 1;
lst.Add("@UOMLimit", SqlDbType.Int).Value = 1;
lst.Add("@AllowReissue", SqlDbType.Int).Value = 0;
lst.Add("@ScorecardID", SqlDbType.Int).Value = 0;
lst.Add("@ScorecardDesc", SqlDbType.NVarChar, 100).Value = "";
lst.Add("@ScorecardBold", SqlDbType.Bit).Value = 1;
lst.Add("@DisallowRedeemInEarnTrans", SqlDbType.Int).Value = 0;
lst.Add("@AllowNegativeBal", SqlDbType.Int).Value = 0;
lst.Add("@AdjustmentUPC", SqlDbType.NVarChar, 100).Value = "";
lst.Add("@RedemptionRestrictionID", SqlDbType.Int).Value = 0;
lst.Add("@MemberRedemptionID", SqlDbType.Int).Value = 0;
lst.Add("@SVProgramID", SqlDbType.BigInt).Direction = ParameterDirection.Output;
m_dbAccess.ExecuteNonQuery(DataBases.LogixRT, CommandType.StoredProcedure, "pt_StoredValuePrograms_Insert", lst);
SVPointsProgram.SVProgramID = lst["@SVProgramID"].Value.ConvertToLong();
result = true;
if (MyCommon.LRTadoConn.State == ConnectionState.Closed)
{
MyCommon.Open_LogixRT();
}
MyCommon.Activity_Log(26, SVPointsProgram.SVProgramID, CurrentUser.AdminUser.ID, Copient.PhraseLib.Lookup("history-sv-create", LanguageID));
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
MyCommon.Close_LogixRT();
}
lst = null;
return(result);
}
private bool CreatePointsProgram(PointsProgram pointsProgram)
{
bool result = false;
SQLParametersList lst = new SQLParametersList();
try
{
lst.Add("@CAMProgram", SqlDbType.Bit).Value = 0;
lst.Add("@ExternalProgram", SqlDbType.Bit).Value = 0;
lst.Add("@AutoDelete", SqlDbType.Bit).Value = 1;
if (pointsProgram.ProgramID == 0)
{
lst.Add("@ProgramName", SqlDbType.NVarChar, 200).Value = pointsProgram.ProgramName;
lst.Add("@ProgramID", SqlDbType.BigInt).Direction = ParameterDirection.Output;
m_dbAccess.ExecuteNonQuery(DataBases.LogixRT, CommandType.StoredProcedure, "pt_PointsPrograms_Insert", lst);
pointsProgram.ProgramID = lst["@ProgramID"].Value.ConvertToLong();
result = true;
if (MyCommon.LRTadoConn.State == ConnectionState.Closed)
{
MyCommon.Open_LogixRT();
}
MyCommon.Activity_Log(7, pointsProgram.ProgramID, CurrentUser.AdminUser.ID, Copient.PhraseLib.Lookup("history.point-create", LanguageID));
lst = new SQLParametersList();
lst.Add("@ProgramID", SqlDbType.NVarChar, 200).Value = pointsProgram.ProgramID;
lst.Add("@VarID", SqlDbType.BigInt).Direction = ParameterDirection.Output;
m_dbAccess.ExecuteNonQuery(DataBases.LogixXS, CommandType.StoredProcedure, "dbo.pc_PointsVar_Create", lst);
long PromoVarID = lst["@VarID"].Value.ConvertToLong();
if (PromoVarID != 0)
{
MyCommon.QueryStr = " update PointsPrograms with (RowLock) SET " +
" PromoVarID=" + PromoVarID + " " + " where ProgramID=" + pointsProgram.ProgramID + ";";
MyCommon.LRT_Execute();
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
MyCommon.Close_LogixRT();
}
lst = null;
return(result);
}
public string GetLockedSystemOptions(string offerID)
{
SQLParametersList sqlParams = new SQLParametersList();
string sqlQuery = "SELECT (Select EndDate from CPE_Incentives where IncentiveID = @offerID) as EndDate,(Select OptionValue from UE_SystemOptions where OptionID = 80) as OptionValue";
sqlParams.Add("@offerID", SqlDbType.Int).Value = Convert.ToInt32(offerID);
DataTable DT = m_dbAccess.ExecuteQuery(DataBases.LogixRT, CommandType.Text, sqlQuery, sqlParams);
if (DT != null && DT.Rows.Count > 0)
{
if (Convert.ToDateTime(DT.Rows[0]["EndDate"]) <= DateTime.Today && Convert.ToInt32(DT.Rows[0]["OptionValue"]) == 1)
{
return("true");
}
}
return("false");
}
private int GetLanguageId(string javaLocalcode)
{
int langaugeId = 0;
m_logger.WriteInfo("getting language id for given java local code");
string query = "select LanguageID from languages where JavaLocaleCode=@JavaLocaleCode and InstalledForUI=1";
SQLParametersList paramlist = new SQLParametersList();
paramlist.Add("@JavaLocaleCode", SqlDbType.NVarChar, 10).Value = javaLocalcode;
DataTable dt = m_dbaccess.ExecuteQuery(DataBases.LogixRT, CommandType.Text, query, paramlist);
if (dt.Rows.Count > 0)
{
langaugeId = Convert.ToInt32(dt.Rows[0]["LanguageID"]);
}
return(langaugeId);
}
public void Application_Start(object sender, EventArgs e)
{
//Initialize NEP Application
NepServiceApplication.Init();
WebApiConfig.Register(GlobalConfiguration.Configuration);
// Code that runs on application startup
CMS.AMS.ResolverBuilder resolver = new ResolverBuilder();
CurrentRequest.Resolver = resolver.GetResolver();
CurrentRequest.Resolver.AppName = "Global.asax";
IDBAccess m_dbaccess = CurrentRequest.Resolver.Resolve <DBAccess>();
SQLParametersList paramlist = new SQLParametersList();
String QueryStr = "Update Folders set MassOperationStatus = '~FNIU~'";
m_dbaccess.ExecuteNonQuery(DataBases.LogixRT, CommandType.Text, QueryStr, paramlist);
//Adding health monitors
InitializeHealthMonitors();
HealthOptions.AddHealthMonitors(componentHealthMonitors.ToArray());
}
public string GetNotificationList(bool enableRestrictedAccessToUEOB = false, string conditionalQuery = "", bool IsStoreUser = false, string ValidLocIDs = "", string ValidSU = "", int LanguageId = 1, int PageNum = 1, int MaxRecords = 8)
{
string queryStr = "";
string joinStr = "";
string whereStr = "";
SQLParametersList sqlParams = new SQLParametersList();
DataTable ds = new DataTable();
string returnString = "";
//Coverity CID - 93931, 93926, 93923
if (IsStoreUser)
{
//sqlParams = new SQLParametersList();
sqlParams.Add("@ValidLocIDs", SqlDbType.VarChar).Value = ValidLocIDs;
//sqlParams = new SQLParametersList();
sqlParams.Add("@ValidSU", SqlDbType.VarChar).Value = ValidSU;
joinStr = "Inner Join OfferLocUpdate olu with (NoLock) on Table1.OfferID=olu.OfferID ";
whereStr = " where (LocationID in (@ValidLocIDs) or (CreatedByAdminID in (@ValidSU) and Isnull(LocationID,0)=0)) ";
}
queryStr = "SELECT * FROM (select ROW_NUMBER() OVER ( ORDER BY Date, Event ) AS NUMBER, Table1.OfferID, Date, Event, CreatedByAdminID from ( " +
"select OfferID, ProdStartDate as Date, 'starts' as Event, CreatedByAdminID " +
"from Offers as O with (NoLock) " +
"where Deleted = 0 and isnull(isTemplate,0) = 0 and ProdStartDate = CONVERT(datetime, CONVERT(varchar, GETDATE(), 103), 103) " +
"union " +
"select OfferID, ProdEndDate as Date, 'ends' as Event, CreatedByAdminID " +
"from Offers as O with (NoLock) " +
"where Deleted = 0 and isnull(isTemplate, 0) = 0 and ProdEndDate = CONVERT(datetime, CONVERT(varchar, GETDATE(), 103), 103) " +
"union " +
"select IncentiveID as OfferID, StartDate as Date, 'starts' as Event, CreatedByAdminID " +
"from CPE_Incentives as I with (NoLock) " +
"where Deleted=0 and isnull(isTemplate,0)=0 and StartDate=CONVERT(datetime, CONVERT(varchar, GETDATE(), 103), 103) ";
if (enableRestrictedAccessToUEOB && !String.IsNullOrEmpty(conditionalQuery))
{
//sqlParams = new SQLParametersList();
sqlParams.Add("@conditionalQuery", SqlDbType.VarChar).Value = conditionalQuery;
queryStr += "@conditionalQuery ";
}
queryStr += "union " +
"select IncentiveID as OfferID, EndDate as Date, 'ends' as Event, CreatedByAdminID " +
"from CPE_Incentives as I with (NoLock) " +
"where Deleted=0 and isnull(isTemplate,0)=0 and EndDate=CONVERT(datetime, CONVERT(varchar, GETDATE(), 103), 103) ";
if (enableRestrictedAccessToUEOB && !String.IsNullOrEmpty(conditionalQuery))
{
//sqlParams = new SQLParametersList();
sqlParams.Add("@conditionalQuery2", SqlDbType.VarChar).Value = conditionalQuery;
queryStr += "@conditionalQuery2 ";
}
//sqlParams = new SQLParametersList();
sqlParams.Add("@joinStr", SqlDbType.VarChar).Value = joinStr;
//sqlParams = new SQLParametersList();
sqlParams.Add("@whereStr", SqlDbType.VarChar).Value = whereStr;
//sqlParams = new SQLParametersList();
sqlParams.Add("@PageNum", SqlDbType.Int).Value = PageNum;
//sqlParams = new SQLParametersList();
sqlParams.Add("@MaxRecords", SqlDbType.Int).Value = MaxRecords;
queryStr += ") as Table1 @joinStr @whereStr) AS A WHERE NUMBER BETWEEN ((@PageNum - 1) * @MaxRecords + 1) AND (@PageNum * @MaxRecords) ORDER BY Date, Event Desc";
if (joinStr == "")
{
queryStr = queryStr.Replace("@joinStr", "");
}
if (whereStr == "")
{
queryStr = queryStr.Replace("@whereStr", "");
}
ds = m_dbAccess.ExecuteQuery(DataBases.LogixRT, CommandType.Text, queryStr, sqlParams);
foreach (DataRow row in ds.Rows)
{
if (row["Event"].ToString().Equals("starts", StringComparison.InvariantCultureIgnoreCase))
{
returnString += ConstructOutputString(row["OfferID"].ConvertToInt32(), IsShaded, true, LanguageId);
}
else
{
returnString += ConstructOutputString(row["OfferID"].ConvertToInt32(), IsShaded, false, LanguageId);
}
IsShaded = !IsShaded;
}
return(returnString);
}
