private void btnCancel_Click(object sender, EventArgs e)
        {
            ShowYourAds sya = new ShowYourAds(userid, status);

            sya.Show();
            this.Hide();
        }
        private void btnDelete_Click(object sender, EventArgs e)
        {
            try
            {
                DBConnect dbc = new DBConnect();

                String query = "Delete from MessDetails where messid = " + messid + " ;";



                dbc.InsertIntoDatabase(query);

                //string folderPath = appStartPath + "\\AdvertisePicture\\MessAdsPicture\\" + messid.ToString();
                //DeleteDirectory(folderPath);
                //if (Directory.Exists(folderPath))
                //{
                //    Directory.Delete(folderPath, true);
                //}

                MessageBox.Show("Ads Deleted!");
                ShowYourAds sya = new ShowYourAds(userid, status);
                sya.Show();
                this.Hide();
            }
            catch (Exception er)
            {
                MessageBox.Show("Enter All Data Correctly");
                Console.WriteLine("Error : " + er);
            }
        }
예제 #3
0
 private void lblShowAds_Click(object sender, EventArgs e)
 {
     if (status == "Verified")
     {
         ShowYourAds sad = new ShowYourAds(userid, status);
         sad.Show();
         this.Hide();
     }
     else
     {
         MessageBox.Show(this, "Please Verify Your Account.");
     }
 }
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            string title = txtTitle.Text;
            //string month = combxMonth.GetItemText(combxMonth.SelectedItem);
            //string year = combxYear.GetItemText(combxYear.SelectedItem);
            //string date = month + ", " + year;
            string date     = dtpDate.Text;
            string seat     = txtSeat.Text;
            string rent     = txtRent.Text;
            string renttype = null;

            if (rbtnFixed.Checked)
            {
                renttype = "(Fixed)";
            }
            else if (rbtnNegotiable.Checked)
            {
                renttype = "(Negotiable)";
            }

            string address    = txtAddress.Text;
            string city       = combxCity.GetItemText(combxCity.SelectedItem);
            string area       = combxArea.GetItemText(combxArea.SelectedItem);
            string details    = txtDetails.Text;
            string ownerName  = txtOwnerName.Text;
            string ownerEmail = txtOwnerEmail.Text;
            string ownerPhone = txtOwnerPhone.Text;
            string newstatus  = "Unverified";

            try
            {
                DBConnect dbc = new DBConnect();

                String query = "Update MessDetails set userid = " + userid + ", title = '" + title + "', date = '" + date + "', seat = "
                               + seat + ", rent= " + rent + ", renttype= '" + renttype + "', address = '" + address + "', city = '" + city + "', area = '" + area + "', details = '" + details + "', name = '"
                               + ownerName + "', email = '" + ownerEmail + "', phone = '" + ownerPhone + "', status = '" + newstatus + "' where messid = " + messid + " ;";

                dbc.InsertIntoDatabase(query);
                MessageBox.Show("Ads Updated! Wait For Verification");
                ShowYourAds sya = new ShowYourAds(userid, status);
                sya.Show();
                this.Hide();
            }
            catch (Exception er)
            {
                MessageBox.Show("Enter All Data Correctly");
                Console.WriteLine("Error : " + er);
            }
        }
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            string title = txtTitle.Text;
            //string month = combxMonth.GetItemText(combxMonth.SelectedItem);
            //string year = combxYear.GetItemText(combxYear.SelectedItem);
            //string date = month + ", " + year;
            string date     = dtpDate.Text;
            string size     = txtSize.Text;
            string bedroom  = txtBedroom.Text;
            string bathroom = txtBathroom.Text;
            string corridor = txtCorridor.Text;
            string rent     = txtRent.Text;
            string renttype = null;

            if (rbtnFixed.Checked)
            {
                renttype = "(Fixed)";
            }
            else if (rbtnNegotiable.Checked)
            {
                renttype = "(Negotiable)";
            }

            String specialFacility = null;

            if (chkLift.Checked == true && chkWifi.Checked == true && chkGenerator.Checked == true)
            {
                specialFacility = "Lift, Generator, WiFi";
            }
            else if (chkLift.Checked == true && chkGenerator.Checked == true)
            {
                specialFacility = "Lift, Generator";
            }
            else if (chkGenerator.Checked == true && chkWifi.Checked == true)
            {
                specialFacility = "Generator, WiFi";
            }
            else if (chkLift.Checked == true && chkWifi.Checked == true)
            {
                specialFacility = "Lift, WiFi";
            }
            else if (chkLift.Checked)
            {
                specialFacility = "Lift";
            }
            else if (chkGenerator.Checked)
            {
                specialFacility = "Generator";
            }
            else if (chkWifi.Checked)
            {
                specialFacility = "WiFi";
            }

            string address    = txtAddress.Text;
            string city       = combxCity.GetItemText(combxCity.SelectedItem);
            string area       = combxArea.GetItemText(combxArea.SelectedItem);
            string details    = txtDetails.Text;
            string ownerName  = txtOwnerName.Text;
            string ownerEmail = txtOwnerEmail.Text;
            string ownerPhone = txtOwnerPhone.Text;
            string newstatus  = "Unverified";

            try
            {
                DBConnect dbc = new DBConnect();

                String query = "Update FlatDetails set userid = " + userid + ", title = '" + title + "', date = '" + date + "', size = " + size + ", bedroom = "
                               + bedroom + ", bathroom = " + bathroom + ", corridor= " + corridor + ", rent= " + rent + ", renttype= '" + renttype + "', specialfacility= '"
                               + specialFacility + "', address = '" + address + "', city = '" + city + "', area = '" + area + "', details = '" + details + "', name = '"
                               + ownerName + "', email = '" + ownerEmail + "', phone = '" + ownerPhone + "', status = '" + newstatus + "' where flatid = " + flatid + " ;";

                dbc.InsertIntoDatabase(query);
                MessageBox.Show("Ads Updated! Wait For Verification");
                ShowYourAds sya = new ShowYourAds(userid, status);
                sya.Show();
                this.Hide();
            }
            catch (Exception er)
            {
                MessageBox.Show("Enter All Data Correctly");
                Console.WriteLine("Error : " + er);
            }
        }