Пример #1
0
        private void saveData()
        {
            if (!validationProvider1.Validate())
            {
                this.validationProvider1.ValidationMessages(!this.validationProvider1.Validate());
                return;
            }
            //  if (propPresent())
            //  {
            //      MessageBox.Show($"Property '{PName.Text}' is already registered!!");
            //     return;
            //  }
            byte[] imagePath = null;
            int    available = (availability.Checked) ? 1 : 0;
            int    gard      = (garden.Checked) ? 1 : 0;
            int    corn      = (corner.Checked) ? 1 : 0;
            String pidVal    = "";

            if (image.Text != "")
            {
                FileStream stream = new FileStream(image.Text, FileMode.Open, FileAccess.Read);
                imagePath = new BinaryReader(stream).ReadBytes((int)stream.Length);
            }

            String property_name = PName.Text;

            con.Open();
            String        qry1 = $"Update property set PropertyName='{PName.Text}',Address='{Address.Text}',AskPrice={askPrice.Text},Availablity={available} where PID={selectedpid} ;";
            SqlDataReader dr   = new SqlCommand(qry1, con).ExecuteReader();

            dr.Close();
            String qry2 = $"Update {Buy_RentText.Text} set Area={area.Text},Rooms={rooms.Text},NoFloors={noFloor.Text},Floor={floorNo.Text},Parking={parking.Text}," +
                          $"Road={roads.Text},RegYear=@regYear,Garden={gard},Corner={corn},Additional='{additional.Text}' where PID={selectedpid}; ";


            if (imagePath != null)
            {
                qry2 = $"Update {Buy_RentText.Text} set Area={area.Text},Rooms={rooms.Text},NoFloors={noFloor.Text},Floor={floorNo.Text},Parking={parking.Text}," +
                       $"Road={roads.Text},RegYear=@regYear,Garden={gard},Corner={corn},Additional={additional.Text},Photo=@imagePath where PID={selectedpid}; ";
            }
            SqlCommand cmd = new SqlCommand(qry2, con);

            cmd.Parameters.Add("@regYear", SqlDbType.Date).Value = regDate.Value.Date;
            if (imagePath != null)
            {
                cmd.Parameters.Add("@imagePath", imagePath);
            }

            cmd.ExecuteReader();

            MessageBox.Show("Changes Saved successfully");
            dr.Close();
            con.Close();
            MyProperties_UserControl.Instance.refreshDataGridView(User_Details.UID);
            Property_Viewer obj = new Property_Viewer(selectedpid);

            obj.Show();
            this.Hide();
        }
Пример #2
0
 private void boughtView_CellContentClick(object sender, DataGridViewCellEventArgs e)
 {
     if (e.RowIndex >= 0)
     {
         DataGridViewRow row          = this.boughtView.Rows[e.RowIndex];
         String          selected_pid = row.Cells["PID"].Value.ToString();
         if (MessageBox.Show($"Do you want to see property '{row.Cells["PID"].Value.ToString()}'??", "Message", MessageBoxButtons.YesNo) == DialogResult.Yes)
         {
             Property_Viewer obj = new Property_Viewer(selected_pid);
             obj.Show();
         }
     }
 }