public void InsertCity(BALCity obj)
{
query = "insert into City(cityname,stateid) values ('" + obj.CityName + "'," + obj.StateId + ")";
SqlCommand cmd= new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void UpdateCity(BALCity obj)
{
query = "update City set cityname='" + obj.CityName + "',stateid='" + obj.StateId + "' where cityid=" + obj.CityId;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void UpdateCity(BALCity obj)
{
query = "update City set CityName='" + obj.CityName;
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertCity(BALCity obj)
{
query = "insert into City(CityName) values ('" + obj.CityName + "')";
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void DeleteCity(BALCity obj)
{
query = "delete from City where CityId=" + obj.CityId;
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public DataSet SelectCityByCityId(BALCity obj)
{
query = "select * from City c inner join State s on c.stateid=s.stateid where c.cityid=" + obj.CityId;
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(query, con);
adp.Fill(ds);
return ds;
}
public void insertCity(BALCity obj)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "spInsertCity";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@cityname", obj.CityName);
cmd.Parameters.AddWithValue("@stateid", obj.StateID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
