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