Esempio n. 1
0
        /// <summary>
        /// Handles the Click event of the LinkButtonAddNew control.
        /// </summary>
        /// <param name="sender">The source of the event.</param>
        /// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
        protected void LinkButtonAddNew_Click(object sender, EventArgs e)
        {
            //create a new role
            BusinessObjects.Role role = new BusinessObjects.Role(TextBoxRoleName.Text);
            bool show;

            try
            {
                //save the role

                SecurityController.CreateRole(role);

                //refresh the screen
                //Response.Redirect(Request.Path, true);
                GridView1.DataBind();
                TextBoxRoleName.Text = "";
                LiteralRoleName.Text = role.Name;
                GridViewUsers.DataBind();
                show = true;
            }
            catch (Exception ex)
            {
                //handle error
                if (ExceptionPolicy.HandleException(ex, "User Interface"))
                {
                    DisplayMessage(ex);
                }
                show = false;
            }

            ShowUserGrid(show);
        }
Esempio n. 2
0
    //Funció carregar grid usuaris
    private void CarregarGridUsuaris()
    {
        usuaris = ORM.retornarUsuaris();

        GridViewUsers.DataSource = usuaris;
        GridViewUsers.DataBind();
    }
Esempio n. 3
0
 private void gridViewUsers_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
 {
     if (!GridViewUsers.IsFilterRow(e.RowHandle))
     {
         modified = true;
     }
 }
