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);
}
}
