예제 #1
0
        protected void btnSubmitUsr_Click(object sender, EventArgs e)
        {
            try
            {
                string Usrname = txtUNm.Text;
                string password = txtPass.Text;
                string MailID = txtUMailID.Text;
                string type = drpDwnlstType.SelectedItem.Text;
                int isdel = 0;
                if (ChkbxIsDelUsr.Checked == true)
                    isdel = 1;
                else isdel = 0;
                BLAddSearchUser bladdusr = new BLAddSearchUser();

                if (HttpContext.Current.Session["UserId"] != null)
                {
                    int Userid = int.Parse(Session["UserId"].ToString());
                    drpDwnlstType.Enabled = false;
                    string result = bladdusr.UpdateUser(Userid, Usrname, password, MailID, isdel);
                    if (result == "1")
                        lblMsg.Text = "Record Updated Sucessfully";
                    else
                        lblMsg.Text = "Username already exists";
                    Session["UserId"] = null;
                    txtUNm.Enabled = true;
                    drpDwnlstType.Enabled = true;
                    FillUser();
                }
                else
                {
                    string result = bladdusr.addSearchUser(Usrname, password, type, MailID, isdel);
                    if (result == "1")
                        lblMsg.Text = "Record Added Sucessfully";
                    else
                        lblMsg.Text = "Username already exists";
                    FillUser();
                    Session["UserId"] = null;
                }

                txtUNm.Text = "";
                txtPass.Text = "";
                txtUMailID.Text = "";
            }
            catch (Exception ex)
            {
                lblCatchError.Text = ex.Message.ToString();
            }
        }
예제 #2
0
파일: Default.aspx.cs 프로젝트: ttss2272/jm
        protected void Page_Load(object sender, EventArgs e)
        {
            BLLogin blLogin = new BLLogin();
            BLAddSearchUser blObjAddAdmin = new BLAddSearchUser();

            int dateCount = DateCount();
            DataSet ds_chekTrail = null;
            if (dateCount != 0)
            {
                ds_chekTrail = CheckTrail();
            }
            else
            {
                ds_chekTrail = CheckTrail();
            }

            if (ds_chekTrail.Tables[0].Rows[0]["Status"].ToString() == "Valid")
            {
                DataSet ds = blObjAddAdmin.getAdminCount();

                if (ds.Tables[0].Rows[0]["Count"].ToString() == "0")
                {
                    Response.Redirect("~/AdminRegistration.aspx");
                }
                else
                {
                    Response.Redirect("~/Login.aspx");
                }
                Session["LoginId"] = null;
            }
            else
            {
                lblExpire.Text = ds_chekTrail.Tables[0].Rows[0]["Status"].ToString();
            }

            //if (drGetCnt.HasRows)
            //{
            //    drGetCnt.Read();
            //    int cnt = int.Parse(drGetCnt["Count"].ToString());
            //    drGetCnt.Close();
            //    if (cnt == 0)
            //    {
            //        Response.Redirect("~/AdminRegistration.aspx");
            //    }
            //}
        }
예제 #3
0
        protected void chkbxSrchIsDel_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                DataTable dt = new DataTable();
                int isdel = 0;
                if (chkbxSrchIsDel.Checked == true)
                    isdel = 1;
                else
                    isdel = 0;
                string unm = txtUNmSrch.Text;
                string type = drpdwnlstTypSrch.SelectedItem.Text;
                BLAddSearchUser blAddUser = new BLAddSearchUser();

                if (txtUNmSrch.Text != "" && chkbxSrchIsDel.Checked == true)
                {
                    SqlDataReader dr = blAddUser.userisdeleted(unm, isdel);
                    if (dr.HasRows)
                    {
                        grdvwSerchUser.DataSource = dr;
                    }
                    grdvwSerchUser.DataBind();

                }
                if (txtUNmSrch.Text == "" && (chkbxSrchIsDel.Checked == true || chkbxSrchIsDel.Checked == false) && drpdwnlstTypSrch.SelectedItem.Text == "--Select--")
                {
                    SqlDataReader dr = blAddUser.userisdeleted(unm, isdel);
                    if (dr.HasRows)
                    {
                        grdvwSerchUser.DataSource = dr;
                    }
                    grdvwSerchUser.DataBind();

                }

                if (txtUNmSrch.Text != "" && (drpdwnlstTypSrch.SelectedItem.Text == "Both" || drpdwnlstTypSrch.SelectedItem.Text == "admin" || drpdwnlstTypSrch.SelectedItem.Text == "employee"))
                {
                    SqlDataReader dr = blAddUser.FillUsrNmTypeIsDel1(unm, type, isdel);
                    if (dr.HasRows)
                    {
                        grdvwSerchUser.DataSource = dr;
                        grdvwSerchUser.DataBind();
                    }
                }
                if ((drpdwnlstTypSrch.SelectedItem.Text == "Both" || drpdwnlstTypSrch.SelectedItem.Text == "admin" || drpdwnlstTypSrch.SelectedItem.Text == "employee") && (chkbxSrchIsDel.Checked == true || chkbxSrchIsDel.Checked == false))
                {
                    SqlDataReader dr = blAddUser.FillTypeIsDel1(type, isdel);
                    if (dr.HasRows)
                    {
                        grdvwSerchUser.DataSource = dr;
                    }
                    grdvwSerchUser.DataBind();

                }
            }
            catch (Exception ex)
            {
                lblCatchError.Text = ex.Message.ToString();
            }
        }
예제 #4
0
        protected void grdvwSerchUser_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            try
            {
                BLAddSearchUser blEditUsr = new BLAddSearchUser();
                if (e.CommandName == "UpdateThis")
                {
                    GridViewRow row = (GridViewRow)((Control)e.CommandSource).NamingContainer;
                    int rowindex = row.RowIndex;
                    int UserId = int.Parse(grdvwSerchUser.Rows[rowindex].Cells[1].Text);
                    Session["UserId"] = UserId;
                    SqlDataReader dr = blEditUsr.GetUserById(UserId);
                    if (dr.HasRows)
                    {
                        dr.Read();
                        txtUNm.Text = dr.GetString(1);
                        txtUNm.Enabled = false;
                        txtPass.TextMode = TextBoxMode.SingleLine;
                        txtPass.Text = dr.GetString(2);
                        string type = dr.GetString(3);
                        if (dr["MailID"] != DBNull.Value)
                        {
                            txtUMailID.Text = dr.GetString(5);
                        }
                        else
                        {
                            txtUMailID.Text = "";
                        }

                        drpDwnlstType.Enabled = false;
                        drpDwnlstType.SelectedValue = type;
                        bool isdel = dr.GetBoolean(4);
                        if (isdel == true)
                            ChkbxIsDelUsr.Checked = true;
                        else
                            ChkbxIsDelUsr.Checked = false;
                        dr.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                lblCatchError.Text = ex.Message.ToString();
            }
        }
예제 #5
0
 protected void drpdwnlstTypSrch_SelectedIndexChanged(object sender, EventArgs e)
 {
     try
     {
         string unm = txtUNmSrch.Text;
         string type = drpdwnlstTypSrch.SelectedItem.Text;
         BLAddSearchUser blAddUser = new BLAddSearchUser();
         SqlDataReader dr = blAddUser.FillUsrNmType1(unm, type);
         DataTable dt = new DataTable();
         if (dr.HasRows)
         {
             dt.Load(dr);
         }
         grdvwSerchUser.DataSource = dt;
         grdvwSerchUser.DataBind();
     }
     catch (Exception ex)
     {
         lblCatchError.Text = ex.Message.ToString();
     }
 }