public int pets_counter() { SqlConnection conn = Connection_Manger.getConnection(); string query = "select count(*) from ad_miscellaneous_pets"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); int count = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return count; }
public int tender_notice_counter() { SqlConnection conn = Connection_Manger.getConnection(); string query = "select count(*) from ad_events_special_tender_notice"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); int count = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(count); }
public int software_counter() { SqlConnection conn = Connection_Manger.getConnection(); string query = "select count(*) from ad_electronics_software"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); int count = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(count); }
public int water_chiller_counter() { SqlConnection conn = Connection_Manger.getConnection(); string query = "select count(*) from ad_home_appliances_water_chiller"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); int count = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(count); }
public int shop_counter() { SqlConnection conn = Connection_Manger.getConnection(); string query = "select count(*) from ad_real_estate_shops"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); int count = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(count); }
public int technical_institutes_counter() { SqlConnection conn = Connection_Manger.getConnection(); string query = "select count(*) from ad_education_technical_institute"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); int count = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(count); }
public int languages_academies_counter() { SqlConnection conn = Connection_Manger.getConnection(); string query = "select count(*) from ad_education_launage_academies"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); int count = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(count); }
/* for new postad*/ public void getlocation(string city) { string query = "select ad_location from ad_city_location where ad_city='" + city + "'"; SqlConnection connection = Connection_Manger.getConnection(); SqlCommand command = new SqlCommand(query, connection); try { connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); } catch (Exception ex) { //MessageBox.Show(ex.Message); } }
public void insert_ad_education_montessori(string title, string city, string location, string content, string user_type, int price, string images, DateTime datetime, Guid userid, int views) { string query = "insert into ad_education_montessori values('" + title + "','" + city + "','" + location + "','" + content + "','" + user_type + "'," + price + ",'" + images + "','" + datetime + "','" + userid + "'," + views + ")"; SqlConnection connection = Connection_Manger.getConnection(); SqlCommand command = new SqlCommand(query, connection); try { connection.Open(); command.ExecuteNonQuery(); } catch (Exception ex) { //MessageBox.Show(ex.Message); } }
public void insert_ad_real_estate_offices(string title, string city, string location, string content, string user_type, int price, string address, string area, string area_unit, string aggrement_type, string facing, string property_type, string year_built, string floor, int no_of_bedrooms, int no_of_rooms, int no_of_bathrooms, string drawing_room, string dining_room, string furnished, string kitchen, string pool, string servent_quater, string lawn, string parking, string terrace, string corner_location, string balcony, string elevator, string images, DateTime datetime, Guid userid, int views) { string query = "insert into ad_real_estate_offices values('" + title + "','" + city + "','" + location + "','" + content + "','" + user_type + "'," + price + ",'" + address + "','" + area + "','" + area_unit + "','" + aggrement_type + "','" + facing + "','" + property_type + "','" + year_built + "','" + floor + "'," + no_of_bedrooms + "," + no_of_rooms + "," + no_of_bathrooms + ",'" + drawing_room + "','" + dining_room + "','" + furnished + "','" + kitchen + "','" + pool + "','" + servent_quater + "','" + lawn + "','" + parking + "','" + terrace + "','" + corner_location + "','" + balcony + "','" + elevator + "','" + images + "','" + datetime + "','" + userid + "'," + views + ")"; SqlConnection connection = Connection_Manger.getConnection(); SqlCommand command = new SqlCommand(query, connection); try { connection.Open(); command.ExecuteNonQuery(); } catch (Exception ex) { //MessageBox.Show(ex.Message); } }
public void insert_ad_real_estate_plots_lands(string title, string city, string location, string user_type, int price, string address, string area, string area_unit, string aggrement_type, string property_type, string images, string content, DateTime datetime, Guid userid, int views) { string query = "insert into ad_real_estate_plots_lands values('" + title + "','" + city + "','" + location + "','" + user_type + "'," + price + ",'" + address + "','" + area + "','" + area_unit + "','" + aggrement_type + "','" + property_type + "','" + images + "','" + content + "','" + datetime + "','" + userid + "'," + views + ")"; SqlConnection connection = Connection_Manger.getConnection(); SqlCommand command = new SqlCommand(query, connection); try { connection.Open(); command.ExecuteNonQuery(); } catch (Exception ex) { //MessageBox.Show(ex.Message); } }
/* AdbOOK METHODS */ public static void tempbook_data(int id, string category, string title, string description, DateTime datetime, string price, string city) { string query = null; SqlConnection connection = Connection_Manger.getConnection(); try { connection.Open(); query = "insert into temp values(" + id + ",'" + category + "','" + title + "','" + description + "','" + datetime + "','" + price + "','" + city + "')"; // string query = "insert into temp values(" + id + ",'" + category + "','" + title + "','" + description + "','" + datetime + "','" + price + "','" + city + "')"; SqlCommand command = new SqlCommand(query, connection); command.ExecuteNonQuery(); } catch (Exception ex) { // MessageBox.Show("error found in insertion"+ ex.Message); } }
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 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 selectCookingClassesID() { int cooking_id = -1; string query = "SELECT max(education_cooking_classes_id) FROM ad_education_cooking_classes"; SqlConnection connection = Connection_Manger.getConnection(); SqlCommand cmd = new SqlCommand(query, connection); try { connection.Open(); cooking_id = (int)cmd.ExecuteScalar(); } catch (Exception ex) { //MessageBox.Show(ex.Message); } return(cooking_id); }
public static int selectLaunageAcademiesID() { int launage_id = -1; string query = "SELECT max(education_launage_academies_id) FROM ad_education_launage_academies"; SqlConnection connection = Connection_Manger.getConnection(); SqlCommand cmd = new SqlCommand(query, connection); try { connection.Open(); launage_id = (int)cmd.ExecuteScalar(); } catch (Exception ex) { //MessageBox.Show(ex.Message); } return(launage_id); }
public static int selectprivateTutorsID() { int private_id = -1; string query = "SELECT max(education_private_tutors_id) FROM ad_education_private_tutors"; SqlConnection connection = Connection_Manger.getConnection(); SqlCommand cmd = new SqlCommand(query, connection); try { connection.Open(); private_id = (int)cmd.ExecuteScalar(); } catch (Exception ex) { //MessageBox.Show(ex.Message); } return(private_id); }
public static int selectshopsID() { int shop_id = -1; string query = "SELECT max(real_estate_shops_id) FROM ad_real_estate_shops"; SqlConnection connection = Connection_Manger.getConnection(); SqlCommand cmd = new SqlCommand(query, connection); try { connection.Open(); shop_id = (int)cmd.ExecuteScalar(); } catch (Exception ex) { //MessageBox.Show(ex.Message); } return(shop_id); }
public static int selectAuctionsID() { int auctios_id = -1; string query = "SELECT max(events_auctions_id) FROM ad_events_auctions"; SqlConnection connection = Connection_Manger.getConnection(); SqlCommand cmd = new SqlCommand(query, connection); try { connection.Open(); auctios_id = (int)cmd.ExecuteScalar(); } catch (Exception ex) { //MessageBox.Show(ex.Message); } return(auctios_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 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 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 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 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 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 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); }