public DataTable searchAppointment(appointment_administrator a)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
appointment_administrator aa = new appointment_administrator();
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Bishal\Desktop\Municipal management\Appointment.mdf;Integrated Security=True;Connect Timeout=30");
con.Open();
try
{
SqlCommand cmd = new SqlCommand("select * from Appointment where IdNo ='" + aa.IdNo + "'", con);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
//SqlDataReader reader = cmd.ExecuteReader();
adapter.Fill(ds);
dt = ds.Tables[0];
//dt = reader;
return(dt);
// return reader;
}
catch
{
con.Close();
throw;
}
}
//appointment
public int insertAppointment(appointment_administrator aa)
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Bishal\Desktop\Municipal management\Appointment.mdf;Integrated Security=True;Connect Timeout=30");
con.Open();
SqlCommand cmd = new SqlCommand("insert into Appointment (IdNo,AppointmentDate)values('" + aa.IdNo + "','" + aa.AppointmentDate + "')", con);
try
{
return(cmd.ExecuteNonQuery());
}
catch
{
con.Close();
throw;
}
}
private void subButton_Click(object sender, EventArgs e)
{
appointment_administrator ab = new appointment_administrator();
ab.IdNo = voteridBox.Text;
ab.AppointmentDate = dateTimePicker1.Text;
int rows = ab.getA(ab);
if (rows > 0)
{
MessageBox.Show("Submitted..Wait for your Serial No");
}
else
{
MessageBox.Show("Error!!!");
}
}
