private void btnPNewOK_Click(object sender, EventArgs e)
        {
            frmSDAlarm sda = new frmSDAlarm();

            try
            {
                if (Convert.ToString(txtPName.Text).Trim() == "")
                {
                    MessageBox.Show("Name can not be Blank..", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }

                string sFsdAl = txtPName.Text.ToString().TrimEnd(' ');
                sFsdAl = sFsdAl.TrimStart(' ');

                if (!string.IsNullOrEmpty(sFsdAl))
                {
                    if (Convert.ToInt32(txtPValue.Text) > 100)
                    {
                        MessageBox.Show("Percentage alarm should be less than 100", "Name error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        txtPValue.Text = "";
                        return;
                    }
                    bool IsSpecial = sda.CheckForSpecialCharacter(sFsdAl);
                    if (!IsSpecial)
                    {
                        if (sFsdAl.Length > 8)
                        {
                            MessageBox.Show("Max limit for alarm name is 8 characters", "Name error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                        }
                        else
                        {
                            this.PPercentName = sFsdAl;

                            if ((float)Convert.ToDouble(txtPValue.Text) >= 0)
                            {
                                this.PPercentValue = (float)Convert.ToDouble(txtPValue.Text);
                                this.Close();
                            }
                            else
                            {
                                MessageBox.Show("Negative values not accepted");
                            }
                        }
                    }
                    else
                    {
                        MessageBox.Show("Name Field Error", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Not Accepted", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                System.Diagnostics.Debug.WriteLine(ex.Message, ex.StackTrace);
            }
        }
        private void btnOk_Click(object sender, EventArgs e)
        {
            objSD = new frmSDAlarm();
            try
            {
                bool sLogin = false;
                sUName     = txtUsrName.Text.Trim().ToString();
                suPassword = txtPassword.Text.Trim().ToString();

                string uID = "";

                checkPassword = PublicClass.CheckForSpecialCharacter(suPassword);

                if (sUName == "" || suPassword == "")
                {
                    MessageBox.Show("User Name & Password can not be blank", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                else if (checkPassword == false)
                {
                    MessageBox.Show("Special character is mondetory");
                    return;
                }
                else if (suPassword.Length < 6)
                {
                    MessageBox.Show("Password must be of minimum 6 character");
                    return;
                }

                else
                {
                    if (sLogin == true)
                    {
                        LoginStatus = 1;
                    }
                    else
                    {
                        LoginStatus = 0;
                    }

                    DataTable dtu = new DataTable();
                    dtu = DbClass.getdata(CommandType.Text, "Select distinct  ID, UserName,Password,Password,Login from userdetail where UserName= '******'  ");
                    foreach (DataRow dr in dtu.Rows)
                    {
                        uID = Convert.ToString(dr["ID"]);
                    }

                    if (ADD_Edit == "Insert")
                    {
                        if (Convert.ToString(uID).Trim() != "")
                        {
                            MessageBox.Show(this, "This name is already exist", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                            return;
                        }
                        else
                        {
                            DbClass.executequery(CommandType.Text, "insert into userdetail(UserName,Password,Login,LastloginDate,DatabaseName) values('" + sUName.Trim() + "' , '" + suPassword.Trim() + "' ,  " + LoginStatus + ", '" + PublicClass.GetDatetime() + "' , '" + PublicClass.databasename + "')");
                            DbClass.executequery(CommandType.Text, "Insert into login_data(User_ID,uPassword,Upload,Download) values('" + sUName.Trim() + "' , '" + suPassword.Trim() + "' ," + 0 + ", " + 0 + " )");
                        }
                    }
                    else if (ADD_Edit == "Edit")
                    {
                        if (PublicClass.uName.Trim() != sUName || PublicClass.uPassword.Trim() != suPassword)
                        {
                            DbClass.executequery(CommandType.Text, "Update userdetail set UserName = '******' , Password = '******' , Login = '******'  where ID = '" + PublicClass.uID.Trim() + "'  ");
                            DbClass.executequery(CommandType.Text, "Update usersettings set UserName = '******' where UserDetailID = '" + PublicClass.uID.Trim() + "' ");
                            DbClass.executequery(CommandType.Text, "Update login_data set User_ID = '" + sUName + "' , uPassword = '******' where User_ID = '" + PublicClass.uName.Trim() + "' and uPassword = '******'");
                            MessageBox.Show("Update Successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }
                    this.Close();
                }
            }
            catch
            {
            }
        }