public List <Location_OF_Land_DATA> select_All()
{
List <Location_OF_Land_DATA> Location_OF_Land_list = new List <Location_OF_Land_DATA>();
SqlConnection con = new SqlConnection(" Data Source=MOHAMED-PC;Initial Catalog=Real_Estate_Management;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Select_All_Location_OF_Land", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr;
con.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Location_OF_Land_DATA Location_OF_Land = new Location_OF_Land_DATA();
Location_OF_Land.City = rdr["City"].ToString();
Location_OF_Land.Country = rdr["Country"].ToString();
Location_OF_Land.Governorate = rdr["Governorate"].ToString();
Location_OF_Land.ID = (int)rdr["ID"];
Location_OF_Land.Piece_Number = (long)(rdr["Piece_Number"]);
Location_OF_Land.Street_NAME = rdr["Street_NAME"].ToString();
Location_OF_Land_list.Add(Location_OF_Land);
Location_OF_Land.FK_Land = (int)rdr["FK_Land"];
}
con.Close();
return(Location_OF_Land_list);
}
public Location_OF_Land_DATA select_Item(int ID)
{
Location_OF_Land_DATA Location_OF_Land = new Location_OF_Land_DATA();
SqlConnection con = new SqlConnection(" Data Source=MOHAMED-PC;Initial Catalog=Real_Estate_Management;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Insert_Location_OF_Land", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", ID);
SqlDataReader rdr;
con.Open();
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
Location_OF_Land.City = rdr["City"].ToString();
Location_OF_Land.Country = rdr["Country"].ToString();
Location_OF_Land.Governorate = rdr["Governorate"].ToString();
Location_OF_Land.ID = (int)rdr["ID"];
Location_OF_Land.Piece_Number = (long)(rdr["Numer_of_Building"]);
Location_OF_Land.Street_NAME = rdr["Street_NAME"].ToString();
Location_OF_Land.FK_Land = (int)rdr["FK_Land"];
}
con.Close();
return(Location_OF_Land);
}
public void delete(Location_OF_Land_DATA Location_OF_Land)
{
SqlConnection con = new SqlConnection(" Data Source=MOHAMED-PC;Initial Catalog=Real_Estate_Management;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Delete_Location_OF_Land", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("ID", Location_OF_Land.ID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void update(Location_OF_Land_DATA Location_OF_Land)
{
SqlConnection con = new SqlConnection(" Data Source=MOHAMED-PC;Initial Catalog=Real_Estate_Management;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Update_Location_OF_Land", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("City", Location_OF_Land.City);
cmd.Parameters.AddWithValue("Country", Location_OF_Land.Country);
cmd.Parameters.AddWithValue("Governorate", Location_OF_Land.Governorate);
cmd.Parameters.AddWithValue("FK_Land", Location_OF_Land.FK_Land);
cmd.Parameters.AddWithValue("Street_NAME", Location_OF_Land.Street_NAME);
cmd.Parameters.AddWithValue("Piece_Number", Location_OF_Land.Piece_Number);
cmd.Parameters.AddWithValue("ID", Location_OF_Land.ID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
