コード例 #1
0
        protected void grdViewUsers_RowCommand1(object sender, GridViewCommandEventArgs e)
        {
            int ddl = ddlSearch.SelectedValue.Length;
            int txt = txtSearch.Text.Length;

            if (e.CommandName == "InsertRow")
            {
                try
                {
                    DataAccessLayer DAL         = new DataAccessLayer();
                    string          Username    = ((TextBox)grdViewUsers.FooterRow.FindControl("txtInsertUserName")).Text;
                    string          Firstname   = ((TextBox)grdViewUsers.FooterRow.FindControl("txtInsertFirstName")).Text;
                    string          Lastname    = ((TextBox)grdViewUsers.FooterRow.FindControl("txtInsertLastName")).Text;
                    string          EmailID     = ((TextBox)grdViewUsers.FooterRow.FindControl("txtInsertEmailID")).Text;
                    string          Passport    = ((TextBox)grdViewUsers.FooterRow.FindControl("txtInsertPassport")).Text;
                    string          Gender      = ((DropDownList)grdViewUsers.FooterRow.FindControl("ddlInsertGender")).SelectedValue;
                    string          Mobile      = ((TextBox)grdViewUsers.FooterRow.FindControl("txtInsertMobile")).Text;
                    string          pwd         = ((TextBox)grdViewUsers.FooterRow.FindControl("txtInsertPassword")).Text;
                    string          Password    = Security.GetHash256(pwd, Username);
                    string          UserProfile = ((DropDownList)grdViewUsers.FooterRow.FindControl("ddlInsertUserProfile")).SelectedValue;
                    string          Status      = ((DropDownList)grdViewUsers.FooterRow.FindControl("ddlInsertStatus")).SelectedValue;
                    if (DAL.UsernameExists(Username))
                    {
                        lblUserErrorMessage.Visible   = true;
                        lblUserErrorMessage.Text      = "Username Already Exists!";
                        lblUserErrorMessage.ForeColor = System.Drawing.Color.Red;
                    }
                    else if (DAL.EmailIDExists(EmailID))
                    {
                        lblUserErrorMessage.Visible   = true;
                        lblUserErrorMessage.Text      = "Email-ID Already Exists!";
                        lblUserErrorMessage.ForeColor = System.Drawing.Color.Red;
                    }
                    else if (DAL.PassportExists(Passport))
                    {
                        lblUserErrorMessage.Visible   = true;
                        lblUserErrorMessage.Text      = "User Already Registered With Passport!";
                        lblUserErrorMessage.ForeColor = System.Drawing.Color.Red;
                    }
                    else
                    {
                        lblUserErrorMessage.Visible   = true;
                        lblUserErrorMessage.Text      = "User Profile for <b>" + Username + "</b> has been created";
                        lblUserErrorMessage.ForeColor = System.Drawing.Color.Green;
                        DataAccessLayer.InsertUser(Username, Firstname, Lastname, EmailID, Passport, Gender, Mobile, Password, UserProfile, Status);
                        GridBind();
                    }
                }
                catch (Exception ex)
                {
                    lblUserErrorMessage.Visible   = true;
                    lblUserErrorMessage.Text      = "Exception Occur: " + ex.Message;
                    lblUserErrorMessage.ForeColor = System.Drawing.Color.Red;
                }
            }
            else if (e.CommandName == "EditRow")
            {
                try
                {
                    lblUserException.Visible    = false;
                    lblUserErrorMessage.Visible = false;
                    if (ddl != 0 && txt != 0)
                    {
                        int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
                        grdViewUsers.EditIndex = rowIndex;
                        GridSearch();
                    }
                    else
                    {
                        int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
                        grdViewUsers.EditIndex = rowIndex;
                        GridBind();
                    }
                }
                catch (Exception ex)
                {
                    lblUserErrorMessage.Visible   = true;
                    lblUserErrorMessage.Text      = "Exception Occur: " + ex.Message;
                    lblUserErrorMessage.ForeColor = System.Drawing.Color.Red;
                }
            }
            else if (e.CommandName == "DeleteRow")
            {
                try
                {
                    lblUserException.Visible = false;
                    lblUserException.Visible = false;
                    if (ddl != 0 && txt != 0)
                    {
                        DataAccessLayer.DeleteUser(Convert.ToInt32(e.CommandArgument));
                        GridSearch();
                    }
                    else
                    {
                        DataAccessLayer.DeleteUser(Convert.ToInt32(e.CommandArgument));
                        GridBind();
                    }
                }
                catch (Exception ex)
                {
                    lblUserException.Visible   = true;
                    lblUserException.Text      = "Exception Occur: " + ex.Message;
                    lblUserException.ForeColor = System.Drawing.Color.Red;
                }
            }
            else if (e.CommandName == "CancelUpdate")
            {
                try
                {
                    lblUserException.Visible    = false;
                    lblUserErrorMessage.Visible = false;
                    if (ddl != 0 && txt != 0)
                    {
                        grdViewUsers.EditIndex = -1;
                        GridSearch();
                        lblSearchError.Visible = false;
                    }
                    else
                    {
                        grdViewUsers.EditIndex = -1;
                        GridBind();
                        lblSearchError.Visible = false;
                    }
                }
                catch (Exception ex)
                {
                    lblUserException.Visible   = true;
                    lblUserException.Text      = "Exception Occur: " + ex.Message;
                    lblUserException.ForeColor = System.Drawing.Color.Red;
                }
            }
            else if (e.CommandName == "UpdateRow")
            {
                try
                {
                    lblUserErrorMessage.Visible = false;
                    int    rowIndex    = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
                    int    UserID      = Convert.ToInt32(e.CommandArgument);
                    string Username    = ((TextBox)grdViewUsers.Rows[rowIndex].FindControl("txtEditUserName")).Text;
                    string Firstname   = ((TextBox)grdViewUsers.Rows[rowIndex].FindControl("txtEditFirstName")).Text;
                    string Lastname    = ((TextBox)grdViewUsers.Rows[rowIndex].FindControl("txteditLastName")).Text;
                    string EmailID     = ((TextBox)grdViewUsers.Rows[rowIndex].FindControl("txtEditEmailID")).Text;
                    string Passport    = ((TextBox)grdViewUsers.Rows[rowIndex].FindControl("txtEditPassport")).Text;
                    string Gender      = ((DropDownList)grdViewUsers.Rows[rowIndex].FindControl("ddlEditGender")).SelectedValue;
                    string Mobile      = ((TextBox)grdViewUsers.Rows[rowIndex].FindControl("txtEditMobile")).Text;
                    string pwd         = ((TextBox)grdViewUsers.Rows[rowIndex].FindControl("txtEditPassword")).Text;
                    string Password    = Security.GetHash256(pwd, Username);
                    string UserProfile = ((DropDownList)grdViewUsers.Rows[rowIndex].FindControl("ddlEditUserProfile")).SelectedValue;
                    string Status      = ((DropDownList)grdViewUsers.Rows[rowIndex].FindControl("ddlEditStatus")).SelectedValue;
                    DataAccessLayer.UpdateUser(UserID, Username, Firstname, Lastname, EmailID, Passport, Gender, Mobile, Password, UserProfile, Status);
                    lblUserErrorMessage.Visible   = true;
                    lblUserErrorMessage.Text      = "User Profile for <b>" + Username + "</b> has been udpated";
                    lblUserErrorMessage.ForeColor = System.Drawing.Color.Green;

                    if (ddl != 0 && txt != 0)
                    {
                        grdViewUsers.EditIndex = -1;
                        GridSearch();
                        lblSearchError.Visible = false;
                    }
                    else
                    {
                        grdViewUsers.EditIndex = -1;
                        GridBind();
                        lblSearchError.Visible = false;
                    }
                }
                catch (Exception ex)
                {
                    lblUserErrorMessage.Visible   = true;
                    lblUserErrorMessage.Text      = "Exception Occur: " + ex.Message;
                    lblUserErrorMessage.ForeColor = System.Drawing.Color.Red;
                }
            }
        }