Esempio n. 4
0
 private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
 {
     if (UsersBindingSource.Current == null)
     {
         return;
     }
     GridViewUsers.CloseEditor();
     if (XtraMessageBox.Show("Are you sure you want to delete?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes)
     {
         ignoreLeaveRow = true;
         RemoveRecord();
         errorProvider1.Clear();
         if (!newRec)
         {
             context.SaveChanges();
         }
         ignoreLeaveRow = false;
         modified       = false;
         newRec         = false;
         setReadOnly(true);
         panelControlStatus.Visible = true;
         LabelStatus.Text           = "Record Deleted";
         rowStatusDelete            = new Timer();
         rowStatusDelete.Interval   = 3000;
         rowStatusDelete.Start();
         rowStatusDelete.Tick += new EventHandler(TimedEventDelete);
     }
     currentVal = TextEditUser.Text;
 }
Esempio n. 5
0
 private void ExtranetSecurityForm_KeyDown(object sender, KeyEventArgs e)
 {
     if (e.KeyCode == Keys.Enter && GridViewUsers.IsFilterRow(GridViewUsers.FocusedRowHandle))
     {
         executeQuery();
     }
 }
Esempio n. 6
0
    public void BindUserGrid()
    {
        int rowcount = ucCustomPagerItems.isCountRecord;

        string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
        int?   sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
        {
            sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
        }

        DataTable dt = objUserBLL.Get_UserList_Search(txtfilter.Text != "" ? txtfilter.Text : null
                                                      , UDFLib.ConvertIntegerToNull(ddlCompanyFilter.SelectedValue)
                                                      , UDFLib.ConvertIntegerToNull(ddlDepartmentFilter.SelectedValue)
                                                      , UDFLib.ConvertIntegerToNull(ddlManagerFilter.SelectedValue), null, UDFLib.ConvertStringToNull(ddlUserTypeFilter.SelectedValue), null, sortbycoloumn, sortdirection
                                                      , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);


        if (ucCustomPagerItems.isCountRecord == 1)
        {
            ucCustomPagerItems.CountTotalRec = rowcount.ToString();
            ucCustomPagerItems.BuildPager();
        }


        if (dt.Rows.Count > 0)
        {
            GridViewUsers.DataSource = dt;
            GridViewUsers.DataBind();
        }
        else
        {
            GridViewUsers.DataSource = dt;
            GridViewUsers.DataBind();
        }
    }
Esempio n. 7
0
        private void executeQuery()
        {
            this.Cursor = Cursors.WaitCursor;
            string colName = GridViewUsers.FocusedColumn.FieldName;
            string value   = String.Empty;

            //if (!string.IsNullOrWhiteSpace(GridViewUsers.GetFocusedDisplayText()))
            value = GridViewUsers.GetFocusedDisplayText();
            //if (!string.IsNullOrWhiteSpace(value))
            //{
            string query   = String.Format("it.UserID like '{0}%'", GridViewUsers.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "UserID"));
            var    results = context.ExtranetUser.Where(query);

            int count = results.Count();

            if (count > 0)
            {
                UsersBindingSource.DataSource = results;
                GridViewUsers.SetRowCellValue(GridControl.AutoFilterRowHandle, colName, value);
                GridViewUsers.FocusedRowHandle        = 0;
                GridViewUsers.FocusedColumn.FieldName = colName;
            }
            else
            {
                XtraMessageBox.Show("No records in database.");
                GridViewUsers.ClearColumnsFilter();
            }
            //}
            this.Cursor = Cursors.Default;
        }
Esempio n. 8
0
        private void BtnDelete_Click(object sender, EventArgs e)
        {
            userId = Convert.ToInt32(GridViewUsers.GetFocusedRowCellValue("UserId"));

            // 4	2 : สิทธิ์ใช้งานหน้าผู้ใช้งาน	 ลบข้อมูลผู้ใช้งาน
            int AuthorizeId = 4;

            if (SQLAuthorized.CheckAuthorized(ClassProperty.permisRoleId, AuthorizeId) == false)
            {
                SQLAuthorized.AlertAuthorized("สิทธิ์ใช้งานหน้าผู้ใช้งาน", "ไม่มีสิทธิ์ลบข้อมูลผู้ใช้งาน");
                return;
            }

            if (CheckData(userId) == true)
            {
                if (XtraMessageBox.Show(" คุณยืนยันที่จะลบข้อมูล ใช่หรือไม่?", "ยืนยัน", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
                {
                    if (UpdateData(false) == true)
                    {
                        XtraMessageBox.Show("ลบข้อมูลสำเร็จ", "สถานะ", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        ClearValues();
                        GetGridData("");
                    }
                }
            }
        }
Esempio n. 9
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Session.Timeout = 15;

        if (Session["UserSession"] == null)
        {
            Response.Redirect("~/AdminPanel/AdminLogin.aspx");
        }
        else if (Session["Admin"] == null)
        {
            Response.Redirect("~/AdminPanel/AdminLogin.aspx");
        }

        try
        {
            string          ConnectionString = WebConfigurationManager.ConnectionStrings["YahooCon"].ConnectionString;
            MySqlConnection viewTemplate     = new MySqlConnection(ConnectionString);//explisionremoteEntities{0}", Request.QueryString["ID"]);

            string query = String.Format("SELECT UsersID, Username, Email FROM Users");
            using (MySqlDataAdapter viewTemplateSet = new MySqlDataAdapter(query, viewTemplate))
            {
                DataSet viewDSet = new DataSet();
                viewTemplateSet.Fill(viewDSet);

                GridViewUsers.DataSource = viewDSet;
                GridViewUsers.DataBind();

                //UserName.Text = viewDSet.Tables[0].Rows[0]["Username"].ToString();
            }
        }
        catch (Exception ex)
        {
            Response.Write("<br>Error: <br>" + ex.Message);
        }
    }
Esempio n. 10
0
 private void BindGridView()
 {
     try
     {
         if (conn.State == ConnectionState.Closed)
         {
             conn.Open();
         }
         SqlCommand cmd = conn.CreateCommand();
         cmd.CommandText = "Select idUser,username,password,name,idLab,idPRofile from Users;";
         SqlDataAdapter adp = new SqlDataAdapter(cmd);
         DataSet        ds  = new DataSet();
         adp.Fill(ds);
         GridViewUsers.DataSource = ds;
         GridViewUsers.DataBind();
         lbltotalcount.Text = GridViewUsers.Rows.Count.ToString();
     }
     catch (SqlException ex)
     {
         showMessage(ex.Message);
     }
     finally
     {
         conn.Close();
     }
 }
Esempio n. 11
0
        public void FillGrid()
        {
            List = DataHelper.GetAllUsers();

            GridViewUsers.DataSource = List;
            GridViewUsers.DataBind();
        }
Esempio n. 12
0
    protected void Page_Load(object sender, EventArgs e)
    {
        HttpCookie LoginCookie      = Request.Cookies.Get("Credentials");
        string     currentUserEmail = LoginCookie["CurrentUserEmail"].ToString();

        string SessionloginEmail = string.Empty;

        SessionloginEmail = Convert.ToString(Session["UserCurrentEmail"]);

        if (SessionloginEmail != currentUserEmail)
        {
            Response.Redirect("login.aspx");
        }

        SqlConnection conn = new SqlConnection("Server=.;" + "Database= safeMeDb;" + "Integrated Security= true;");

        conn.Open();
        using (conn)
        {
            SqlCommand    cmd    = new SqlCommand("Select fullName, country from memberRegistration", conn);
            SqlDataReader reader = cmd.ExecuteReader();
            GridViewUsers.DataSource = reader;
            GridViewUsers.DataBind();

            //SqlDataReader reader = cmd.ExecuteReader();
            //reader.Read();
            //TextBoxFullName.Text = reader[1].ToString();
            //TextBoxCountry1.Text = reader[2].ToString();
            //TextBoxPhone.Text = reader[3].ToString();
            //TextBoxEmail.Text = reader[4].ToString();
            //TextBoxPassword.Text = reader[5].ToString();
        }
        //Response.Redirect("home.aspx");
    }
Esempio n. 13
0
    private void RefreshData()
    {
        var data = imsdb.UserAccounts.OrderByDescending(d => d.Id).ToList();

        GridViewUsers.DataSource = data;
        GridViewUsers.DataBind();
    }
Esempio n. 14
0
    //Paginació de la grid
    protected void GridViewUsers_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        int tst = e.NewPageIndex;

        GridViewUsers.PageIndex  = e.NewPageIndex;
        GridViewUsers.DataSource = usuaris;
        GridViewUsers.DataBind();
    }
Esempio n. 15
0
 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     if (e.CommandName == "Show Users")
     {
         LiteralRoleName.Text = GridView1.DataKeys[Convert.ToInt32(e.CommandArgument)].Value.ToString();
         GridViewUsers.DataBind();
     }
 }
Esempio n. 16
0
 private void setValues()
 {
     GridViewUsers.SetFocusedRowCellValue("UserID", string.Empty);
     GridViewUsers.SetFocusedRowCellValue("Password", string.Empty);
     GridViewUsers.SetFocusedRowCellValue("ReadOnly", false);
     GridViewUsers.SetFocusedRowCellValue("Inactive", false);
     GridViewUsers.SetFocusedRowCellValue("IsAgent", false);
 }
Esempio n. 17
0
        protected void UpdatePanel1_Load(object sender, EventArgs e)
        {
            //Populate Users grid
            User      user      = new User();
            DataTable dataTable = user.ToDataTable(user.GetAllUsers());

            GridViewUsers.DataSource = dataTable;
            GridViewUsers.DataBind();
        }
Esempio n. 18
0
 protected void Cerrar_Click(object sender, EventArgs e)
 {
     GridViewUsers.Visible   = true;
     UserDetailsView.Visible = false;
     Cerrar.Visible          = false;
     Servicios.Visible       = false;
     GridServicios.Visible   = false;
     GridViewUsers.DataBind();
 }
Esempio n. 19
0
        private void LoadUser()
        {
            List <CTUserInfo> userList = new List <CTUserInfo>();

            PetCare.BLL.User user = new User();
            userList = user.GetAllUserList();
            GridViewUsers.DataSource   = userList;
            GridViewUsers.DataKeyNames = new string[] { "UserID" };
            GridViewUsers.DataBind();
        }
Esempio n. 20
0
    protected void Page_Load(object sender, EventArgs e)
    {
        strSQLSelectUser = "******";

        command        = new SqlCommand(strSQLSelectUser, connection, transaction);
        sqlDataAdapter = new SqlDataAdapter(command);
        sqlDataAdapter.Fill(dataSet);
        GridViewUsers.DataSource = dataSet;
        GridViewUsers.DataBind();
    }
Esempio n. 21
0
        protected void BtnSearch_Click(object sender, EventArgs e)
        {
            string            userID   = TextBox1.Text.Trim().ToString();
            List <CTUserInfo> userList = new List <CTUserInfo>();

            PetCare.BLL.User user = new User();
            userList = user.GetUserInfoByUserID(userID);
            GridViewUsers.DataSource = userList;
            GridViewUsers.DataBind();
        }
Esempio n. 22
0
        protected void BtnUserSearch_Click(object sender, EventArgs e)
        {
            TestorCoreUser[] users = UserSearchHelper.FindUsers(userName.Text, TestorUserRole.NotDefined, TestorUserStatus.Any, 0, false);

            GridViewUsers.EmptyDataText = String.Format("Поиск: <b>{0}*</b>. Пользователи не найдены.", userName.Text);
            GridViewUsers.DataKeyNames  = new string[] { "UserId" };
            GridViewUsers.DataSource    = users;
            GridViewUsers.DataBind();

            GridViewUsers_SelectedIndexChanged(sender, e);
        }
Esempio n. 23
0
        //method to load data into a gridview !!****being used for testing purposes****!!
        void loadData()
        {
            string CS = ConfigurationManager.ConnectionStrings["myDB"].ConnectionString;

            using (SqlConnection conn = new SqlConnection(CS))
            {
                SqlCommand cmd = new SqlCommand("SELECT * FROM [dbo].[Register]", conn);
                conn.Open();
                GridViewUsers.DataSource = cmd.ExecuteReader();
                GridViewUsers.DataBind();
            }
        }
Esempio n. 24
0
    void GV_Bind()
    {
        DataView dv;

        dv = (DataView)SqlDataSourceUsers.Select(DataSourceSelectArguments.Empty);
        if (dv.Count > 0)
        {
            dv.RowFilter             = "UserTypeCode='" + RadioButtonList1.SelectedValue + "'";
            GridViewUsers.DataSource = dv;
            GridViewUsers.DataBind();
        }
    }
Esempio n. 25
0
        protected void BtnUserSearch_Click(object sender, EventArgs e)
        {
            TestorCoreUser[] users = UserSearchHelper.FindAllLocalStudents(userName.Text);

            GridViewUsers.EmptyDataText = String.Format("Поиск: <b>{0}*</b>. Пользователи не найдены.", userName.Text);
            GridViewUsers.DataKeyNames  = new string[] { "UserId" };
            GridViewUsers.DataSource    = users;
            GridViewUsers.DataBind();
            if (users.Count() == 1)
            {
                GridViewUsers.SelectedIndex = 0;
                GridViewUsers_SelectedIndexChanged(sender, e);
            }
        }
        protected void BtnConsultar_Click(object sender, EventArgs e)
        {
            DateTime Fecha1 = Convert.ToDateTime(TxtFechaInicio.Text);
            DateTime Fecha2 = Convert.ToDateTime(TxtFechaFinal.Text);

            GridViewUsers.DataSource = logusers.ListUserDate(Fecha1, Fecha2);
            GridViewUsers.DataBind();

            User userAux = (User)Session["CurrentUser"];

            ReferenceWSUser.IwcfUsersClient aux = new ReferenceWSUser.IwcfUsersClient();
            aux.InsertUserLog(userAux.UserID, 2, "El usuario a consultado la lista usuarios por fecha", DateTime.Now);
            aux.Close();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            User user = new User();

            user = (User)Session["CurrentUser"];
            if (user.RoleID != 1)
            {
                Response.Redirect("404.aspx");
            }
            if (!Page.IsPostBack)
            {
                GridViewUsers.DataSource = logusers.ListUser();
                GridViewUsers.DataBind();
            }
        }
Esempio n. 28
0
        private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
        {
            if (modified || newRec)
            {
                DialogResult select = DevExpress.XtraEditors.XtraMessageBox.Show("Do you want to confirm these changes?", Text, MessageBoxButtons.YesNoCancel);
                if (select == DialogResult.Cancel)
                {
                    return;
                }
                if (select == DialogResult.Yes)
                {
                    if (!SaveRecord())
                    {
                        return;
                    }
                }
                if (select == DialogResult.No)
                {
                    if (newRec)
                    {
                        RemoveRecord();
                    }
                    else
                    {
                        RefreshRecord();
                    }
                }
            }

            GridViewUsers.ClearColumnsFilter();
            if (UsersBindingSource.Current == null)
            {
                //fake query in order to create a link between the database table and the binding source
                UsersBindingSource.DataSource = from opt in context.ExtranetUser where opt.UserID == "KJM9" select opt;
            }
            CheckEditAgent.Focus();
            GridViewUsers.CloseEditor();
            newRec         = true;
            ignoreLeaveRow = true;       //so that when the grid row changes it doesn't try to save again
            UsersBindingSource.AddNew();
            if (GridViewUsers.FocusedRowHandle == GridControl.AutoFilterRowHandle)
            {
                GridViewUsers.FocusedRowHandle = GridViewUsers.RowCount - 1;
            }
            CheckEditAgent.Focus();
            setReadOnly(false);
            ignoreLeaveRow = false;
        }
Esempio n. 29
0
        private void BindData()
        {
            SqlConnection con = new SqlConnection(strConnString);
            SqlCommand    cmd = new SqlCommand("sp_get_cart_details_by_user_id", con);

            string userID = HttpContext.Current.User.Identity.Name;

            cmd.Parameters.Add("@user_id", SqlDbType.VarChar).Value = userID;

            cmd.CommandType = CommandType.StoredProcedure;

            cart = GetData(cmd);
            GridViewUsers.DataSource = cart;
            GridViewUsers.DataBind();
            calculateTotal();
        }
Esempio n. 30
0
        public void GetAllUsers()
        {
            string getAllUsersList = "Select * FROM Employee ORDER BY EMP_ID DESC ";

            dt = new DataTable();
            dt = dbClass.ConnectDataBaseReturnDT(getAllUsersList);
            if (dt.Rows.Count > 0)
            {
                GridViewUsers.DataSource = dt;
                GridViewUsers.DataBind();
            }
            else
            {
                GridViewUsers.DataSource = null;
                GridViewUsers.DataBind();
            }
        }