public State ToModel(SqlDataReader reader) { State state = new State(); state.StateId = (int)ToModelValue(reader,"StateId"); state.StateName = (string)ToModelValue(reader,"StateName"); state.CountryId = (int)ToModelValue(reader,"CountryId"); state.Latitude = (double)ToModelValue(reader,"Latitude"); state.Longitude = (double)ToModelValue(reader,"Longitude"); return state; }
public int Update(State state) { string sql = "UPDATE States SET StateName=@StateName,CountryId=@CountryId,Latitude=@Latitude,Longitude=@Longitude WHERE StateId = @StateId"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@StateId", state.StateId) ,new SqlParameter("@StateName", ToDBValue(state.StateName)) ,new SqlParameter("@CountryId", ToDBValue(state.CountryId)) ,new SqlParameter("@Latitude", ToDBValue(state.Latitude)) ,new SqlParameter("@Longitude", ToDBValue(state.Longitude)) }; return SqlHelper.ExecuteNonQuery(sql, para); }
public int Update(State state) { return new StateDal().Update(state); }
public State Add(State state) { string sql ="INSERT INTO States (StateName, CountryId, Latitude, Longitude) output inserted.StateId VALUES (@StateName, @CountryId, @Latitude, @Longitude)"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@StateName", ToDBValue(state.StateName)), new SqlParameter("@CountryId", ToDBValue(state.CountryId)), new SqlParameter("@Latitude", ToDBValue(state.Latitude)), new SqlParameter("@Longitude", ToDBValue(state.Longitude)), }; int newId = (int)SqlHelper.ExecuteScalar(sql, para); return GetByStateId(newId); }
public State Add(State state) { return new StateDal().Add(state); }