private static SqlParameter[] CreateSqlParameter(sys_WebApiConfig model) { return(new SqlParameter[] { new SqlParameter("@apino", model.apino), new SqlParameter("@Webiste", model.Webiste), }); }
private static sys_WebApiConfig GetItemFromReader(IDataReader dataReader) { sys_WebApiConfig objItem = new sys_WebApiConfig(); objItem.apino = SqlHelper.GetString(dataReader, "apino"); objItem.Webiste = SqlHelper.GetString(dataReader, "Webiste"); return(objItem); }
public static sys_WebApiConfig UpdateItem(sys_WebApiConfig model) { String result = String.Empty; using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "sys_WebApiConfig_Update", CreateSqlParameter(model))) { while (reader.Read()) { result = (String)reader[0]; } } return(GetItemByID(result)); }
public static sys_WebApiConfigCollection GetAllItem() { sys_WebApiConfigCollection collection = new sys_WebApiConfigCollection(); using (var reader = SqlHelper.ExecuteReader("sys_WebApiConfig_GetAll", null)) { while (reader.Read()) { sys_WebApiConfig obj = new sys_WebApiConfig(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static sys_WebApiConfig GetItemByID(String apino) { sys_WebApiConfig item = new sys_WebApiConfig(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@apino", apino); using (var reader = SqlHelper.ExecuteReader("sys_WebApiConfig_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }