public static int selectpetID()
{
int pet_id = -1;
string query = "SELECT max(miscellaneous_pets_id) FROM ad_miscellaneous_pets";
SqlConnection connection = Connection_Manger.getConnection();
SqlCommand cmd = new SqlCommand(query, connection);
try
{
connection.Open();
pet_id = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
return(pet_id);
}
public static int selectGroomID()
{
int groom_id = -1;
string query = "SELECT max(Matrimonial_grooms_id) FROM ad_Matrimonial_grooms";
SqlConnection connection = Connection_Manger.getConnection();
SqlCommand cmd = new SqlCommand(query, connection);
try
{
connection.Open();
groom_id = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
return(groom_id);
}
public static int selectadcarID()
{
int book_id = -1;
string query = "SELECT max(autos_car_id) FROM ad_autos_car ";
SqlConnection connection = Connection_Manger.getConnection();
SqlCommand cmd = new SqlCommand(query, connection);
try
{
connection.Open();
book_id = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
// MessageBox.Show( ex.Message);
}
return(book_id);
}
public static int selectMobileAccessoriesID()
{
int mobile_id = -1;
string query = "SELECT max(electronics_mobile_accessories_id) FROM ad_electronics_mobile_accessories";
SqlConnection connection = Connection_Manger.getConnection();
SqlCommand cmd = new SqlCommand(query, connection);
try
{
connection.Open();
mobile_id = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
return(mobile_id);
}
public static int selectSoftwareID()
{
int software_id = -1;
string query = "SELECT max(electronics_software_id) FROM ad_electronics_software";
SqlConnection connection = Connection_Manger.getConnection();
SqlCommand cmd = new SqlCommand(query, connection);
try
{
connection.Open();
software_id = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
return(software_id);
}
public static int selectshortCoursesID()
{
int short_id = -1;
string query = "SELECT max(education_short_courses_id) FROM ad_education_short_courses";
SqlConnection connection = Connection_Manger.getConnection();
SqlCommand cmd = new SqlCommand(query, connection);
try
{
connection.Open();
short_id = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
return(short_id);
}
public static int selectTechnicalInstitutesID()
{
int technical_id = -1;
string query = "SELECT max(education_technical_institute_id) FROM ad_education_technical_institute";
SqlConnection connection = Connection_Manger.getConnection();
SqlCommand cmd = new SqlCommand(query, connection);
try
{
connection.Open();
technical_id = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
return(technical_id);
}
public static int selectHomeTutionID()
{
int home_id = -1;
string query = "SELECT max(education_home_tution_id) FROM ad_education_home_tution";
SqlConnection connection = Connection_Manger.getConnection();
SqlCommand cmd = new SqlCommand(query, connection);
try
{
connection.Open();
home_id = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
return(home_id);
}
public static int selectedOtherVehicleID()
{
int other_vehicle_id = -1;
string query = "SELECT max(autos_other_vehicle_id) FROM ad_autos_other_vehicle";
SqlConnection connection = Connection_Manger.getConnection();
SqlCommand cmd = new SqlCommand(query, connection);
try
{
connection.Open();
other_vehicle_id = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
return(other_vehicle_id);
}
public static int selectWaterChillerID()
{
int water_id = -1;
string query = "SELECT max(home_appliances_water_chiller_id) FROM ad_home_appliances_water_chiller";
SqlConnection connection = Connection_Manger.getConnection();
SqlCommand cmd = new SqlCommand(query, connection);
try
{
connection.Open();
water_id = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
return(water_id);
}
public static int selectTenderID()
{
int tender_id = -1;
string query = "SELECT max(events_special_tender_notice_id) FROM ad_events_special_tender_notice";
SqlConnection connection = Connection_Manger.getConnection();
SqlCommand cmd = new SqlCommand(query, connection);
try
{
connection.Open();
tender_id = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
return(tender_id);
}
public static int selectlostsID()
{
int lost_id = -1;
string query = "SELECT max(events_lots_funds_id) FROM ad_events_lots_funds";
SqlConnection connection = Connection_Manger.getConnection();
SqlCommand cmd = new SqlCommand(query, connection);
try
{
connection.Open();
lost_id = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
return(lost_id);
}