Пример #1
0
 protected void LnkBtnAddQuestion_Click(object sender, EventArgs e)
 {
     //throw new Exception("Add Question");
     DivAddQuestionModal.Visible = true;
     TxtQuestion.Focus();
     this.Form.DefaultButton = BtnAddQuestion.UniqueID;
 }
Пример #2
0
    protected void BtnSave_Click(object sender, EventArgs e)
    {
        try
        {
            if (TxtUserId.Text.Length == 0)
            {
                // LblMsg.Text = "User Id Is Blank, Enter Valid User Id....";
                TxtUserId.Focus();
                return;
            }

            if (TxtUserName.Text.Length == 0)
            {
                // LblMsg.Text = "User Name Is Blank, Enter Valid User Name....";
                TxtUserName.Focus();
                return;
            }

            if (TxtLoginName.Text.Length == 0)
            {
                //LblMsg.Text = "Login Name Is Blank, Enter Valid Login Name....";
                TxtLoginName.Focus();
                return;
            }

            if (DDLUserGroup.SelectedValue == "0")
            {
                //LblMsg.Text = "Select User Group....";
                DDLUserGroup.Focus();
                return;
            }

            if (TxtDOB.Text.Length == 0)
            {
                //LblMsg.Text = "DOB Is Blank, Enter Valid Brith Date....";
                TxtDOB.Focus();
                return;
            }

            if (TxtEMailId.Text.Length == 0)
            {
                //LblMsg.Text = "EMail Id Is Blank, Enter Valid EMail Id....";
                TxtEMailId.Focus();
                return;
            }

            if (TxtMobNo.Text.Length == 0)
            {
                //LblMsg.Text = "Mob.No Is Blank, Enter Valid Mob.No....";
                TxtMobNo.Focus();
                return;
            }

            if (TxtPassword.Text.Length == 0)
            {
                //LblMsg.Text = "Password Is Blank, Enter Valid Password....";
                TxtPassword.Focus();
                return;
            }

            if (TxtQuestion.Text.Length == 0)
            {
                //LblMsg.Text = "Question Is Blank, Enter Valid Question....";
                TxtQuestion.Focus();
                return;
            }

            if (TxtAnswer.Text.Length == 0)
            {
                //LblMsg.Text = "Answer Is Blank, Enter Valid Answer....";
                TxtAnswer.Focus();
                return;
            }

            StrSql        = new StringBuilder();
            StrSql.Length = 0;


            if (HidFldId.Value.Length == 0)
            {
                StrSql.AppendLine("Insert Into User_Mast (UId,UserName,LoginName");
                StrSql.AppendLine(",UserGroup,Password ");
                StrSql.AppendLine(",Gender,EMailId,DOB");
                StrSql.AppendLine(",CountryId,StateId,CityId");
                StrSql.AppendLine(",MobNo,Phone");
                StrSql.AppendLine(",Question,Answer");
                StrSql.AppendLine(",Activation");
                StrSql.AppendLine(",Entry_Date,Entry_Time");
                StrSql.AppendLine(",Entry_UID,UPDFLAG)");

                StrSql.AppendLine("Values(@UserId,@UserName,@LoginName");
                StrSql.AppendLine(",@UserGroup,@Password ");
                StrSql.AppendLine(",@Gender,@EMailId,@DOB");
                StrSql.AppendLine(",@CountryId,@StateId,@CityId");
                StrSql.AppendLine(",@MobNo,@Phone");
                StrSql.AppendLine(",@Question,@Answer");
                StrSql.AppendLine(",@Activation");
                StrSql.AppendLine(",GetDate(),Convert(VarChar,GetDate(),108)");
                StrSql.AppendLine(",@Entry_UID,0)");
            }
            else
            {
                StrSql.AppendLine("Update User_Mast Set UId=@UserId,UserName=@UserName,LoginName=@LoginName");
                StrSql.AppendLine(",UserGroup=@UserGroup,Password=@Password ");
                StrSql.AppendLine(",Gender=@Gender,EMailId=@EMailId,DOB=@DOB");
                StrSql.AppendLine(",CountryId=@CountryId,StateId=@StateId,CityId=@CityId");
                StrSql.AppendLine(",MobNo=@MobNo,Phone=@Phone");
                StrSql.AppendLine(",Question=@Question,Answer=@Answer");
                StrSql.AppendLine(",Activation=@Activation");
                StrSql.AppendLine(",MEntry_Date=GetDate(),MEntry_Time=Convert(Varchar,GetDate(),108)");
                StrSql.AppendLine(",MEntry_UID=@Entry_UID,UPDFLAG=IsNull(UPDFlag,0)+1");
                StrSql.AppendLine("Where Id=@Id");
            }

            Cmd = new SqlCommand(StrSql.ToString(), SqlFunc.gConn);
            Cmd.Parameters.AddWithValue("@UserId", TxtUserId.Text.Trim());
            Cmd.Parameters.AddWithValue("@UserName", TxtUserName.Text.Trim());
            Cmd.Parameters.AddWithValue("@LoginName", TxtLoginName.Text.Trim());
            Cmd.Parameters.AddWithValue("@UserGroup", DDLUserGroup.SelectedValue);
            Cmd.Parameters.AddWithValue("@Password", Sec.Encrypt(TxtPassword.Text.Trim()));
            Cmd.Parameters.AddWithValue("@Gender", rblGender.SelectedValue);
            Cmd.Parameters.AddWithValue("@EMailId", TxtEMailId.Text.Trim());

            Cmd.Parameters.AddWithValue("@DOB", ValueConvert.ConvertDate(TxtDOB.Text));

            if (ddlCountry.SelectedValue != "0")
            {
                Cmd.Parameters.AddWithValue("@CountryId", ddlCountry.SelectedValue);
            }
            else
            {
                Cmd.Parameters.AddWithValue("@CountryId", DBNull.Value);
            }
            if (ddlState.SelectedValue != "0")
            {
                Cmd.Parameters.AddWithValue("@StateId", ddlState.SelectedValue);
            }
            else
            {
                Cmd.Parameters.AddWithValue("@StateId", DBNull.Value);
            }
            if (ddlCity.SelectedValue != "0")
            {
                Cmd.Parameters.AddWithValue("@CityId", ddlCity.SelectedValue);
            }
            else
            {
                Cmd.Parameters.AddWithValue("@CityId", DBNull.Value);
            }
            Cmd.Parameters.AddWithValue("@MobNo", TxtMobNo.Text.Trim());
            Cmd.Parameters.AddWithValue("@Phone", TxtPhone.Text.Trim());
            Cmd.Parameters.AddWithValue("@Question", TxtQuestion.Text.Trim());
            Cmd.Parameters.AddWithValue("@Answer", TxtAnswer.Text.Trim());
            Cmd.Parameters.AddWithValue("@Activation", 0);
            Cmd.Parameters.AddWithValue("@Entry_UID", HidFldUID.Value.ToString());

            if (HidFldId.Value.Length == 0)
            {
                SqlFunc.ExecuteNonQuery(Cmd);
                LblMsg.Text = "User added successfully";
            }
            else
            {
                Cmd.Parameters.AddWithValue("@ID", HidFldId.Value.ToString());

                SqlFunc.ExecuteNonQuery(Cmd);
                LblMsg.Text = "User updated successfully";
            }


            FillGrid();

            ClearAll();

            MyMenu.Items[0].Selected    = true;
            MyMenu.Items[0].ImageUrl    = "~/Images/ViewEnable.jpg";
            MyMultiView.ActiveViewIndex = 0;
            MyMenu.Items[1].ImageUrl    = "~/Images/NewOrEditDisable.jpg";
        }
        catch (Exception ex)
        {
            Response.Write(ex);
        }
    }