public string getDisks(int pintBandId, int pintOffset, int pintLimit)
{
clsResponse response = new clsResponse();
clsDisksBlock DisksBlock = new clsDisksBlock();
FacadeDA.getAlbums(ref DisksBlock, ref response, pintBandId, pintOffset, pintLimit);
response.Data = serializer.Serialize(DisksBlock);
return(serializer.Serialize(response));
}
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();
}
}
public void getAlbums(ref clsDisksBlock pclsDisksBlock, ref clsResponse pclsResponse, int pintUserCode, int pintOffset, int pintLimit)
{
BandRead.getAlbums(ref pclsDisksBlock, ref pclsResponse, pintUserCode, pintOffset, pintLimit);
}
