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();
}
}
