Example #1
0
    private void UserUpdate(string Id)
    {
        string data = "";

        if (rdoCityLocation.SelectedItem.Value == "SC")
        {
            ubal.CityName = Convert.ToString(ViewState["city1"]);
        }
        else if (rdoCityLocation.SelectedItem.Value == "DC")
        {
            if (cmbCity.SelectedValue != null)
            {
                ubal.CityName = Convert.ToString(cmbCity.SelectedItem.Text);
            }
            else
            {
                ubal.CityName = Convert.ToString(ViewState["city1"]);
            }
        }
        /////////////////////////////////////////////
        if (ddlRole.SelectedValue == "34" || ddlRole.SelectedValue == "35" || ddlRole.SelectedValue == "36")
        {
            if (ddlmenselection.SelectedValue == "1")
            {
                ubal.RoleName1 = Convert.ToString(ddlRole.SelectedItem.Text) + "-Public";
                ubal.RoleId1   = Convert.ToInt32(ddlRole.SelectedValue);
                //string roleid = Convert.ToString(ubal.RoleId1);  //unusable code
                //ubal.RoleId1 = Convert.ToInt32(roleid);
            }
            else if (ddlmenselection.SelectedValue == "2")
            {
                ubal.RoleName1 = Convert.ToString(ddlRole.SelectedItem.Text) + "-Govt";
                ubal.RoleId1   = Convert.ToInt32(ddlRole.SelectedValue);
                //string roleid = Convert.ToString(ubal.RoleId1); //unusable code
                //ubal.RoleId1 = Convert.ToInt32(roleid);
            }
        }
        else
        {
            ubal.RoleName1 = Convert.ToString(ddlRole.SelectedItem.Text);
            ubal.RoleId1   = Convert.ToInt32(ddlRole.SelectedValue);
        }
        //ubal.RoleName1 = Convert.ToString(ddlRole.SelectedItem.Text);
        /////////////////////////////////////////
        ubal.MONO = Convert.ToString(Session["Mobile"]);
        ubal.Date = Convert.ToString(cc.ChangeDate(txtDOB.Text));
        string rolename  = Convert.ToString(ViewState["RoleName"]);
        string rolename1 = ddlRole.SelectedItem.Text;

        if (rolename1 == rolename)
        {
            ubal.RoleId1 = Convert.ToInt16(ViewState["rid"]);
        }
        else
        {
            ubal.RoleId1 = Convert.ToInt32(ddlRole.SelectedValue);
        }
        ubal.Id  = Convert.ToString(ViewState["uid1"]);
        ubal.MID = Convert.ToInt32(ViewState["tbleid"]);
        status   = ubal.updateUser(ubal);
        if (status > 0)
        {
            if (ddlRole.SelectedValue == "29")
            {
                ubal.RoleName1 = Convert.ToString(ddlRole.SelectedItem.Text);
                ubal.MONO      = Convert.ToString(Session["Mobile"]);
                ubal.Date      = Convert.ToString(cc.ChangeDate(txtDOB.Text));
                ubal.RoleId1   = Convert.ToInt32(ddlRole.SelectedValue);
                for (int i = 0; i < chkCommitee.Items.Count; i++)
                {
                    if (chkCommitee.Items[i].Selected == true)
                    {
                        data = data + "," + chkCommitee.Items[i].Value;
                    }
                }
                if (data.Length > 1)
                {
                    data = data.Substring(1);
                }

                ubal.Id          = Convert.ToString(ViewState["User"]);
                ubal.Committeeid = data;
                status           = ubal.BLLGetUserId(ubal);
                if (status > 0)
                {
                    status = ubal.BLLUpdateUserCommittee(ubal);
                }
                else
                {
                    status = ubal.BLLinsertUserCommittee(ubal);
                }
            }
            else if (ddlRole.SelectedValue == "28")
            {
                data             = "1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31";
                ubal.Id          = Convert.ToString(ViewState["User"]);
                ubal.Committeeid = data;
                status           = ubal.BLLGetUserId(ubal);
                if (status > 0)
                {
                    status = ubal.BLLUpdateUserCommittee(ubal);
                }
                else
                {
                    status = ubal.BLLinsertUserCommittee(ubal);
                }
            }
            else
            {
                // changes by poonam - 7 aug-2013 for update AdminSubMarketingSubUser this table

                string sql1 = "select usrUserid from usermaster where usrMobileNo='" + Convert.ToString(Session["MobileNumber"]) + "'";
                string id   = cc.ExecuteScalar(sql1);
                if (id != "")
                {
                    string sql = "Update AdminSubMarketingSubUser set userid='" + id + "' ,roleid='" + ddlRole.SelectedValue + "',rolename='" + ddlRole.SelectedItem.Text + "',reference_id1='" + id + "' where [friendid]='" + Convert.ToString(ViewState["User"]) + "' ";
                    int    a   = cc.ExecuteNonQuery(sql);
                    if (a == 1)
                    {
                        string Sql = "Update UserMaster set IsMarketingPerson='Y' where UsrUserId='" + Convert.ToString(ViewState["User"]) + "'";
                        cc.ExecuteNonQuery(Sql);
                        ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('This Marketing Person Updated Successfully')", true);
                        Response.Redirect("../MarketingAdmin/UserList.aspx");
                        //HttpContext.Current.ApplicationInstance.CompleteRequest();
                    }
                }
            }
        }
    }