public void UpdateArea(BALArea obj)
{
query = "update Area set AreaName='"+obj.AreaName+"',CityId="+obj.CityId+" where AreaId="+obj.AreaId;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertArea(BALArea obj)
{
query = "insert into Area (AreaName,CityId) values ('"+obj.AreaName+"',"+obj.CityId+")";
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public DataSet SelectAreaByCityID(BALArea obj)
{
query = "select * from Area a inner join City c on a.CityId=c.CityId where a.CityId="+obj.CityId;
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(query, con);
adp.Fill(ds);
return ds;
}
public void DeleteArea(BALArea obj)
{
query = "delete from Area where AreaId="+obj.AreaId;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
