public static DataTable GetAll(Entity.Common.City city) { using (DataTable dt = new DataTable()) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_Common_City_GetAll"; if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } con.Close(); } } return(dt); } }
public static Entity.Common.City GetById(int cityid) { Entity.Common.City city = new Entity.Common.City(); using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Parameters.AddWithValue("@CityId", cityid); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_Common_City_GetById"; if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { if (dr.HasRows) { city.CityId = cityid; city.CityName = dr["CityName"].ToString(); city.STD = (dr["STD"] == DBNull.Value) ? "" : dr["STD"].ToString(); city.StateId = int.Parse(dr["StateId_FK"].ToString()); city.DistrictId = int.Parse(dr["DistrictId"].ToString()); city.CountryId = int.Parse(dr["CountryId"].ToString()); } } con.Close(); } } return(city); }
public static int Save(Entity.Common.City city) { int rowsAffacted = 0; using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "usp_Common_City_Save"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CityId", city.CityId); cmd.Parameters.AddWithValue("@DistrictId", city.DistrictId); cmd.Parameters.AddWithValue("@CityName", city.CityName); cmd.Parameters.AddWithValue("@STD", city.STD); if (con.State == ConnectionState.Closed) { con.Open(); } rowsAffacted = cmd.ExecuteNonQuery(); con.Close(); } } return(rowsAffacted); }
public DataTable GetAll(Entity.Common.City city) { return(DataAccess.Common.City.GetAll(city)); }
public int Save(Entity.Common.City city) { return(DataAccess.Common.City.Save(city)); }