public MySqlDataReader ReturnUpazillaId(Upazilla Obj, District Obj2)
{
string Query = "SELECT * FROM upazilla WHERE name = '" + Obj.name + "' AND d_id = '" + Obj2.d_id + "'";
string ConnectionString = ConfigurationManager.ConnectionStrings["TimeShareConnection"].ConnectionString;
MySqlConnection Connection = new MySqlConnection(ConnectionString);
MySqlCommand Command = new MySqlCommand(Query, Connection);
Connection.Open();
MySqlDataReader Reader = Command.ExecuteReader();
return Reader;
}
public MySqlDataReader ReturnDistrictId(District Obj)
{
string Query = "SELECT * FROM district WHERE name = '" + Obj.name + "'";
string ConnectionString = ConfigurationManager.ConnectionStrings["TimeShareConnection"].ConnectionString;
MySqlConnection Connection = new MySqlConnection(ConnectionString);
MySqlCommand Command = new MySqlCommand(Query, Connection);
Connection.Open();
MySqlDataReader Reader = Command.ExecuteReader();
return Reader;
}
public MySqlDataReader ReturnAddressId(District Obj, Upazilla Obj2)
{
string Query = "SELECT * FROM address WHERE district = '" + Obj.d_id + "' AND upazilla = '" + Obj2.uzilla_id + "'";
string ConnectionString = ConfigurationManager.ConnectionStrings["TimeShareConnection"].ConnectionString;
MySqlConnection Connection = new MySqlConnection(ConnectionString);
MySqlCommand Command = new MySqlCommand(Query, Connection);
Connection.Open();
MySqlDataReader Reader = Command.ExecuteReader();
return Reader;
}