protected SQLParamList GetFilters()
{
Dashboard dm = Master as Dashboard;
SQLParamList sqlParams = new SQLParamList();
if (dm != null)
{
sqlParams = dm.GetFilters();
if (dm.IsPropertyUser)
{
SQLParamList sp2 = new SQLParamList();
foreach (SqlParameter sp in sqlParams.ToArray())
{
if (sp.ParameterName.Equals("@Property"))
{
sp2.Add("@PropertyID", (int)User.PropertyShortCode);
}
else
{
sp2.Add(sp);
}
}
sqlParams = sp2;
}
else
{
sqlParams.Add("@PropertyID", (int)PropertyShortCode);
}
}
else
{
sqlParams.Add("@PropertyID", (int)PropertyShortCode);
}
return(sqlParams);
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
string currentSort = RequestVars.Get("s", "F");; //Feedback status
string currentSortDir = RequestVars.Get("d", "D");; //Desc
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
sql.CommandTimeout = 120;
SQLParamList sqlParams = Master.GetFilters()
.Add("@Sort", currentSort)
.Add("@SortDir", currentSortDir);
if (CurrentPage == -1)
{
sqlParams.Add("@ShowAllRows", true);
}
else
{
sqlParams.Add("@Page", CurrentPage)
.Add("@RowsPerPage", ROWS_PER_PAGE);
}
if (txtRecordIDSearch.Text.Length > 0)
{
sqlParams.Add("RecordID", txtRecordIDSearch.Text);
}
DataTable dt = sql.ExecStoredProcedureDataTable("[spFeedback_GetList]", sqlParams);
if (!sql.HasError)
{
Data = dt;
}
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
string currentSort = RequestVars.Get("s", "D");; //Date
string currentSortDir = RequestVars.Get("d", "D");; //Desc
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
SQLParamList sqlParams = Master.GetFilters()
.Add("@Sort", currentSort)
.Add("@SortDir", currentSortDir);
if (CurrentPage == -1)
{
sqlParams.Add("@ShowAllRows", true);
}
else
{
sqlParams.Add("@Page", CurrentPage)
.Add("@RowsPerPage", ROWS_PER_PAGE);
}
DataTable dt = sql.ExecStoredProcedureDataTable("spReports_Survey_List", sqlParams);
if (!sql.HasError)
{
Data = dt;
}
}
public void LogInUser(string usernameOrEmail, string password, bool useEmailForLogin, int clientID, out int outputValue)
{
outputValue = -1;
//Set up the sql request
SQLDatabaseReporting sql = new SQLDatabaseReporting();
SQLParamList sqlParams = new SQLParamList();
sqlParams.Add(useEmailForLogin ? "@Email" : "@Username", usernameOrEmail);
SqlParameter outParam;
sqlParams.Add("@Password", password)
.Add("@ClientID", clientID)
.Add("@IP", RequestVars.GetRequestIPv4Address())
.AddOutputParam("@OutputValue", 4, out outParam);
//Try and get the user's info
DataTable dt = sql.ExecStoredProcedureDataTable("spCOM_WebReportingLogon", sqlParams);
if (!sql.HasError)
{
outputValue = Conversion.StringToInt(outParam.Value.ToString(), -1);
if (outputValue == 0 && dt.Rows.Count > 0)
{
//Success!
SetUserDataFromDr(dt.Rows[0]);
//SessionWrapper.Add<UserInfoModel>("AccountDetail", this);
return;
}
}
UserID = -1;
}
public static void SaveWordCounts(SurveyType surveyType, int recordID, Dictionary <string, int> wordCounts)
{
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
StringBuilder query = new StringBuilder();
SQLParamList sqlParams = new SQLParamList();
int i = 1;
sqlParams.Add("@RecordID", recordID);
foreach (string key in wordCounts.Keys)
{
i += 2;
query.AppendFormat("INSERT INTO [tblSurveyWords] VALUES ({0}, @RecordID, @Word{1}, @Count{1});\n", (int)surveyType, i);
sqlParams.Add("@Word" + i, key).Add("@Count" + i, wordCounts[key]);
if (i >= 2097)
{
//Only ~2100 parameters are allowed
query.Append("DELETE FROM [tblSurveyWords] WHERE Word IN (SELECT [Word] FROM [tblSurveyWords_Banned]);");
sql.NonQuery(query.ToString(), sqlParams);
i = 1;
sqlParams = new SQLParamList().Add("@RecordID", recordID);
}
}
if (i > 1)
{
query.Append("DELETE FROM [tblSurveyWords] WHERE Word IN (SELECT [Word] FROM [tblSurveyWords_Banned]);");
sql.NonQuery(query.ToString(), sqlParams);
}
if (sql.HasError)
{
ErrorHandler.WriteLog("SharedClasses.SurveyTools.SaveWordCounts", String.Format("Unable to save word counts for {0} record ID {1}", surveyType.ToString(), recordID), ErrorHandler.ErrorEventID.SQLError, sql.ExceptionList[0]);
}
}
public void PrepareQuestionForDB(StringBuilder columnList, SQLParamList sqlParams)
{
columnList.AppendFormat(",[{0}]", DBColumn);
if (Checked)
{
sqlParams.Add("@" + DBColumn, DBValue);
}
else
{
sqlParams.Add("@" + DBColumn, DBNull.Value);
}
}
public void AddToQuery(SQLParamList sqlParams)
{
if (IsActive)
{
//Adjust dates from user's timezone
if (BeginDate.HasValue)
{
sqlParams.Add("@" + DBColumn + "_Begin", BeginDate.Value);
}
if (EndDate.HasValue)
{
sqlParams.Add("@" + DBColumn + "_End", EndDate.Value);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int loginUserID = RequestVars.Get <int>("luid", -1);
if (loginUserID >= 0)
{
LoginResponse = TryLogUserIn(loginUserID);
switch (LoginResponse)
{
case LoginErrorCode.Success:
Response.Redirect("/Director.ashx");
break;
case LoginErrorCode.PasswordExpired:
Response.Redirect("/Director.ashx"); //This will redirect to password change
break;
default:
TopMessage.ErrorMessage = LoginResponse.ToString();
break;
}
}
Title = "GCC Users";
Master.HideAllFilters = true;
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
SQLParamList sqlParams = new SQLParamList();
if (CurrentPage == -1)
{
sqlParams.Add("@ShowAllRows", true);
}
else
{
sqlParams.Add("@Page", CurrentPage)
.Add("@RowsPerPage", ROWS_PER_PAGE);
}
if (!String.IsNullOrEmpty(txtNameSearch.Text.Trim()))
{
sqlParams.Add("@TextSearch", txtNameSearch.Text.Trim());
}
DataTable dt = sql.ExecStoredProcedureDataTable("spAdmin_User_List", sqlParams);
if (!sql.HasError)
{
Data = dt;
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
string[] dateDetails = ddlMonthYear.SelectedValue.Split('-');
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
SQLParamList sqlParams = new SQLParamList()
.Add("@Year", dateDetails[0].StringToInt())
.Add("@Month", dateDetails[1].StringToInt());
SqlParameter isNewParam = new SqlParameter("@IsNew", SqlDbType.Bit);
isNewParam.Direction = ParameterDirection.Output;
sqlParams.Add(isNewParam);
DataTable dt = sql.ExecStoredProcedureDataTable("spAdmin_GetGEIWinners", sqlParams);
if (sql.HasError)
{
TopMessage.ErrorMessage = "Unable to query the details from the database.";
}
else
{
string fileName = String.Format("WinnerSelection-{0}.csv", ReportingTools.AdjustAndDisplayDate(DateTime.Now, "yyyy-MM-dd-hh-mm-ss", User));
string fullPath = Server.MapPath(Path.Combine(Config.CacheFileDirectory, fileName));
if (dt.DataTableToCSV(fullPath, true))
{
Response.Clear();
Response.ContentType = "text/csv";
Response.AddHeader("content-disposition", String.Format(@"attachment;filename=""{0}""", fileName));
Response.WriteFile(fullPath);
Response.End();
}
}
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(GUID))
{
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
SQLParamList sqlParams = new SQLParamList();
UserInfo ui = SessionWrapper.Get <UserInfo>("UserInfo");
sqlParams.Add("@GUID", GUID)
.Add("@UpdateLastViewedTime", !(ui != null || RequestVars.Get <string>("a", null) != null));
DataSet ds = sql.ExecStoredProcedureDataSet("[spFeedback_GetGuestItem]", sqlParams);
if (!sql.HasError)
{
Data = ds;
GCCPropertyShortCode sc = (GCCPropertyShortCode)Conversion.StringToInt(ds.Tables[0].Rows[0]["PropertyID"].ToString(), 1);
Master.ForceSpecificProperty = sc;
MessageTimeline.PropertyShortCode = sc;
MessageTimeline.Messages = ds.Tables[1];
int feedbackStatus = Conversion.StringToInt(ds.Tables[0].Rows[0]["FeedbackStatusID"].ToString());
MessageTimeline.HideReplyBox = ui != null || RequestVars.Get <string>("a", null) != null;
Title = PropertyTools.GetCasinoName((int)sc) + " Feedback";
}
}
}
public void AddToQuery(SQLParamList sqlParams)
{
if (IsActive)
{
sqlParams.Add("@" + DBColumn, SelectedValue);
}
}
protected bool SaveData(out int rowID)
{
StringBuilder columnList = new StringBuilder();
SQLParamList sqlParams = new SQLParamList();
fbkEmail.PrepareQuestionForDB(columnList, sqlParams);
fbkProperty.PrepareQuestionForDB(columnList, sqlParams);
radGAG_Everett.PrepareQuestionForDB(columnList, sqlParams);
radGAG_Lakewood.PrepareQuestionForDB(columnList, sqlParams);
radGAG_Tukwila.PrepareQuestionForDB(columnList, sqlParams);
radGAG_DeMoines.PrepareQuestionForDB(columnList, sqlParams);
fbkQ1.PrepareQuestionForDB(columnList, sqlParams);
fbkQ2.PrepareQuestionForDB(columnList, sqlParams);
fbkQ3.PrepareQuestionForDB(columnList, sqlParams);
fbkQ4.PrepareQuestionForDB(columnList, sqlParams);
fbkQ5.PrepareQuestionForDB(columnList, sqlParams);
txtName.PrepareQuestionForDB(columnList, sqlParams);
txtTelephoneNumber.PrepareQuestionForDB(columnList, sqlParams);
txtEmailContact.PrepareQuestionForDB(columnList, sqlParams);
// fbkDirectQuestion.PrepareQuestionForDB(columnList, sqlParams);
columnList.Append(",[PropertyID],[DateEntered]");
sqlParams.Add("@PropertyID", Master.PropertyID)
.Add("@DateEntered", DateTime.Now);
if (IsStaffSurvey)
{
columnList.Append(",[StaffMemberID]");
sqlParams.Add("@StaffMemberID", User.UserID);
ddlStaffContact.PrepareQuestionForDB(columnList, sqlParams);
}
columnList.Remove(0, 1);
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
rowID = sql.QueryAndReturnIdentity(String.Format("INSERT INTO [tblSurveyFeedback] ({0}) VALUES ({1});", columnList, columnList.ToString().Replace("[", "@").Replace("]", String.Empty)), sqlParams);
if (!sql.HasError && rowID != -1)
{
Dictionary <string, int> wordCounts = SurveyTools.GetWordCount(fbkQ3.Text);
SurveyTools.SaveWordCounts(SharedClasses.SurveyType.Feedback, rowID, wordCounts);
return(true);
}
else
{
return(false);
}
}
public void PrepareQuestionForDB(StringBuilder columnList, SQLParamList sqlParams)
{
if (SelectedValue != -1)
{
columnList.AppendFormat(",[{0}]", DBColumn);
sqlParams.Add("@" + DBColumn, GetValue());
}
}
public void PrepareQuestionForDB(StringBuilder columnList, SQLParamList sqlParams)
{
if (Checked && !String.IsNullOrEmpty(DBColumn))
{
columnList.AppendFormat(",[{0}]", DBColumn);
sqlParams.Add("@" + DBColumn, DBValue);
}
}
/// <summary>
/// Get all users list
/// </summary>
/// <returns></returns>
public DataTable GetUsersList(int userId)
{
SQLDatabaseReporting sql = new SQLDatabaseReporting();
SQLParamList sqlParams = new SQLParamList();
sqlParams.Add("@UserID", userId);
sqlParams.Add("@TextSearch", null);
DataTable dt = sql.ExecStoredProcedureDataTable("spAdmin_User_List", sqlParams);
if (!sql.HasError)
{
return(dt);
}
return(null);
}
/// <summary>
/// Get Report per question based on month
/// </summary>
/// <returns></returns>
public static DataTable GetMonthlyRecordOfQuestion(string rptType, string QsnId, int fromMnth, int toMnth)
{
SQLDatabaseReporting sql = new SQLDatabaseReporting();
SQLParamList sqlParams = new SQLParamList();
sqlParams.Add("@ReportSelection", rptType);
sqlParams.Add("@Question", QsnId);
sqlParams.Add("@FromMnth", fromMnth);
sqlParams.Add("@ToMnth", toMnth);
DataTable dt = sql.ExecStoredProcedureDataTable("sp_GetMonthlyRecordsOfQuestion", sqlParams);
if (!sql.HasError)
{
return(dt);
}
return(null);
}
protected void LoadData()
{
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
SQLParamList sqlParams = Master.GetFilters();
sqlParams.Add("@IsCompetitor", RequestVars.Get <int>("competitor", 0));
sqlParams.Add("@IsPositive", RequestVars.Get <int>("positive", 0));
sqlParams.Add("@IsNegative", RequestVars.Get <int>("negative", 0));
string keyword = RequestVars.Get <string>("keyword", "");
if (keyword != "")
{
sqlParams.Add("@SpecificKeyword", keyword);
}
Data = sql.ExecStoredProcedureDataSet("spGetSocialMediaData", sqlParams);
if (Data.Tables.Count > 0)
{
Master.RecordCount = Data.Tables[0].Rows.Count.ToString();
}
}
/// <summary>
/// Delete user from list
/// </summary>
/// <returns></returns>
public static int DeleteUser(int userID)
{
SQLDatabaseReporting sql = new SQLDatabaseReporting();
SQLParamList sqlParams = new SQLParamList();
SqlParameter output;
SqlParameter rowsUpdated;
sqlParams.Add("@UserID", userID);
sqlParams.Add("@ClientID", Config.clientId);
sqlParams.AddOutputParam("@OutputCode", 4, out output);
sqlParams.AddOutputParam("@RowCount", 4, out rowsUpdated);
DataTable dt = sql.ExecStoredProcedureDataTable("spCOM_DeleteUser", sqlParams);
if (!sql.HasError)
{
return(Convert.ToInt32(dt.Rows[0]["AffectedRows"]));
}
return(0);
}
public void AddToQuery(SQLParamList sqlParams)
{
if (ReplaceAddToQuery != null)
{
ReplaceAddToQuery(this, sqlParams);
}
else
{
if (IsActive)
{
if (IsNumericTableType)
{
DataTable dt = new DataTable();
dt.Columns.Add("Number", typeof(Int32));
foreach (int i in GetSelectedIndices())
{
DataRow dr = dt.NewRow();
dr["Number"] = Conversion.StringToInt(Items[i].Value, -1);
dt.Rows.Add(dr);
}
SqlParameter sqlP = new SqlParameter("@" + DBColumn, dt);
sqlP.SqlDbType = SqlDbType.Structured;
sqlParams.Add(sqlP);
}
else
{
StringBuilder sb = new StringBuilder();
foreach (int i in GetSelectedIndices())
{
sb.AppendFormat(",{0}", Items[i].Value);
}
if (sb.Length > 1)
{
sb.Remove(0, 1);
}
sqlParams.Add("@" + DBColumn, sb.ToString());
}
}
}
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(GUID))
{
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
SQLParamList sqlParams = new SQLParamList();
sqlParams.Add("@GUID", GUID);
DataSet ds = sql.ExecStoredProcedureDataSet("[spFeedback_GetItem]", sqlParams);
if (!sql.HasError)
{
Data = ds;
//Check permissions
GCCPropertyShortCode sc = (GCCPropertyShortCode)Data.Tables[0].Rows[0]["PropertyID"].ToString().StringToInt(1);
if ((User.Group == UserGroups.PropertyManagers && User.PropertyShortCode != sc && User.PropertyShortCode != GCCPropertyShortCode.None) ||
(User.Group == UserGroups.PropertyStaff && User.PropertyShortCode != sc)
)
{
Data = null;
TopMessage.ErrorMessage = "You do not have permission to view this piece of feedback.";
TopMessage.TitleOverride = "Unauthorized";
return;
}
MessageTimeline.Messages = ds.Tables[1];
int feedbackStatus = Conversion.StringToInt(ds.Tables[0].Rows[0]["FeedbackStatusID"].ToString());
MessageTimeline.HideReplyBox = IssueIsClosed;
MessageTimeline.PropertyShortCode = (GCCPropertyShortCode)ds.Tables[0].Rows[0]["PropertyID"].ToString().StringToInt(1);
//Reset tier DDL item labels
ddlTier.Items[0].Text = "Tier 1";
ddlTier.Items[1].Text = "Tier 2";
ddlTier.Items[2].Text = "Tier 3";
//Set the selected values and append " (Current)" to the current one for this record
ddlTier.SelectedValue = Data.Tables[0].Rows[0]["Tier"].ToString();
hdnOldTier.Value = ddlTier.SelectedValue;
ddlTier.SelectedItem.Text += " (Current)";
//Add JS check to notify the user what happens on change to Tier 3
btnSaveTier.OnClientClick = "var oldTier=" + ds.Tables[0].Rows[0]["Tier"] + ",newTier=parseInt($('#" + ddlTier.ClientID + "').val());if(oldTier!=newTier&&3==newTier&&!confirm('Are you sure you want to set this to Tier 3? This will cause a notification to be sent to the appropriate staff members.'))return false;";
//Hide Invalid Button if Case Closed
if (IssueIsClosed)
{
//Work in progress
//btnShowInvalidModal.Visible = false;
}
}
}
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
sql.CommandTimeout = 120;
SQLParamList sqlParams = GetFilters();
if (PropertyShortCode == GCCPropertyShortCode.GCC)
{
sqlParams.Add("@RestaurantID", ddlSelectedLocation.SelectedValue);
}
DataSet ds = sql.ExecStoredProcedureDataSet("[spReports_FoodAndBev]", sqlParams);
if (!sql.HasError)
{
DataFull = ds;
//Set the dashboard counts
if (PropertyShortCode == GCCPropertyShortCode.GCC)
{
//Set it up if we're looking at all locations
Data = ds.Tables[1];
}
else
{
Data = ds.Tables[0];
//Set it up if we're looking at a particular location
if (!IsPostBack)
{
for (int i = 0; i < 13; i++)
{
string name;
if (PropertyTools.HasFoodAndBev(PropertyShortCode, i + 1, out name))
{
ddlSelectedLocation.Items[i].Enabled = true;
ddlSelectedLocation.Items[i].Text = name;
}
else
{
ddlSelectedLocation.Items[i].Enabled = false;
}
}
}
}
if (Data.Rows.Count > 0)
{
string suffix = PropertyShortCode == GCCPropertyShortCode.GCC ? String.Empty : "_M" + SelectedMention;
Master.RecordCount = Data.Rows[0]["Count" + suffix].ToString();
}
}
}
/// <summary>
/// Get list of Call Center follow-up questions
/// </summary>
/// <returns></returns>
public static DataTable GetQuestions(string rptType)
{
SQLDatabaseReporting sql = new SQLDatabaseReporting();
SQLParamList sqlParams = new SQLParamList();
sqlParams.Add("@ReportType", rptType);
DataTable dt = sql.ExecStoredProcedureDataTable("spAdmin_Question_List", sqlParams);
if (!sql.HasError)
{
return(dt);
}
return(null);
}
public void AddToQuery(SQLParamList sqlParams)
{
if (ReplaceAddToQuery != null)
{
ReplaceAddToQuery(this, sqlParams);
}
else
{
if (IsActive)
{
//if ( IsExactSearch ) {
// sqlParams.Add( "@" + DBColumn, Text );
//} else {
sqlParams.Add("@" + DBColumn, Text.Replace(@"\", @"\\").Replace(@"%", @"\%").Replace(@"_", @"\_"));
//}
}
}
}
/// <summary>
/// Update user
/// </summary>
/// <returns></returns>
public static string UpdateUser(int userId, int modifiedUserID, string firstName, string lastName, string email, string phone, int groupId, int status)
{
SQLDatabaseReporting sql = new SQLDatabaseReporting();
SQLParamList sqlParams = new SQLParamList();
sqlParams.Add("@UserID", userId);
sqlParams.Add("@FirstName", firstName);
sqlParams.Add("@LastName", lastName);
sqlParams.Add("@Email", email);
sqlParams.Add("@Phone", phone);
sqlParams.Add("@ModifiedUserID", modifiedUserID);
sqlParams.Add("@GroupID", groupId);
sqlParams.Add("@Active", status);
sql.ExecStoredProcedureDataTable("spAdmin_User_Update", sqlParams);
if (sql.HasError)
{
return(UserResource.Error_UnableToUpdateUser);
}
else
{
return(UserResource.Message_UpdateSuccess);
}
}
protected bool SaveData(out int rowID)
{
StringBuilder columnList = new StringBuilder();
SQLParamList sqlParams = new SQLParamList();
radQ1_Slots.PrepareQuestionForDB(columnList, sqlParams);
radQ1_Tables.PrepareQuestionForDB(columnList, sqlParams);
radQ1_Poker.PrepareQuestionForDB(columnList, sqlParams);
radQ1_Food.PrepareQuestionForDB(columnList, sqlParams);
radQ1_Entertainment.PrepareQuestionForDB(columnList, sqlParams);
radQ1_Hotel.PrepareQuestionForDB(columnList, sqlParams);
radQ1_LiveRacing.PrepareQuestionForDB(columnList, sqlParams);
radQ1_Racebook.PrepareQuestionForDB(columnList, sqlParams);
radQ1_Bingo.PrepareQuestionForDB(columnList, sqlParams);
radQ1_Lottery.PrepareQuestionForDB(columnList, sqlParams);
radQ1_None.PrepareQuestionForDB(columnList, sqlParams);
chkQ2_Slots.PrepareQuestionForDB(columnList, sqlParams);
chkQ2_Tables.PrepareQuestionForDB(columnList, sqlParams);
chkQ2_Poker.PrepareQuestionForDB(columnList, sqlParams);
chkQ2_Food.PrepareQuestionForDB(columnList, sqlParams);
chkQ2_Entertainment.PrepareQuestionForDB(columnList, sqlParams);
chkQ2_Hotel.PrepareQuestionForDB(columnList, sqlParams);
chkQ2_LiveRacing.PrepareQuestionForDB(columnList, sqlParams);
chkQ2_Racebook.PrepareQuestionForDB(columnList, sqlParams);
chkQ2_Bingo.PrepareQuestionForDB(columnList, sqlParams);
chkQ2_Lottery.PrepareQuestionForDB(columnList, sqlParams);
Q7A.PrepareQuestionForDB(columnList, sqlParams);
Q7B.PrepareQuestionForDB(columnList, sqlParams);
Q7C.PrepareQuestionForDB(columnList, sqlParams);
Q7D.PrepareQuestionForDB(columnList, sqlParams);
Q7E.PrepareQuestionForDB(columnList, sqlParams);
Q7F.PrepareQuestionForDB(columnList, sqlParams);
Q8.PrepareQuestionForDB(columnList, sqlParams);
Q36Male.PrepareQuestionForDB(columnList, sqlParams);
Q36Female.PrepareQuestionForDB(columnList, sqlParams);
Q37_1.PrepareQuestionForDB(columnList, sqlParams);
Q37_2.PrepareQuestionForDB(columnList, sqlParams);
Q37_3.PrepareQuestionForDB(columnList, sqlParams);
Q37_4.PrepareQuestionForDB(columnList, sqlParams);
Q37_5.PrepareQuestionForDB(columnList, sqlParams);
Q37_6.PrepareQuestionForDB(columnList, sqlParams);
if (SurveyType == GSEISurveyType.GA)
{
radLocation_Lakewood.PrepareQuestionForDB(columnList, sqlParams);
radLocation_Tukwila.PrepareQuestionForDB(columnList, sqlParams);
radLocation_Everett.PrepareQuestionForDB(columnList, sqlParams);
radLocation_DeMoines.PrepareQuestionForDB(columnList, sqlParams);
}
columnList.Append(",[SurveyType],[PropertyID],[DateEntered],[PIN],[BenchmarkYear]");
sqlParams.Add("@SurveyType", (int)GEISurveyType.Email)
.Add("@PropertyID", (int)Master.PropertyShortCode)
.Add("@DateEntered", DateTime.Now)
.Add("@PIN", Master.EmailPIN)
.Add("@BenchmarkYear", 2017);
if (Master.EmailPINRow != null)
{
columnList.Append(",[EmailBatch]");
sqlParams.Add("@EmailBatch", Master.EmailPINRow["BatchID"]);
}
columnList.Remove(0, 1);
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
rowID = sql.QueryAndReturnIdentity(String.Format("INSERT INTO [tblSurveyGEI] ({0}) VALUES ({1});", columnList, columnList.ToString().Replace("[", "@").Replace("]", String.Empty)), sqlParams);
if (!sql.HasError && rowID != -1)
{
sql.NonQuery("UPDATE [tblSurveyGEI_EmailPINs] SET [SurveyCompleted] = 1 WHERE PIN = @PIN", new SqlParameter("@PIN", Master.EmailPIN));
if (sql.HasError)
{
//TODO: Do we want to do something here?
}
return(true);
}
else
{
return(false);
}
}
protected void btnReloadData_Click(object sender, EventArgs e)
{
SQLDatabase sql_keywords = new SQLDatabase();
DataTable dt = sql_keywords.QueryDataTable("SELECT PropertyID, Keyword, Includes FROM tblGCC_SocialMediaKeywords");
if (sql_keywords.HasError)
{
mmMessage.ErrorMessage = "There was a database error loading property keywords. Please try again later.";
return;
}
else
{
foreach (DataRow dr in dt.Rows)
{
string keyword = dr["Keyword"].ToString();
string includes = dr["Includes"].ToString();
int propertyID = Conversion.StringToInt(dr["PropertyID"].ToString());
json = new WebClient().DownloadString(String.Format("http://api.trackur.com/api/v2/?api_key=65c0c2c7-2ea2-4f7c-b50f-c9bec7b6ad7b&keyword={0}&includes={1}&limit=100", keyword, includes));
json = json.Trim();
JObject o = JObject.Parse(json);
if (o["results"] != null)
{
List <object> results = o["results"].ToList <object>();
foreach (object result in results)
{
JObject parsed_result = JObject.Parse(result.ToString());
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
SQLParamList sqlParams = new SQLParamList();
sqlParams.Add("@keyword", keyword);
sqlParams.Add("@propertyID", propertyID);
sqlParams.Add("@id", parsed_result["id"].ToString());
sqlParams.Add("@title", parsed_result["title"].ToString());
sqlParams.Add("@source", parsed_result["source"].ToString());
string published = parsed_result["published"].ToString();
DateTime published_date;
if (!DateTime.TryParse(published, null,
DateTimeStyles.None, out published_date))
{
published_date = DateTime.MinValue;
}
sqlParams.Add("@published", published_date);
sqlParams.Add("@url", parsed_result["url"].ToString());
sqlParams.Add("@influence", DBNull.Value);
sqlParams.Add("@content", parsed_result["content"].ToString());
sqlParams.Add("@sentiment", parsed_result["sentiment"].ToString());
sqlParams.Add("@location", parsed_result["location"].ToString());
sql.ExecStoredProcedureDataSet("[spMergeSocialMedia]", sqlParams);
if (sql.HasError)
{
mmMessage.ErrorMessage = "There was a database error. Please try again later.";
return;
}
}
}
}
}
mmMessage.InfoMessage = "Data loaded successfully.";
}
protected bool SaveData(out int rowID)
{
StringBuilder columnList = new StringBuilder();
SQLParamList sqlParams = new SQLParamList();
Q1.PrepareQuestionForDB(columnList, sqlParams);
if (Session["CurrentUI"].ToString() == "fr-CA")
{
Q2_F.PrepareQuestionForDB(columnList, sqlParams);
}
else
{
Q2.PrepareQuestionForDB(columnList, sqlParams);
}
Q3.PrepareQuestionForDB(columnList, sqlParams);
Q4.PrepareQuestionForDB(columnList, sqlParams);
Q5Name.PrepareQuestionForDB(columnList, sqlParams);
Q5Title.PrepareQuestionForDB(columnList, sqlParams);
Q5Telephone.PrepareQuestionForDB(columnList, sqlParams);
Q5Email.PrepareQuestionForDB(columnList, sqlParams);
Q6Street.PrepareQuestionForDB(columnList, sqlParams);
Q6City.PrepareQuestionForDB(columnList, sqlParams);
Q6Province.PrepareQuestionForDB(columnList, sqlParams);
Q6PostalCode.PrepareQuestionForDB(columnList, sqlParams);
Q7.PrepareQuestionForDB(columnList, sqlParams);
Q8.PrepareQuestionForDB(columnList, sqlParams);
Q9A.PrepareQuestionForDB(columnList, sqlParams);
Q9B.PrepareQuestionForDB(columnList, sqlParams);
Q9C.PrepareQuestionForDB(columnList, sqlParams);
Q9C_Explanation.PrepareQuestionForDB(columnList, sqlParams);
Q10.PrepareQuestionForDB(columnList, sqlParams);
Q11A_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11A_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11B_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11B_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11C_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11C_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
//Q11D_PastSupport.PrepareQuestionForDB( columnList, sqlParams );
//Q11D_CurrentRequest.PrepareQuestionForDB( columnList, sqlParams );
Q11E_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11E_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11F_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11F_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11G_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11G_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11H_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11H_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11I_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11I_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11J_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11J_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11K_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11K_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11L_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11L_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11M_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11M_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
//2017-11-14 Adding 3 new ontario locations
Q11N_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11N_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11O_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11O_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11P_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11P_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11Q_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11Q_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11R_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11R_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11S_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11S_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11T_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11T_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11U_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11U_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11V_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11V_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11W_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11W_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11X_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11X_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11Y_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11Y_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q11Z_PastSupport.PrepareQuestionForDB(columnList, sqlParams);
Q11Z_CurrentRequest.PrepareQuestionForDB(columnList, sqlParams);
Q12.PrepareQuestionForDB(columnList, sqlParams);
Q13.PrepareQuestionForDB(columnList, sqlParams);
Q14.PrepareQuestionForDB(columnList, sqlParams);
columnList.Append(",[PropertyID],[DateEntered]");
sqlParams.Add("@PropertyID", Master.PropertyID)
.Add("@DateEntered", DateTime.Now);
columnList.Remove(0, 1);
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
rowID = sql.QueryAndReturnIdentity(String.Format("INSERT INTO [tblSurveyDonation] ({0}) VALUES ({1});", columnList, columnList.ToString().Replace("[", "@").Replace("]", String.Empty)), sqlParams);
return(!sql.HasError && rowID != -1);
}
protected void btnExport_Click(object sender, EventArgs e)
{
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
SQLParamList sqlParams = new SQLParamList()
.Add("@DateRange_Begin", drDateRange.BeginDate)
.Add("@DateRange_End", Convert.ToDateTime(drDateRange.EndDate))
.Add("@SurveyType", ddlSurvey.SelectedValue);
if (ddlProperty.SelectedIndex == 0)
{
sqlParams.Add("@PropertyID", DBNull.Value);
}
else
{
sqlParams.Add("@PropertyID", ddlProperty.SelectedValue);
}
DataSet ds = sql.ExecStoredProcedureDataSet("spData_Export", sqlParams);
if (sql.HasError)
{
TopMessage.ErrorMessage = "Oops. Something went wrong when exporting the data. Please try again. (EDE100)";
}
else
{
string lFileName = string.Format("{0}_{1}", ddlSurvey.SelectedItem.Text, ReportingTools.AdjustAndDisplayDate(DateTime.Now, "yyyy-MM-dd-hh-mm-ss", User));
const string lPath = "~/Files/Cache/";
string lOutput = string.Concat(MapPath(lPath), lFileName);
using (CSVWriter csv = new CSVWriter(lOutput + ".csv"))
{
csv.WriteLine("{0} Data Extract", ddlSurvey.SelectedItem.Text);
csv.WriteLine("Date Range: {0}", drDateRange.BeginDate.HasValue ? String.Format("{0} - {1}", drDateRange.BeginDate.Value.ToString("yyyy-MM-dd"), drDateRange.EndDate.Value.ToString("yyyy-MM-dd")) : "All");
csv.WriteLine("Property: {0}", ddlProperty.SelectedItem.Text);
//CSVRow longLabelRow = new CSVRow();
//CSVRow shortLabelRow = new CSVRow();
CSVRow headerRow = new CSVRow();
foreach (DataColumn dc in ds.Tables[0].Columns)
{
headerRow.Add(dc.ColumnName);
string kv = dc.ColumnName;
//if ( QuestionLookup.ContainsKey( kv ) ) {
// string[] vals = QuestionLookup[kv].Split( '|' );
// longLabelRow.Add( vals[0] );
// if ( vals.Length > 1 ) {
// shortLabelRow.Add( vals[1] );
// } else {
// shortLabelRow.Add( vals[1] );
// }
//} else {
// longLabelRow.Add( "" );
// shortLabelRow.Add( "" );
//}
}
//csv.WriteRow( longLabelRow );
//csv.WriteRow( shortLabelRow );
csv.WriteRow(headerRow);
int colCount = ds.Tables[0].Columns.Count;
foreach (DataRow dr in ds.Tables[0].Rows)
{
CSVRow row = new CSVRow();
for (int i = 0; i < colCount; i++)
{
row.Add(dr[i].ToString());
}
csv.WriteRow(row);
}
csv.Close();
csv.Dispose();
}
//Conversion.DataTableToExcel(lResultSet, ddlQID.SelectedItem.Text, lOutput, true);
hlDownload.Text = "Download File - " + String.Concat(lFileName, ".csv");
hlDownload.NavigateUrl = String.Format("{0}{1}", lPath, String.Concat(lFileName, ".csv"));
}
}
protected bool SaveData(out int rowID)
{
StringBuilder columnList = new StringBuilder();
SQLParamList sqlParams = new SQLParamList();
//Add details for email surveys
//if (SurveyType == GEISurveyType.Email)
//{
// columnList.Append(",[EmailBatch],[PIN]");
// sqlParams.Add("@EmailBatch", EmailPINRow["BatchID"])
// .Add("@PIN", EmailPIN);
// if (String.IsNullOrWhiteSpace(txtQ4_CardNumber.Text))
// {
// //If they erased the encore number, we'll put in a new one
// Q4.SelectedValue = 1;
// txtQ4_CardNumber.Text = EmailPINRow["Encore"].ToString();
// }
//}
txtEmail.PrepareQuestionForDB(columnList, sqlParams);
Q1_1.PrepareQuestionForDB(columnList, sqlParams);
Q1_2to4.PrepareQuestionForDB(columnList, sqlParams);
Q1_5to9.PrepareQuestionForDB(columnList, sqlParams);
Q1_10.PrepareQuestionForDB(columnList, sqlParams);
Q2_No.PrepareQuestionForDB(columnList, sqlParams);
Q2_Yes.PrepareQuestionForDB(columnList, sqlParams);
Q3_No.PrepareQuestionForDB(columnList, sqlParams);
Q3_Yes.PrepareQuestionForDB(columnList, sqlParams);
Q4_Yes.PrepareQuestionForDB(columnList, sqlParams);
Q4_No.PrepareQuestionForDB(columnList, sqlParams);
Q4_EncoreNumber.PrepareQuestionForDB(columnList, sqlParams);
Q5_Tarmac.PrepareQuestionForDB(columnList, sqlParams);
Q5_BoxSeats.PrepareQuestionForDB(columnList, sqlParams);
Q5_GroupPatio.PrepareQuestionForDB(columnList, sqlParams);
Q5_MarqueeTent.PrepareQuestionForDB(columnList, sqlParams);
Q5_SilksBuffet.PrepareQuestionForDB(columnList, sqlParams);
Q5_DiamondClub.PrepareQuestionForDB(columnList, sqlParams);
Q6_Excellent.PrepareQuestionForDB(columnList, sqlParams);
Q6_VeryGood.PrepareQuestionForDB(columnList, sqlParams);
Q6_Good.PrepareQuestionForDB(columnList, sqlParams);
Q6_Fair.PrepareQuestionForDB(columnList, sqlParams);
Q6_Poor.PrepareQuestionForDB(columnList, sqlParams);
Q7_Excellent.PrepareQuestionForDB(columnList, sqlParams);
Q7_VeryGood.PrepareQuestionForDB(columnList, sqlParams);
Q7_Good.PrepareQuestionForDB(columnList, sqlParams);
Q7_Fair.PrepareQuestionForDB(columnList, sqlParams);
Q7_Poor.PrepareQuestionForDB(columnList, sqlParams);
Q8_DefinitelyWould.PrepareQuestionForDB(columnList, sqlParams);
Q8_ProbablyWould.PrepareQuestionForDB(columnList, sqlParams);
Q8_MightMightNot.PrepareQuestionForDB(columnList, sqlParams);
Q8_ProbablyWouldNot.PrepareQuestionForDB(columnList, sqlParams);
Q8_DefinitelyWouldNot.PrepareQuestionForDB(columnList, sqlParams);
Q9_Male.PrepareQuestionForDB(columnList, sqlParams);
Q9_Female.PrepareQuestionForDB(columnList, sqlParams);
Q10_19to24.PrepareQuestionForDB(columnList, sqlParams);
Q10_25to34.PrepareQuestionForDB(columnList, sqlParams);
Q10_35to44.PrepareQuestionForDB(columnList, sqlParams);
Q10_45to54.PrepareQuestionForDB(columnList, sqlParams);
Q10_55to64.PrepareQuestionForDB(columnList, sqlParams);
Q10_65orOlder.PrepareQuestionForDB(columnList, sqlParams);
Q11_35000.PrepareQuestionForDB(columnList, sqlParams);
Q11_35000to59999.PrepareQuestionForDB(columnList, sqlParams);
Q11_60000to89999.PrepareQuestionForDB(columnList, sqlParams);
Q11_90000.PrepareQuestionForDB(columnList, sqlParams);
Q11_NoSay.PrepareQuestionForDB(columnList, sqlParams);
Q12_PostalCode.PrepareQuestionForDB(columnList, sqlParams);
Q13_FirstName.PrepareQuestionForDB(columnList, sqlParams);
Q13_LastName.PrepareQuestionForDB(columnList, sqlParams);
Q13_Email.PrepareQuestionForDB(columnList, sqlParams);
columnList.Append(",[PropertyID],[DateEntered]");
sqlParams.Add("@PropertyID", 5)
.Add("@DateEntered", DateTime.Now);
columnList.Remove(0, 1);
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
rowID = sql.QueryAndReturnIdentity(String.Format("INSERT INTO [tblHastingsSurvey] ({0}) VALUES ({1});", columnList, columnList.ToString().Replace("[", "@").Replace("]", String.Empty)), sqlParams);
if (!sql.HasError && rowID != -1)
{
//Dictionary<string, int> wordCounts = SurveyTools.GetWordCount(Q11.Text, txtQ27A_OtherExplanation.Text, txtQ27B.Text, Q32.Text, Q34.Text, Q35.Text, Q39_16Explanation.Text);
//SurveyTools.SaveWordCounts(SharedClasses.SurveyType.GEI, rowID, wordCounts);
return(true);
}
else
{
return(false);
}
}
protected bool SaveData()
{
StringBuilder columnList = new StringBuilder();
SQLParamList sqlParams = new SQLParamList();
if (QueryPropertyShortCode == GCCPropertyShortCode.GCC || (QueryPropertyShortCode == GCCPropertyShortCode.GAG && QueryGAGLocation == GLocation.None))
{
//User had to select location
string propSel = fbkProperty.SelectedValue;
if (propSel.Length > 3)
{
//GAG
if (propSel.Substring(0, 2).Equals("13"))
{
columnList.AppendFormat(",[{0}]", fbkProperty.DBColumn);
sqlParams.Add("@" + fbkProperty.DBColumn, 13);
}
}
else
{
fbkProperty.PrepareQuestionForDB(columnList, sqlParams);
}
}
ddlDepartment.PrepareQuestionForDB(columnList, sqlParams);
Q1.PrepareQuestionForDB(columnList, sqlParams);
Q2.PrepareQuestionForDB(columnList, sqlParams);
Q3.PrepareQuestionForDB(columnList, sqlParams);
Q4.PrepareQuestionForDB(columnList, sqlParams);
Q5.PrepareQuestionForDB(columnList, sqlParams);
Q6.PrepareQuestionForDB(columnList, sqlParams);
Q7.PrepareQuestionForDB(columnList, sqlParams);
Q8.PrepareQuestionForDB(columnList, sqlParams);
Q9.PrepareQuestionForDB(columnList, sqlParams);
Q10.PrepareQuestionForDB(columnList, sqlParams);
Q11.PrepareQuestionForDB(columnList, sqlParams);
Q12.PrepareQuestionForDB(columnList, sqlParams);
Q13.PrepareQuestionForDB(columnList, sqlParams);
Q14.PrepareQuestionForDB(columnList, sqlParams);
Q15.PrepareQuestionForDB(columnList, sqlParams);
Q16.PrepareQuestionForDB(columnList, sqlParams);
Q17.PrepareQuestionForDB(columnList, sqlParams);
Q18.PrepareQuestionForDB(columnList, sqlParams);
Q19.PrepareQuestionForDB(columnList, sqlParams);
Q20.PrepareQuestionForDB(columnList, sqlParams);
Q21.PrepareQuestionForDB(columnList, sqlParams);
Q22.PrepareQuestionForDB(columnList, sqlParams);
Q23.PrepareQuestionForDB(columnList, sqlParams);
Q24.PrepareQuestionForDB(columnList, sqlParams);
Q25.PrepareQuestionForDB(columnList, sqlParams);
Q26.PrepareQuestionForDB(columnList, sqlParams);
Q27.PrepareQuestionForDB(columnList, sqlParams);
Q28.PrepareQuestionForDB(columnList, sqlParams);
Q29A.PrepareQuestionForDB(columnList, sqlParams);
Q29B.PrepareQuestionForDB(columnList, sqlParams);
Q29C.PrepareQuestionForDB(columnList, sqlParams);
Q30.PrepareQuestionForDB(columnList, sqlParams);
radQ31_Hourly.PrepareQuestionForDB(columnList, sqlParams);
radQ31_Salary.PrepareQuestionForDB(columnList, sqlParams);
radQ32_1.PrepareQuestionForDB(columnList, sqlParams);
radQ32_2.PrepareQuestionForDB(columnList, sqlParams);
radQ32_3.PrepareQuestionForDB(columnList, sqlParams);
radQ32_4.PrepareQuestionForDB(columnList, sqlParams);
radQ32_5.PrepareQuestionForDB(columnList, sqlParams);
Q33.PrepareQuestionForDB(columnList, sqlParams);
chkQ34_1.PrepareQuestionForDB(columnList, sqlParams);
chkQ34_2.PrepareQuestionForDB(columnList, sqlParams);
chkQ34_3.PrepareQuestionForDB(columnList, sqlParams);
chkQ34_4.PrepareQuestionForDB(columnList, sqlParams);
chkQ34_5.PrepareQuestionForDB(columnList, sqlParams);
chkQ34_6.PrepareQuestionForDB(columnList, sqlParams);
chkQ34_7.PrepareQuestionForDB(columnList, sqlParams);
chkQ34_8.PrepareQuestionForDB(columnList, sqlParams);
chkQ34_9.PrepareQuestionForDB(columnList, sqlParams);
chkQ34_10.PrepareQuestionForDB(columnList, sqlParams);
chkQ34_11.PrepareQuestionForDB(columnList, sqlParams);
chkQ34_12.PrepareQuestionForDB(columnList, sqlParams);
if (radFFContinue.Checked)
{
CSR_Q1.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q2.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q3.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q4.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q5_1.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q5_2.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q5_3.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q5_4.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q6.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q7.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q8_1.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q8_2.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q8_3.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q8_4.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q8_5.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q8_6.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q8_7.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q8_8.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q8_9.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q8_OtherExplanation.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q9A.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q9B.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q9C.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q9D.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q9E.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q9F.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q9G.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q9H.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q10A.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q10B.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q10C.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q10D.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q10E.PrepareQuestionForDB(columnList, sqlParams);
radCSR_Q11_1.PrepareQuestionForDB(columnList, sqlParams);
radCSR_Q11_2.PrepareQuestionForDB(columnList, sqlParams);
radCSR_Q11_3.PrepareQuestionForDB(columnList, sqlParams);
radCSR_Q11_4.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q12.PrepareQuestionForDB(columnList, sqlParams);
CSR_Q13.PrepareQuestionForDB(columnList, sqlParams);
}
columnList.Append(",[PropertyID],[DateEntered],[SurveyType]");
sqlParams.Add("@PropertyID", Master.PropertyID)
.Add("@DateEntered", DateTime.Now)
.Add("@SurveyType", IsKioskSurvey ? "K" : "D");
if (GAGLocation != GLocation.None)
{
columnList.Append(",[GAGLocation]");
sqlParams.Add("@GAGLocation", GAGLocation.ToString());
}
columnList.Remove(0, 1);
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
int rowID = sql.QueryAndReturnIdentity(String.Format("INSERT INTO [tblSurveySnapshot2017] ({0}) VALUES ({1});", columnList, columnList.ToString().Replace("[", "@").Replace("]", String.Empty)), sqlParams);
if (!sql.HasError && rowID != -1)
{
Dictionary <string, int> wordCounts = SurveyTools.GetWordCount(Q33.Text, CSR_Q8_OtherExplanation.Text, CSR_Q13.Text);
SurveyTools.SaveWordCounts(SharedClasses.SurveyType.Employee, rowID, wordCounts);
return(true);
}
else
{
return(false);
}
}
