private void btnScript_Click(object sender, EventArgs e) { Clint_Script sc = new Clint_Script(Convert.ToInt32(houseBox.Text)); sc.Show(); }
private void button1_Click_1(object sender, EventArgs e) { String cname = tbxCuName.Text; String cAdress = tbxadrs.Text; String cNic = tbxnic.Text; String Hnum = houseBox.Text; String d = DateTime.Now.ToShortDateString(); Random r = new Random(); id = r.Next(200, 999); DialogResult result; try { if (cname != "" && cAdress != "" && cNic != "" && Hnum != "" && comboCus.Text == "new") //&& comboCus.Text=="new" { OleDbCommand cmd = new OleDbCommand("Insert into clint_details(CID,clint_name,clint_address,clint_nic) values(?,?,?,?); ", a.conn); cmd.Parameters.AddWithValue("@p1", id); cmd.Parameters.AddWithValue("@p2", cname); cmd.Parameters.AddWithValue("@p3", cAdress); cmd.Parameters.AddWithValue("@p4", cNic); cmd.ExecuteNonQuery(); OleDbCommand rmd = new OleDbCommand("Insert into booking_details(CID,house_number,booking_date) values('" + id + "','" + Hnum + "','" + d + "'); ", a.conn); rmd.ExecuteNonQuery(); result = MessageBox.Show("Do you want Generate Report?", "Question", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { Clint_Script sc = new Clint_Script(Convert.ToInt32(houseBox.Text)); sc.Show(); } } else if (comboCus.Text == "Old" && combocusName.Text != "" && Hnum != "") { OleDbCommand cmd = new OleDbCommand("Select* from clint_details where clint_name='" + combocusName.Text + "'", a.conn); OleDbDataReader rd = cmd.ExecuteReader(); //int iid = Convert.ToInt16(rd[0]); if (rd.Read()) { OleDbCommand rmd = new OleDbCommand("Insert into booking_details(CID,house_number,booking_date) values('" + Convert.ToInt16(rd[0]) + "','" + Hnum + "','" + d + "'); ", a.conn); rmd.ExecuteNonQuery(); } result = MessageBox.Show("Do you want Generate Report?", "Question", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { Clint_Script sc = new Clint_Script(Convert.ToInt16(houseBox.Text)); sc.Show(); } else { MessageBox.Show("House number " + houseBox.Text + " given to rent "); } } else { MessageBox.Show("Fill all Fields"); } OleDbCommand cm = new OleDbCommand("SELECT house_details.house_number, house_details.house_address, house_details.house_price FROM house_details LEFT JOIN booking_details ON house_details.house_number=booking_details.house_number WHERE (((booking_details.house_number) Is Null));", a.conn); populate(listView1, cm); } catch (Exception ex) { MessageBox.Show(ex.Message); } }