internal static bool blnGenerateimintSettlementFile(out long lngimintUpdateStamp) { const string udcErrorMethod = "blnGenerateimintSettlementFile"; string udcMerchantId = clsSettings.Get("IMINT", "MerchantId", "90009796"); string udcTerminalId = clsSettings.Get("IMINT", "TerminalId", "64211677"); const string udcActionCode = "EARN"; //const string udcClassificationCode = "CASH_CASH"; const string udcPaymentType = "CASH"; const string udcUnits = "AMOUNT"; const string udcHasSKUActivity = "0"; lngimintUpdateStamp = 0; try { if (System.IO.Directory.Exists(strFolder) == false) { System.IO.Directory.CreateDirectory(strFolder); } } catch (Exception ex) { clsLog.blnLogError(udcErrorSource, udcErrorMethod, "Error creating imint Directory : " + strFolder, ex.ToString()); return(false); } string strFileName = "", strSettlementDate = ""; ArrayList arlSettlement = new ArrayList(); ArrayList arlPaymentId = new ArrayList(); clsDBEngine objDB = new clsDBEngine(); StreamWriter stwSettlement; System.Text.StringBuilder sbrData; string strSQL = "EXECUTE spGetDataForIMINT"; if (objDB.blnOpenResultSet(strSQL) == true) { if (objDB.blnHasRecords == true) { strSettlementDate = DateTime.Now.ToString("ddMMyyyy"); } while (objDB.blnResultsMoveNextRow() == true) { if (objDB.objResultsValue("Trans_MemberType").ToString() == "IMINT") { sbrData = new System.Text.StringBuilder(); sbrData.Append(objDB.objResultsValue("Trans_MemberNo").ToString() + "|"); sbrData.Append("|||"); sbrData.Append(udcMerchantId + "|"); sbrData.Append("|"); sbrData.Append(udcTerminalId + "|"); sbrData.Append("|"); sbrData.Append((objDB.objResultsValue("Trans_lngId").ToString() + "|")); sbrData.Append("||"); sbrData.Append(udcActionCode + "|"); //sbrData.Append(udcClassificationCode + "|"); sbrData.Append(objDB.objResultsValue("Trans_strIMINTEventType").ToString() + "|"); sbrData.Append("||"); sbrData.Append(udcPaymentType + "|"); sbrData.Append(objDB.objResultsValue("Trans_strDate").ToString() + "|"); sbrData.Append("|"); sbrData.Append(float.Parse(objDB.objResultsValue("Trans_mnyTotal").ToString()).ToString("#") + "|"); sbrData.Append(udcUnits + "|"); sbrData.Append("||"); sbrData.Append(udcHasSKUActivity + "|"); sbrData.Append(strSettlementDate + "|"); sbrData.Append((objDB.objResultsValue("Trans_lngId").ToString() + "|")); sbrData.Append("|||"); sbrData.Append((objDB.objResultsValue("Trans_lngId").ToString() + "|")); sbrData.Append("||||||||"); arlSettlement.Add(sbrData); } else if (objDB.objResultsValue("Trans_MemberType").ToString() == "PB_SAM") { //Add Payback Samsung Base points sbrData = new System.Text.StringBuilder(); sbrData.Append(objDB.objResultsValue("Trans_MemberNo").ToString() + "|"); sbrData.Append("|||"); sbrData.Append(udcMerchantId + "|"); sbrData.Append("|"); sbrData.Append(udcTerminalId + "|"); sbrData.Append("|"); sbrData.Append((objDB.objResultsValue("Trans_lngId").ToString() + "|")); sbrData.Append("||"); sbrData.Append(udcActionCode + "|"); sbrData.Append(objDB.objResultsValue("Trans_strIMINTEventType").ToString() + "|"); sbrData.Append("||"); sbrData.Append(udcPaymentType + "|"); sbrData.Append(objDB.objResultsValue("Trans_strDate").ToString() + "|"); sbrData.Append("|"); sbrData.Append(float.Parse(objDB.objResultsValue("Trans_mnyTotal").ToString()).ToString("#") + "|"); sbrData.Append(udcUnits + "|"); sbrData.Append("||"); sbrData.Append(udcHasSKUActivity + "|"); sbrData.Append(strSettlementDate + "|"); sbrData.Append((objDB.objResultsValue("Trans_lngId").ToString() + "_Samsung_base_point|")); sbrData.Append("|||"); sbrData.Append((objDB.objResultsValue("Trans_lngId").ToString() + "|")); sbrData.Append("||||||||"); arlSettlement.Add(sbrData); //Add Payback Samsung 2X points sbrData = new System.Text.StringBuilder(); sbrData.Append(objDB.objResultsValue("Trans_MemberNo").ToString() + "|"); sbrData.Append("|||"); sbrData.Append(udcMerchantId + "|"); sbrData.Append("|"); sbrData.Append(udcTerminalId + "|"); sbrData.Append("|"); sbrData.Append((objDB.objResultsValue("Trans_lngId").ToString() + "|")); sbrData.Append("||"); sbrData.Append(udcActionCode + "|"); //sbrData.Append(udcClassificationCode + "|"); sbrData.Append("BONUS_POINTS|"); sbrData.Append("||"); sbrData.Append(udcPaymentType + "|"); sbrData.Append(objDB.objResultsValue("Trans_strDate").ToString() + "|"); sbrData.Append("|"); sbrData.Append(float.Parse(objDB.objResultsValue("Trans_mnyTotal").ToString()).ToString("#") + "|"); sbrData.Append(udcUnits + "|"); sbrData.Append("||"); sbrData.Append(udcHasSKUActivity + "|"); sbrData.Append(strSettlementDate + "|"); sbrData.Append((objDB.objResultsValue("Trans_lngId").ToString() + "_Samsung_bonus_point|")); sbrData.Append("|||"); sbrData.Append((objDB.objResultsValue("Trans_lngId").ToString() + "|")); sbrData.Append("||||||||"); arlSettlement.Add(sbrData); } } objDB.blnMoveNextResultSet(); objDB.blnResultsMoveNextRow(); lngimintUpdateStamp = long.Parse(objDB.objResultsValue("Trans_intUpdateStamp").ToString()); if (strSettlementDate.Length > 0) { strFileName = strFolder + "ACTIVITY_IMINT_BIGTREE_" + strSettlementDate + ".txt"; } } else { objDB.blnCloseConnection(); clsLog.blnLogError(udcErrorSource, udcErrorMethod, "Error fetching imint Settlement Data from DB", objDB.strErrorMessage); return(false); } objDB.blnCloseConnection(); if (strFileName.Length > 0) { try { stwSettlement = new StreamWriter(strFileName, false); for (int intCount = 0; intCount < arlSettlement.Count; intCount++) { stwSettlement.WriteLine(arlSettlement[intCount].ToString()); } stwSettlement.Close(); stwSettlement = null; } catch (Exception ex) { stwSettlement = null; clsLog.blnLogError(udcErrorSource, udcErrorMethod, "Error creating imint Settlement File", ex.ToString()); return(false); } } return(true); }
/// <summary> /// Execute the sp and return collection of array the contain companies, cinemas, events and session data for given User /// </summary> /// <param name="strUserLogin"></param> /// <returns></returns> public static string strGetData(string strUserLogin) { clsDBEngine objDB = new clsDBEngine(); string strSQL = "EXEC spForUserData @strUserLogin = '******'"; string strLine = "", strReturnData = ""; int intLineCount = 0; string strArrayName = "arrcompanies"; strLine = "<script type='text/javascript' language='javascript'>"; strLine += "var " + strArrayName + " = new Array();\n"; strReturnData += strLine; if (objDB.blnOpenResultSet(strSQL) == true) { while (objDB.blnResultsMoveNextRow() == true) { strLine = ""; for (int intCount = 0; intCount < objDB.lngResultsNumCols; intCount++) { if (strLine.Length > 0) { strLine += ", "; } string strValue = strConvertForJavaScript(objDB.objResultsValue(intCount).ToString()); strLine += "'" + strValue + "'"; } if (objDB.lngResultsNumCols > 1) { strLine = strArrayName + "[" + intLineCount + "] = new Array(" + strLine + ");\n"; } else { strLine = strArrayName + "[" + intLineCount + "] = " + strLine + ";\n"; } strReturnData += strLine; intLineCount++; } } //For Cinema if (objDB.blnMoveNextResultSet()) { intLineCount = 0; string arrCinema = "arrCinemas"; strReturnData += "var " + arrCinema + " = new Array();\n"; while (objDB.blnResultsMoveNextRow() == true) { strLine = ""; for (int intCount = 0; intCount < objDB.lngResultsNumCols; intCount++) { if (strLine.Length > 0) { strLine += ", "; } string strValue = strConvertForJavaScript(objDB.objResultsValue(intCount).ToString()); strLine += "'" + strValue + "'"; } if (objDB.lngResultsNumCols > 1) { strLine = arrCinema + "[" + intLineCount + "] = new Array(" + strLine + ");\n"; } else { strLine = arrCinema + "[" + intLineCount + "] = " + strLine + ";\n"; } strReturnData += strLine; intLineCount++; } } if (objDB.blnMoveNextResultSet()) { intLineCount = 0; string arrEvents = "arrEvents"; strReturnData += "var " + arrEvents + " = new Array();\n"; while (objDB.blnResultsMoveNextRow() == true) { strLine = ""; for (int intCount = 0; intCount < objDB.lngResultsNumCols; intCount++) { if (strLine.Length > 0) { strLine += ", "; } string strValue = strConvertForJavaScript(objDB.objResultsValue(intCount).ToString()); strLine += "'" + strValue + "'"; } if (objDB.lngResultsNumCols > 1) { strLine = arrEvents + "[" + intLineCount + "] = new Array(" + strLine + ");\n"; } else { strLine = arrEvents + "[" + intLineCount + "] = " + strLine + ";\n"; } strReturnData += strLine; intLineCount++; } } if (objDB.blnMoveNextResultSet()) { intLineCount = 0; string arrSession = "arrSessions"; strReturnData += "var " + arrSession + " = new Array();\n"; while (objDB.blnResultsMoveNextRow() == true) { strLine = ""; for (int intCount = 0; intCount < objDB.lngResultsNumCols; intCount++) { if (strLine.Length > 0) { strLine += ", "; } string strValue = strConvertForJavaScript(objDB.objResultsValue(intCount).ToString()); strLine += "'" + strValue + "'"; } if (objDB.lngResultsNumCols > 1) { strLine = arrSession + "[" + intLineCount + "] = new Array(" + strLine + ");\n"; } else { strLine = arrSession + "[" + intLineCount + "] = " + strLine + ";\n"; } strReturnData += strLine; intLineCount++; } } else { clsLog.blnLogError("clsMisc", "strGetData()", "SQL Failed : " + strSQL, objDB.strErrorMessage); } strReturnData += "</script>"; objDB.blnCloseConnection(); return(strReturnData); }