protected void Page_Load(object sender, System.EventArgs e) { permss = check_permissions(this.Page, true); if (permss.UserType == UserType.CountryUserWithoutDataAccess) { Response.Redirect("index.aspx", true); } exp = false; schdld.Visible = exp; //schNow.Visible = (!exp); content = Request.QueryString["content"]; //if (!IsPostBack && content.Equals("new")) //{ // Response.Redirect("index.aspx"); //} switch (content) { case "new": Page_Load_new(); break; case "edit": Page_Load_edit(); break; } }
protected void Page_Load(object sender, System.EventArgs e) { page_utilities.Set_titles(this, "Master Reports Now"); permss = check_permissions(this.Page, true); if (permss.UserType == UserType.CountryUserWithoutDataAccess) { Response.Redirect("index.aspx", true); } index_MasterReport MasterrptNow = null; if (!IsPostBack) { if (Context.Handler.GetType().Name.Equals("datamgmt_index_masterreport_aspx")) { if ((index_MasterReport)Context.Handler != null) { MasterrptNow = (index_MasterReport)Context.Handler; tbreportname.Text = MasterrptNow.Masterrptname; MaterRptId.Value = Convert.ToString(MasterrptNow.MstrId); } } } }
public void TestSelectUsersByRoleTypeAndCountryPermissions() { string email = "*****@*****.**" + GetNewStamp(); string login = "******" + GetNewStamp(); string password = "******"; bool isAdmin = false; UserType type = UserType.CountryUserWithDataAccess; UserCompanyType companytype = UserCompanyType.HPI; int Company_Code = 0; List<CountryDto> listOfPermittedCountriesQuestionnaire = CommonFacade.GetListOfCountries("'de','pl'"); UserDto user = new UserDto(email, isAdmin, password, login, type, listOfPermittedCountriesQuestionnaire, null, Company_Code, companytype); Assert.IsTrue(UserFacade.CreateOrUpdate(user, "insert", null, null)); foreach (CountryDto country in listOfPermittedCountriesQuestionnaire) { Assert.IsTrue(UserFacade.CreateOrUpdate(user, "country", "q", country.Country)); } UserDto sel = AdminRegistry.UserDao.GetByLogin(login); Assert.IsNotNull(sel); Assert.AreEqual(user, sel); Assert.AreEqual(email, sel.EmailAddress); Assert.AreEqual(login, sel.Login); Assert.AreEqual(password, sel.Password); Assert.AreEqual(isAdmin, sel.IsAdmin); Assert.AreEqual(type, sel.UserType); List<UserDto> listOfUsers = AdminRegistry.UserDao.SelectUsersByRoleTypeAndCountryPermissions(Migration.ConvertUserTypeToString(type), "q", "de",2); Assert.IsTrue(listOfUsers.Find(u => u.Equals(sel)) != null); Assert.IsTrue(AdminRegistry.UserDao.Delete(user)); Assert.IsNull(AdminRegistry.UserDao.GetByLogin(login)); }
protected void Page_Load(object sender, EventArgs e) { page_utilities.Set_titles(this, "Siebel Codes Report for single questionnaire/ processor"); permss = check_permissions(this.Page, true); if (!IsPostBack) { InitializeErrorPanels(); valid_qid_integer.ValidationExpression = constants.REGEX_INTEGER; } }
protected void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here page_utilities.Set_titles(this.Page, "User administration"); permss = check_permissions(this.Page, true); if (permss.UserType != UserType.Admin) { Response.Redirect("../index.aspx", true); } if (!this.IsPostBack) { #region Role bind roleList.DataSource = listOfRoles; roleList.DataBind(); roleList.SelectedIndex = 0; #endregion #region Permissions bind permissionsList.DataSource = listOfPermissions; permissionsList.DataBind(); permissionsList.Items[0].Selected = true; permissionsList.Items[1].Selected = true; #endregion #region Country bind List<CountryDto> listOfCountries = new List<CountryDto>(); listOfCountries.Add(new CountryDto() { Country = "--", CountryName = "- Show all -" }); List<CountryDto> temp = CommonFacade.GetListOfCountries(null); if (temp != null && temp.Count > 0) listOfCountries.AddRange(temp); country_FK.DataSource = listOfCountries; country_FK.DataTextField ="CountryName"; country_FK.DataValueField = "Country"; country_FK.DataBind(); country_FK.SelectedIndex = 0; #endregion #region company PopulateCompanyDDL(); #endregion } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["content"] != "new" && Request.QueryString["content"] != "edit") { Response.Redirect("index.aspx"); } permss = check_permissions(this.Page, true); page_utilities.Set_titles(this.Page, "Pre-defined question"); if (!IsPostBack) { otherPanel.Visible = false; InitializePanels(); try { if (Request.QueryString["content"] == "new") { PageLoad_New(); } else { PageLoad_Edit(); } if (Session["page_id"] != null) { page_id_from_session = int.Parse(Session["page_id"].ToString()); } else if (pageQuestion != null) { page_id_from_session = pageQuestion.PageId; } if (Session["questionnaire_id"] != null) questionnaire_id = int.Parse(Session["questionnaire_id"].ToString()); else if (Request.QueryString["qid"] != null) questionnaire_id = int.Parse(Request.QueryString["qid"]); LoadSortSequences(); LoadPredefinedQuestionData(); if (Request.QueryString["content"] == "edit") { LoadQuestion(); } } catch (Exception) { Response.Redirect("index.aspx"); } } }
public bool CreateOrUpdate(UserDto user, string flag, string type, string country) { bool retval = false; DbCommand sp = null; DbConnection connection = null; IDataReader reader = null; try { connection = _dbLayer.GetConnection(); sp = connection.CreateCommand(); sp.CommandText = "update_user"; sp.CommandType = CommandType.StoredProcedure; _dbLayer.AddParameter(sp, "@flag", ParameterDirection.Input, DbType.String, flag); _dbLayer.AddParameter(sp, "@useremail", ParameterDirection.Input, DbType.String, user.EmailAddress); _dbLayer.AddParameter(sp, "@ntlogin", ParameterDirection.Input, DbType.String, user.Login); _dbLayer.AddParameter(sp, "@adminrole", ParameterDirection.Input, DbType.Boolean, user.IsAdmin); _dbLayer.AddParameter(sp, "@password", ParameterDirection.Input, DbType.String, user.Password); _dbLayer.AddParameter(sp, "@role", ParameterDirection.Input, DbType.String, Migration.ConvertUserTypeToString(user.UserType)); _dbLayer.AddParameter(sp, "@type", ParameterDirection.Input, DbType.String, type); _dbLayer.AddParameter(sp, "@country", ParameterDirection.Input, DbType.String, country); _dbLayer.AddParameter(sp, "@company_code", ParameterDirection.Input, DbType.Int32, user.Company_Code); //RFG 2.20-- _dbLayer.AddReturnParameter(sp); sp.ExecuteNonQuery(); retval = true; } catch (DbException e) { Trace.WriteLine("UserDao.Create(" + user + "): " + e.Message); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } if (sp != null) { sp.Dispose(); } if (connection != null) { _dbLayer.ReturnConnection(connection); } else { _dbLayer.ReturnConnection(connection, true); } } return retval; }
protected void Page_Load(object sender, EventArgs e) { // Put user code to initialize the page here page_utilities.Set_titles(this, "Re-Assign User Artifacts Page"); permss = check_permissions(this.Page, true); if (permss.UserType != UserType.Admin) { Response.Redirect("../index.aspx", true); } }
protected void Page_Load(object sender, System.EventArgs e) { if (!checkforASTACompliance()) Response.Redirect("user_index.aspx", true); permss = check_permissions(this.Page, true); if (permss.UserType != UserType.Admin) { Response.Redirect("../index.aspx", true); } if (!IsPostBack) { if (!this.IsPostBack) { List<CountryDto> countries = CommonFacade.GetListOfCountries(null); existing_cc.DataSource = countries; existing_cc.DataTextField = "CountryName"; existing_cc.DataValueField = "Country"; existing_cc.DataBind(); existing_cc_proc.DataSource = countries; existing_cc_proc.DataTextField = "CountryName"; existing_cc_proc.DataValueField = "Country"; existing_cc_proc.DataBind(); } PopulateCompanyDDL(); // RFG 2.20 to Populate the Company Dropdown; } if(Request.QueryString["content"] != null) { if (!IsPostBack) { roleList.DataSource = listOfRoles; roleList.DataBind(); roleList.SelectedIndex = 0; } switch(Request.QueryString["content"].ToString()) { case "new": Page_Load_new(); break; case "edit": Page_Load_edit(); break; default: break; } } else { Response.Redirect("user_index.aspx", true); } }
protected void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here page_utilities.Set_titles(this, "Find questionnaire"); permss = check_permissions(this.Page, true); tr_result.Visible = tr_error.Visible = validator_table.Visible = false; if(!this.IsPostBack) { valid_qid_integer.ValidationExpression = constants.REGEX_INTEGER; } }
protected void Page_Load(object sender, System.EventArgs e) { permss = check_permissions(this.Page, true); // Put user code to initialize the page here /* string content_builder and session-variable pcc (=page_content_code) for switching between different contents (see Page_Load_<pcc>) to be displayed */ string content_builder; if (Request.QueryString.GetValues("pcc") != null) { content_builder = Request.QueryString.Get("pcc").ToString(); } else { content_builder = "start"; } //initialize page and make all elements invisible themeheaderTable.Visible=false; firstDataTable.Visible=false; secondDataTable.Visible=false; thirdDataTable.Visible=false; fourthDataTable.Visible=false; fifthDataTable.Visible=false; firstButtonTable.Visible=false; secondButtonTable.Visible=false; thirdButtonTable.Visible=false; fourthButtonTable.Visible=false; tblCreateNewTop.Visible = false; //††† 20120301 Biju Pattathil | RFG2.6 New Top Button (Admin Only) Start††† //calling different Page_Load's according to content_builder (see above) switch (content_builder) { case "create_new_campaign": Page_Load_create_new_campaign(); break; case "delete_campaign": Page_Load_delete_campaign(); break; case "delete_campaign_confirm": Page_Load_delete_campaign_confirm(); break; case "delete_confirmation": Page_Load_delete_confirmation(); break; default: Page_Load_start(); break; } }
/// <summary> /// Page_load method is called when first time page is calling /// </summary> /// <param name="sender">This will give sender informaion</param> /// <param name="e">This will give enent argument details</param> protected void Page_Load(object sender, EventArgs e) { page_utilities.Set_titles(this, "HPP Field Management"); permss = check_permissions(this.Page, true); if (permss.UserType != UserType.Admin) { Response.Redirect(utility.getParameter("UrlToApplication") + "index.aspx", true); } if (!this.IsPostBack) { this.LoadHppFields(); } }
protected void Page_Load(object sender, EventArgs e) { page_utilities.Set_titles(this, "Manage pre-defined questions"); permss = check_permissions(this.Page, true); if (permss.UserType != UserType.Admin) { Response.Redirect(utility.getParameter("UrlToApplication") + "index.aspx", true); } if (!IsPostBack) { LoadQuestions(); } }
protected void Page_Load(object sender, EventArgs e) { page_utilities.Set_titles(this, "Edit Navigation Tabs"); permss = check_permissions(this.Page, true); if (Session["page_id"] == null || Session["questionnaire_id"] == null) { Response.Redirect("edit_page_overview.aspx?content=edit", true); } else { pageIdFromSession = Session["page_id"].ToString(); questionnaireIdFromSession = Session["questionnaire_id"].ToString(); } try { PageAssemblyDto retval = QuestionnaireFacade.GetPageByPageId(Int64.Parse(questionnaireIdFromSession), int.Parse(pageIdFromSession), ViewType.Undefined, false); if (retval == null) { Response.Redirect("edit_page_overview.aspx?content=edit", true); } formType = Migration.ConvertPageTypeToDisplayedString(retval.Page.PageType); page = retval.Page; } catch (UserCausedException) { } if (!IsPostBack) { int initialFormOrder = 1; listOfNavigationElements = new List<NavigationElementDto>(); if (page.PageType != PageType.FormPage) { initialFormOrder = PagePrefill(); addElementPanel.Visible = false; delete_element.Enabled = false; delete_element.Style.Add("readonly", "true"); delete_element.ToolTip = "In order to remove tab navigation, you need to delete that from formpage"; } LoadListOfNavigationElements(page.PageType, initialFormOrder); InitializePanels(); } }
protected void Page_Load(object sender, EventArgs e) { page_utilities.Set_titles(this, "Delete Campaign"); permss = check_permissions(this.Page, true); try { campaign_code = Session["campaign_code"].ToString(); } catch { Response.Redirect("index.aspx", true); } campaign_definition.Text = String.Format("The campaign <b>{0}</b> " + " is now empty and stores no additional [questionnaire | processor] any more. Do you also want to delete campaign <b>{0}</b> now?", campaign_code); }
protected void Page_Load(object sender, EventArgs e) { permss = check_permissions(this.Page, true); if (permss.UserType != UserType.Admin) { Response.Redirect(utility.getParameter("UrlToApplication") + "index.aspx", true); } page_utilities.Set_titles(this.Page, "Localize Pre-Defined Question"); if (!IsPostBack) { ResetAllFields(); InitializeErrorsPanels(); LoadPredefinedQuestions(); LoadLocalizations(); } Session["question_id"] = null; }
protected void Page_Load(object sender, System.EventArgs e) { permss = check_permissions(this.Page, true); if (permss.UserType == UserType.CountryUserWithoutDataAccess) { Response.Redirect("index.aspx", true); } content = Request.QueryString["content"]; switch (content) { case "new": Page_Load_new(); break; case "edit": Page_Load_edit(); break; } }
protected void Page_Load(object sender, EventArgs e) { page_utilities.Set_titles(this, "Edit Additional Navigation"); permss = check_permissions(this.Page, true); if (Session["page_id"] == null || Session["questionnaire_id"] == null) { Response.Redirect("edit_page_overview.aspx?content=edit", true); } else { pageIdFromSession = Session["page_id"].ToString(); questionnaireIdFromSession = Session["questionnaire_id"].ToString(); } try { PageAssemblyDto retval = QuestionnaireFacade.GetPageByPageId(Int64.Parse(questionnaireIdFromSession), int.Parse(pageIdFromSession), ViewType.Undefined, false); if (retval == null) { Response.Redirect("edit_page_overview.aspx?content=edit", true); } formType = Migration.ConvertPageTypeToDisplayedString(retval.Page.PageType); page = retval.Page; } catch (UserCausedException) { } if (!IsPostBack) { useFormpage = false; List<string> list = new List<string>(){ "Select element type", "Non - clickable headline", /*"Clickable headline",*/ "Link"/*, "Divider"*/ }; elementTypeList.DataSource = list; elementTypeList.DataBind(); ResetAddElement(); listOfNavigationElements = new List<NavigationElementDto>(); LoadListOfNavigationElements(); InitializePanels(); AdjustDeleteButtonVisibility(); } }
protected void Page_Load(object sender, EventArgs e) { // Put user code to initialize the page here page_utilities.Set_titles(this, "Re-Assign User Artifacts Page"); permss = check_permissions(this.Page, true); if (permss.UserType != UserType.Admin) { Response.Redirect("../index.aspx", true); } if (!IsPostBack) { txtSourceUser.Text = Session["reassign_email"].ToString(); //††† 20120302 Biju Pattathil | RFG2.7 6021-Re-assign artifacts - page behaviour is not correct:Start††† optQuestionnaires.Checked = true; optartifact_Click(optQuestionnaires, e); //††† 20120302 Biju Pattathil | RFG2.7 6021-Re-assign artifacts - page behaviour is not correct:End††† } }
protected void Page_Load(object sender, EventArgs e) { page_utilities.Set_titles(this.Page, "Export reports / statistics files"); permss = check_permissions(this.Page, true); if (permss.UserType != UserType.Admin || Session["from"] == null || Session["until"] == null || Session["ordering"] == null|| Session["row_number"] == null) { Response.Redirect("index.aspx", true); } table_emailerror.Visible = false; if (!IsPostBack) { try { InitializeStatisticsValues(); pathtotempdir = Server.MapPath(utility.getParameter("path_to_temp")); values = new statistics_values(); values.permss_account = permss.EmailAddress; values.permss_user = permss.EmailAddress; values.from = from; values.until = until; values.row_number = row_number; values.ordering = ordering; values.Company_Code = permss.Company_Code; //RFG 2.20 } catch { table_emailerror.Visible = true; } values.pathtotempdir = pathtotempdir; mailthread.generate_dataemail(values, true); } }
protected void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here page_utilities.Set_titles(this, "Delete Processor"); permss = check_permissions(this.Page, true); try { processor_id = Session["processor_id"].ToString(); } catch { Response.Redirect("index.aspx", true); } Hashtable h_params = new Hashtable(); h_params.Add("questionnaire_id", processor_id); h_params.Add("questionnaire_type", "p"); DataTable processor = DB.execProc("select_questionnaire_general", h_params); if (processor.Rows.Count != 0) { campaign_code = processor.Rows[0]["campaign_code_FK"].ToString(); campaign_definition.Text = String.Format("Campaign: <b>{0}</b> ", processor.Rows[0]["campaign_code_FK"].ToString()); campaign_definition.Text = String.Format("{0}Processor title: <b>{1}</b> ", campaign_definition.Text, processor.Rows[0]["qid_title"].ToString()); campaign_definition.Text = String.Format("{0} cc: <b>{1}</b> ", campaign_definition.Text, processor.Rows[0]["country_FK"].ToString()); campaign_definition.Text = String.Format("{0} ll: <b>{1}</b> ", campaign_definition.Text, processor.Rows[0]["language_FK"].ToString()); //mainimage_filename = questionnaire.Rows[0]["main_image"].ToString(); } else { Response.Redirect("index.aspx", true); } }
public void TestGetUserByEmailLoginPassword() { string email = "*****@*****.**" + GetNewStamp(); string login = "******" + GetNewStamp(); string password = "******"; bool isAdmin = true; UserType type = UserType.Admin; UserCompanyType companytype = UserCompanyType.HPI; int Company = 0; UserDto user = new UserDto(email, isAdmin, password, login, type,Company,companytype); Assert.IsTrue(AdminRegistry.UserDao.CreateOrUpdate(user, "insert", null, null)); UserDto sel = AdminRegistry.UserDao.GetUserByEmailLoginPassword(email, login, password); Assert.IsNotNull(sel); Assert.AreEqual(user, sel); Assert.AreEqual(email, sel.EmailAddress); Assert.AreEqual(login, sel.Login); Assert.AreEqual(password, sel.Password); Assert.AreEqual(isAdmin, sel.IsAdmin); Assert.AreEqual(type, sel.UserType); Assert.IsTrue(AdminRegistry.UserDao.Delete(user)); Assert.IsNull(AdminRegistry.UserDao.GetByLogin(login)); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["content"] == null || !((Request.QueryString["content"] == "new") || (Request.QueryString["content"] == "edit")) || (Request.QueryString["content"] == "edit" && Session["question_id"] == null)) Response.Redirect("index.aspx"); permss = check_permissions(this.Page, true); if (permss.UserType != UserType.Admin) { Response.Redirect(utility.getParameter("UrlToApplication") + "index.aspx", true); } switch (Request.QueryString["content"]) { case "new" : Page_Load_New(); break; case "edit": Page_Load_Edit(); break; } if (!IsPostBack) { //bind ordering for new adding choice foreach (String order in orderingDropDownList) ordering_add_dropdown.Items.Add(order); ordering_add_dropdown.DataBind(); InitializeErrorsPanels(); LoadHppList(); LoadListOfChoices(); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["content"] != "new" && Request.QueryString["content"] != "edit") { Response.Redirect("index.aspx"); } permss = check_permissions(this.Page, true); page_utilities.Set_titles(this.Page, "Add pre-defined question"); if (!IsPostBack) { noContentChoosePanel.Visible = false; try { questionnaire_id_from_session = int.Parse(Session["questionnaire_id"].ToString()); } catch { Response.Redirect("index.aspx", true); } LoadContent(); } }
protected void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here page_utilities.Set_titles(this, "Master Export Response Files - scheduled"); permss = check_permissions(this.Page, true); if (permss.UserType == UserType.CountryUserWithoutDataAccess) { Response.Redirect("index.aspx", true); } error_table.Visible = false; if (!this.IsPostBack) { Session.Clear(); Session["permissions"] = permss; Hashtable h_params = new Hashtable(); h_params.Add("isSchdld", 1); string allowed_countriesQ = ""; string allowed_countriesP = ""; if (permss.UserType != UserType.Admin) { if (permss.ListOfPermitedCountriesQuestionnaire != null && permss.ListOfPermitedCountriesQuestionnaire.Count > 0) { for (int i = 0; i < permss.ListOfPermitedCountriesQuestionnaire.Count; i++) { if (i != 0) { allowed_countriesQ += ","; } allowed_countriesQ += permss.ListOfPermitedCountriesQuestionnaire[i].Country; } h_params.Add("countriesQ", allowed_countriesQ); } if (permss.ListOfPermitedCountriesProcessor != null && permss.ListOfPermitedCountriesProcessor.Count > 0) { for (int i = 0; i < permss.ListOfPermitedCountriesProcessor.Count; i++) { if (i != 0) { allowed_countriesP += ", "; } allowed_countriesP += permss.ListOfPermitedCountriesProcessor[i].Country; } h_params.Add("countriesP", allowed_countriesP); } } h_params.Add("type", Migration.ConvertUserTypeToString(permss.UserType)); scheduledexports = DB.execProc("select_masterreports", h_params); scheduledexports.Columns.Add("mode", typeof(string)); scheduledexports.Columns.Add("day", typeof(string)); scheduledexports.Columns.Add("enabled", typeof(bool)); foreach (DataRow single_row in scheduledexports.Rows) { single_row["mode"] = single_row["schedule_mode"].ToString().Replace("w", "weekly").Replace("d", "daily"); string schedule_day = single_row["schedule_day"].ToString(); if (schedule_day != "") { int dw = int.Parse(schedule_day); DayOfWeek weekday = (DayOfWeek)dw; single_row["day"] = weekday.ToString().Substring(0, 2); } single_row["enabled"] = (permss.UserType == UserType.Admin | permss.EmailAddress == single_row["recipient_email"].ToString()); } scheduledexports.PrimaryKey = new DataColumn[] {scheduledexports.Columns["master_id"]}; scheduledexports_list.Visible = true; scheduledexports_list.DataSource = scheduledexports; scheduledexports_list.DataBind(); Session["scheduledMasterexports"] = scheduledexports; } }
//for master report //private bool ismasterrpt = false; //private MasterReport Master; //private string mid = string.Empty; protected void Page_Load(object sender, System.EventArgs e) { edit_scheduled_MasterReport editschedule_rpt = null; MasterReportNow MasterrptNow = null; page_utilities.Set_titles(this.Page, "Export response files"); permss = check_permissions(this.Page, true); if (permss.UserType == UserType.CountryUserWithoutDataAccess) { Response.Redirect("index.aspx", true); } bool bMasterRpt = false; if (!IsPostBack) { if (Context.Handler.GetType().Name.Equals("datamgmt_edit_scheduled_masterreport_aspx")) { if ((edit_scheduled_MasterReport)Context.Handler != null) { editschedule_rpt = (edit_scheduled_MasterReport)Context.Handler; bMasterRpt = true; } } if (Context.Handler.GetType().Name.Equals("datamgmt_masterreportnow_aspx")) { if ((MasterReportNow)Context.Handler != null) { MasterrptNow = (MasterReportNow)Context.Handler; bMasterRpt = true; } } } table_emailerror.Visible = false; if (!this.IsPostBack) { pathtotempdir = Server.MapPath(utility.getParameter("path_to_temp")); //create the values with the report settings values = new report_values(); values.permss_account = permss.EmailAddress; values.permss_user = permss.EmailAddress; //ismasterrpt = Convert.ToBoolean(Session["isMasterReport"]); //for master report if (!bMasterRpt) { Initialize_pagevariables(); values.campaign_name = campaign_name; values.questionnaire_id = questionnaire_id; values.from = from; values.until = until; values.questionnaire_title = questionnaire_title; } else { if (editschedule_rpt != null) { values.Master = editschedule_rpt.mrd; values.IsMasterReport = true; values.from = editschedule_rpt.mrd.Dto.From.Value; values.until = editschedule_rpt.mrd.Dto.To.Value; values.questionnaire_id = editschedule_rpt.QIDs; //values.heading = Master.Dto.MElementHeading.ToString(); } else { values.Master = MasterrptNow.mrd; values.IsMasterReport = true; values.from = MasterrptNow.mrd.Dto.From.Value; values.until = MasterrptNow.mrd.Dto.To.Value; values.questionnaire_id = MasterrptNow.QIDs; } } values.pathtotempdir = pathtotempdir; values.schedule_id = "-1"; values.schedule_master_id = "-1"; values.scheduled = false; mailthread.generate_dataemail(values, true); } }
public void TestSelectAllPermittedUsersForMasterreport() { QuestionnaireDto q1 = SetupQuestionnaireForMasterReport(Q1Elements); QuestionnaireDto q2 = SetupQuestionnaireForMasterReport(Q1Elements); QuestionnaireDto q3 = SetupQuestionnaireForMasterReport(Q1Elements); MasterReport mrp = new MasterReport(TestUser); //create report mrp.CreateMasterReport("master name", TestUser, Migration.Convert(ScheduleMode.Daily), 0, DateTime.Today.AddDays(-1), DateTime.Today.AddDays(1), true, q1.QuestionnaireId); FormRegistry.MasterReportDao.AddQuestionnaireToReport(mrp.Dto.MasterRptId, q1.QuestionnaireId); mrp.Save(); _createdMasterReports.Add(mrp.Dto.MasterRptId); List<MasterReportDto> list = FormRegistry.MasterReportDao.GetMasterReports(true, 0, null, null, "ad"); MasterReportDto mine = list.Find(delegate(MasterReportDto cur) { return cur.MasterRptId == mrp.Dto.MasterRptId; }); string email = "*****@*****.**" + GetNewStamp(); string login = "******" + GetNewStamp(); string password = "******"; bool isAdmin = false; UserType type = UserType.CountryUserWithDataAccess; UserCompanyType companytype = UserCompanyType.HPI; List<CountryDto> listOfPermittedCountriesQuestionnaire = CommonFacade.GetListOfCountries("'uk'"); int Company_Code = 0; UserDto user = new UserDto(email, isAdmin, password, login, type, listOfPermittedCountriesQuestionnaire, null, Company_Code, companytype); List<UserDto> listOfUsers = AdminRegistry.UserDao.SelectAllPermittedUsersPermittedForMasterreport(mine.MasterRptId); Assert.IsTrue(listOfUsers.Find(u => u.Login == login) == null); Assert.IsTrue(AdminRegistry.UserDao.CreateOrUpdate(user, "insert", null, null)); foreach (CountryDto country in listOfPermittedCountriesQuestionnaire) { UserFacade.CreateOrUpdate(user, "country", "q", country.Country); } UserDto sel = AdminRegistry.UserDao.GetByLogin(login); Assert.IsTrue(listOfUsers.Find(u => u.Equals(sel)) != null); Assert.IsTrue(AdminRegistry.UserDao.Delete(user)); }
protected void Page_Load(object sender, System.EventArgs e) { string recipient = string.Empty; //if (IsPostBack) //{ // if (dd_possible_users.SelectedIndex != 0) // recipient = dd_possible_users.SelectedItem.Text; // else // recipient = tb_recipient.Text; //} page_utilities.Set_titles(this, "Schedule Master Reports"); permss = check_permissions(this.Page, true); if (permss.UserType == UserType.CountryUserWithoutDataAccess) { Response.Redirect("index.aspx", true); } //content = Request.QueryString["content"]; if (!IsPostBack) { admin_behalf.Visible = false; schedule_mode.Items.Add(new ListItem(MasterReport.schdule_modeselect,"0")); schedule_mode.Items.Add(new ListItem(MasterReport.daily , "d")); schedule_mode.Items.Add(new ListItem(MasterReport.weekly, "w")); } index_MasterReport MasterrptNow = null; if (!IsPostBack) { if (Context.Handler.GetType().Name.Equals("datamgmt_index_masterreport_aspx")) { if ((index_MasterReport)Context.Handler != null) { MasterrptNow = (index_MasterReport)Context.Handler; tbreportname.Text = MasterrptNow.Masterrptname; MaterRptId.Value = Convert.ToString(MasterrptNow.MstrId); } } } #region Validation for Same Master report name Hashtable h_masterparams = new Hashtable(); string countriesQ = null; string countriesP = null; if (permss.UserType != UserType.Admin) { if (permss.ListOfPermitedCountriesQuestionnaire != null && permss.ListOfPermitedCountriesQuestionnaire.Count > 0) { countriesQ = String.Empty; for (int i = 0; i < permss.ListOfPermitedCountriesQuestionnaire.Count; i++) { if (i != 0) { countriesQ += ","; } countriesQ += permss.ListOfPermitedCountriesQuestionnaire[i].Country; } } if (permss.ListOfPermitedCountriesProcessor != null && permss.ListOfPermitedCountriesProcessor.Count > 0) { countriesP = String.Empty; for (int i = 0; i < permss.ListOfPermitedCountriesProcessor.Count; i++) { if (i != 0) { countriesP += ","; } countriesP += permss.ListOfPermitedCountriesProcessor[i].Country; } } } h_masterparams.Add("countriesQ", countriesQ); h_masterparams.Add("countriesP", countriesP); h_masterparams.Add("type", Migration.ConvertUserTypeToString(permss.UserType)); DataTable MasterReportNames = DB.execProc("select_masterreports", h_masterparams); DataRow[] MasterName = null; Int32 Masterrpt_id = 0; if(MasterReportNames != null) { if (MasterReportNames.Rows.Count > 0) { if (int.TryParse(MaterRptId.Value, out Masterrpt_id)) MasterName = MasterReportNames.Select("master_id = '" + Masterrpt_id + "'"); } } if (MasterName.Length > 0) { if (!IsPostBack) { if (!string.IsNullOrEmpty(MasterName[0]["schedule_mode"].ToString())) schedule_mode.Items.FindByValue(MasterName[0]["schedule_mode"].ToString()).Selected = true; tbreportname.Text = MasterName[0]["master_name"].ToString(); if (schedule_mode.SelectedItem.Value == "w") { schedule_day.Enabled = true; schedule_day.SelectedItem.Selected = false; schedule_day.Items.FindByValue(MasterName[0]["schedule_day"].ToString()).Selected = true; } if (bool.Parse(MasterName[0]["isscheduled"].ToString())) recipient = MasterName[0]["recipient_email"].ToString(); } } #endregion if (permss.UserType == UserType.Admin) { if (!IsPostBack) { admin_behalf.Visible = true; dd_possible_users.Enabled = true; #region load dd_user and select if possible Hashtable h_params = new Hashtable(); h_params.Add("masterID", Masterrpt_id); DataTable DtFinalUsers = DB.execProc("select_users_permitted_for_masterreport", h_params); if (DtFinalUsers != null) { if (DtFinalUsers.Rows.Count > 0) { dd_possible_users.DataSource = DtFinalUsers; dd_possible_users.DataTextField = "useremail"; } } DataRow addingRow; addingRow = DtFinalUsers.NewRow(); addingRow["useremail"] = "-- Please choose... --"; DtFinalUsers.Rows.InsertAt(addingRow, 0); dd_possible_users.DataBind(); ListItem found_user = dd_possible_users.Items.FindByText(recipient); if (found_user != null) { dd_possible_users.SelectedItem.Selected = false; found_user.Selected = true; //tb_recipient.Text = string.Empty; } else { tb_recipient.Text = recipient; } } #endregion } // } }
protected void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here page_utilities.Set_titles(this, "Create copy of existing processor"); permss = check_permissions(this.Page, true); validator_table.Visible = false; mssg_table.Visible = false; if(!this.IsPostBack) { Hashtable h_params = new Hashtable(); DataTable languages = DB.execProc("select_languages", h_params); string sCountries = ""; string countriesP = null; if (permss.UserType != UserType.Admin) { countriesP = String.Empty; if (permss.ListOfPermitedCountriesProcessor != null && permss.ListOfPermitedCountriesProcessor.Count > 0) { for (int i = 0; i < permss.ListOfPermitedCountriesProcessor.Count; i++) { if (i != 0) { sCountries += ", "; countriesP += ","; } sCountries += "'" + permss.ListOfPermitedCountriesProcessor[i].Country + "'"; countriesP += permss.ListOfPermitedCountriesProcessor[i].Country; } } else { sCountries = "''"; } h_params.Add("countries", sCountries); } else { List<CountryDto> listOfCountries = CommonFacade.GetListOfCountries(null); countriesP = String.Empty; for (int i = 0; i < listOfCountries.Count; i++) { if (i != 0) { countriesP += ","; } countriesP += listOfCountries[i].Country; } } DataTable countries = DB.execProc("select_countries", h_params); List<CountryLanguageDto> localizationsList = FormRegistry.PredefinedQuestionDao.GetCoutryLanguage(null, null, null); PredefinedQuestionFacade.AddRegionAndFKForCountryLanguage(localizationsList, countries, languages); List<CountryLanguageDto> permitLocalizationsList = new List<CountryLanguageDto>(); permitLocalizationsList.Add(new CountryLanguageDto() { DisplayName = "-- Please choose --", LocalizationId = -1 }); permitLocalizationsList.AddRange(PredefinedQuestionFacade.FilterByCoutryIdList(localizationsList, countries)); //filling in and display a dropdown-list of all non-empty campaigns stored in the db List<CampaignDto> campaigns_copyto = new List<CampaignDto>(); campaigns_copyto.Add(new CampaignDto() { CampaignCode = "-- Please choose... --" }); List<CampaignDto> tempCamp1 = CampaignFacade.SelectCampaignsByCodeCountriesTypeAndIndicatorIfEmpty(null, null, countriesP, 1); if (tempCamp1 != null && tempCamp1.Count > 0) campaigns_copyto.AddRange(tempCamp1); //don't show empty campaigns (campaigns without any questionnaire) List<CampaignDto> campaigns_copyfrom = new List<CampaignDto>(); campaigns_copyfrom.Add(new CampaignDto() { CampaignCode = "-- Please choose... --" }); List<CampaignDto> tempCamp2 = CampaignFacade.SelectCampaignsByCodeCountriesTypeAndIndicatorIfEmpty(null, null, countriesP, 0); if (tempCamp2 != null && tempCamp2.Count > 0) campaigns_copyfrom.AddRange(tempCamp2); campaign_code_FK.DataSource = campaigns_copyto; campaign_code_FK.DataTextField ="CampaignCode"; campaign_code_FK.DataBind(); campaign_code_FK.Items[0].Selected = true; copy_campaignlist.DataSource = campaigns_copyfrom; copy_campaignlist.DataTextField ="CampaignCode"; copy_campaignlist.DataBind(); copy_campaignlist.Items[0].Selected = true; localization_FK.DataSource = permitLocalizationsList; localization_FK.DataTextField = "DisplayName"; localization_FK.DataValueField = "LocalizationId"; localization_FK.DataBind(); localization_FK.Items[0].Selected = true; ViewState["countries"] = permitLocalizationsList; } }
protected void Page_Load(object sender, System.EventArgs e) { page_utilities.Set_titles(this, "RFG Processor Management"); permss = check_permissions(this.Page, true); //ANNA : changed permissions and every user have an access to processor mgmt /* if (permss.UserType != UserType.Admin) { Response.Redirect(utility.getParameter("UrlToApplication") + "index.aspx", true); } */ bool preselectCampaign = false; string preselectedCampaign = String.Empty; string preselectedPid = String.Empty; if (!this.IsPostBack) { if (Request.QueryString["found"] != null) { //user came from find_questionnaire.aspx, so display found campaign and markup found questionnaire if (Session["campaign"] != null) { preselectCampaign = true; preselectedCampaign = Session["campaign"].ToString(); preselectedPid = Session["processorID"].ToString(); } else { Response.Redirect("index.aspx"); } } } Session.Clear(); Session["permissions"] = permss; if (!this.IsPostBack) { List<LanguageDto> languages = new List<LanguageDto>(); languages.Add(new LanguageDto() { LanguageName = "-- Please choose --", LanguageFK = "--" }); List<LanguageDto> tempL = CommonFacade.GetListOfLanguages(); if (tempL != null && tempL.Count > 0) languages.AddRange(tempL); //filling in and display a dropdown-list of all relevant campaigns stored in the db string allowed_countries = null; string countriesP = null; if (permss.UserType != UserType.Admin) { allowed_countries = String.Empty; if (permss.ListOfPermitedCountriesProcessor != null && permss.ListOfPermitedCountriesProcessor.Count > 0) { for (int i = 0; i < permss.ListOfPermitedCountriesProcessor.Count; i++) { if (i != 0) { allowed_countries += ", "; countriesP += ","; } allowed_countries += "'" + permss.ListOfPermitedCountriesProcessor[i].Country + "'"; countriesP += permss.ListOfPermitedCountriesProcessor[i].Country; } } else { allowed_countries = "''"; countriesP = String.Empty; } } List<CountryDto> countries = new List<CountryDto>(); countries.Add(new CountryDto() { Country = "--", CountryName = "-- Please choose... --" }); List<CountryDto> tempC = CommonFacade.GetListOfCountries(allowed_countries); if (tempC != null && tempC.Count > 0) countries.AddRange(tempC); List<CampaignDto> campaigns = new List<CampaignDto>(); campaigns.Add(new CampaignDto() { CampaignCode = "-- Please choose.. --" }); List<CampaignDto> tempCamp = CampaignFacade.SelectCampaignsByCodeCountriesTypeAndIndicatorIfEmpty(null, null, countriesP, 1); if (tempCamp != null && tempCamp.Count > 0) { campaigns.AddRange(tempCamp); } campaign_code_FK.DataSource = campaigns; campaign_code_FK.DataTextField ="CampaignCode"; campaign_code_FK.DataBind(); campaign_code_FK.Items[0].Selected = true; country_FK.DataSource = countries; country_FK.DataTextField ="CountryName"; country_FK.DataValueField = "Country"; country_FK.DataBind(); country_FK.Items[0].Selected = true; language_FK.DataSource = languages; language_FK.DataTextField ="LanguageName"; language_FK.DataValueField = "LanguageFK"; language_FK.DataBind(); language_FK.Items[0].Selected = true; if (preselectCampaign) { //user came from find_processor.aspx, so display found campaign and markup found processor campaign_code_FK.SelectedValue = preselectedCampaign; display_list_Click(null, null, preselectedPid); } } }