public clsBandsBlock getBands(clsBandsBlock pclsBandsBlock, ref clsResponse pclsResponse, int pintUserID, int pintOffset, int pintLimit) { try { SqlCommand cmd = new SqlCommand("myFan.SP_GetBandasPorFanatico", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@intOffset", System.Data.SqlDbType.Int).Value = pintOffset; cmd.Parameters.Add("@intRows", System.Data.SqlDbType.Int).Value = pintLimit; cmd.Parameters.Add("@intCodeUser", System.Data.SqlDbType.Int).Value = pintUserID; conn.Open(); SqlDataReader result = cmd.ExecuteReader(); List <String> values = new List <String>(); List <String> cods = new List <String>(); List <clsSimpleInfo> bands = new List <clsSimpleInfo>(); pclsBandsBlock.Limit = false; while (result.Read()) { clsSimpleInfo tmp = new clsSimpleInfo(); tmp.Name = result["strNombre"].ToString(); tmp.Id = Convert.ToInt32(result["intCodBanda"].ToString()); DateTime dat = Convert.ToDateTime(result["dtAnoCreacion"].ToString()); tmp.DateCreation = dat.ToString("yyyy"); bands.Add(tmp); } if (cods.Count < pintLimit) { pclsBandsBlock.Limit = true; } pclsBandsBlock.Bands = bands; pclsResponse.Code = 0; pclsResponse.Message = "Done"; pclsResponse.Success = true; } catch (SqlException ex) { pclsResponse.Code = 1; pclsResponse.Success = false; pclsResponse.Message = "Error while procesing your request."; } catch (Exception ex) { pclsResponse.Code = 2; pclsResponse.Success = false; pclsResponse.Message = "Unexpected error."; } finally { conn.Close(); } return(pclsBandsBlock); }
public clsBandsBlock getBandsSearch(clsBandsBlock pclsBandsBlock, ref clsResponse pclsResponse, ref clsSearch pclsSearch, int pintOffset, int pintLimit) { try { SqlCommand cmd = new SqlCommand("myFan.SP_GetBandFilteredByName", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@intOffset", System.Data.SqlDbType.Int).Value = pintOffset; cmd.Parameters.Add("@intRows", System.Data.SqlDbType.Int).Value = pintLimit; cmd.Parameters.Add("@strPais", System.Data.SqlDbType.VarChar).Value = pclsSearch.Country; cmd.Parameters.Add("@strGeneros", System.Data.SqlDbType.VarChar).Value = pclsSearch.Genre; cmd.Parameters.Add("@strNombre", System.Data.SqlDbType.VarChar).Value = pclsSearch.Name; conn.Open(); SqlDataReader result = cmd.ExecuteReader(); List <String> values = new List <String>(); List <String> cods = new List <String>(); List <clsSimpleInfo> bands = new List <clsSimpleInfo>(); while (result.Read()) { clsSimpleInfo tmp = new clsSimpleInfo(); tmp.Name = result["NombreBanda"].ToString(); tmp.Id = Convert.ToInt32(result["UserCode"].ToString()); DateTime dat = Convert.ToDateTime(result["FechaCreacion"].ToString()); tmp.DateCreation = dat.ToString("yyyy"); bands.Add(tmp); } pclsBandsBlock.Bands = bands; pclsResponse.Code = 0; pclsResponse.Message = "Done"; pclsResponse.Success = true; } catch (SqlException ex) { pclsResponse.Code = 1; pclsResponse.Success = false; pclsResponse.Message = ex.Message; } catch (Exception ex) { pclsResponse.Code = 2; pclsResponse.Success = false; pclsResponse.Message = "Unexpected error."; } finally { conn.Close(); } return(pclsBandsBlock); }
public void getAlbums(ref clsDisksBlock pclsDisksBlock, ref clsResponse pclsResponse, int pintUserCode, int pintOffset, int pintLimit) { try { SqlCommand cmd = new SqlCommand("myFan.SP_GetDiscsByBand", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@intCodeUser", System.Data.SqlDbType.Int).Value = pintUserCode; cmd.Parameters.Add("@intCodeBand", System.Data.SqlDbType.Int).Value = 0; cmd.Parameters.Add("@intOffset", System.Data.SqlDbType.Int).Value = pintOffset; cmd.Parameters.Add("@intRows", System.Data.SqlDbType.Int).Value = pintLimit; conn.Open(); SqlDataReader result = cmd.ExecuteReader(); List <clsSimpleInfo> disks = new List <clsSimpleInfo>(); while (result.Read()) { clsSimpleInfo tmp = new clsSimpleInfo(); tmp.Name = (result["Descripcion"].ToString()); DateTime dat = Convert.ToDateTime(result["dtFechaPublicacion"].ToString()); tmp.DateCreation = dat.ToString("yyyy"); tmp.Id = Convert.ToInt32(result["DiscCode"].ToString()); disks.Add(tmp); } pclsDisksBlock.Disks = disks; pclsResponse.Code = 0; pclsResponse.Message = "Done"; pclsResponse.Success = true; } catch (SqlException ex) { pclsResponse.Code = 1; pclsResponse.Success = false; pclsResponse.Message = "Error while procesing your request."; } catch (Exception ex) { pclsResponse.Code = 2; pclsResponse.Success = false; pclsResponse.Message = "Unexpected error."; } finally { conn.Close(); } }