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 string getBands(int pintUserId, int pintOffset, int pintLimit)
{
clsResponse response = new clsResponse();
clsBandsBlock BandsBlock = new clsBandsBlock();
BandsBlock = FacadeDA.getBands(BandsBlock, ref response, pintUserId, pintOffset, pintLimit);
response.Data = serializer.Serialize(BandsBlock);
return(serializer.Serialize(response));
}
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 string searchBands(string pstringRequest, int pintOffset, int pintLimit)
{
clsRequest request = JsonConvert.DeserializeObject <clsRequest>(pstringRequest);
clsSearch search = DeserializeJson.DeserializeSearch(request.Data);
clsResponse response = new clsResponse();
clsBandsBlock BandsBlock = new clsBandsBlock();
BandsBlock = FacadeDA.getBandsSearch(BandsBlock, ref response, ref search, pintOffset, pintLimit);
response.Data = serializer.Serialize(BandsBlock);
return(serializer.Serialize(response));
}
public static void Main()
{
clsFanRead a = new clsFanRead();
Serializer b = new Serializer();
clsBandsBlock h = new clsBandsBlock();
clsResponse d = new clsResponse();
//c.FanCod = 98;
//c.Chunks = 10;
//c.Offset = 10;
clsSearch k = new clsSearch();
k.Name = "";
List <Int32> l = new List <int>();
l.Add(0);
k.Genre = "Pop";
k.Country = "";
Console.WriteLine(b.Serialize(a.getBandsSearch(h, ref d, ref k, 0, 5)));
Console.WriteLine(d.Message);
Console.ReadKey();
}
public clsBandsBlock getBandsSearch(clsBandsBlock pclsBandsBlock, ref clsResponse pclsResponse, ref clsSearch pclsSearch, int pintOffset, int pintLimit)
{
return(FanRead.getBandsSearch(pclsBandsBlock, ref pclsResponse, ref pclsSearch, pintOffset, pintLimit));
}
public clsBandsBlock getBands(clsBandsBlock pclsBandsBlock, ref clsResponse pclsResponse, int pintUserID, int pintOffset, int pintLimit)
{
return(FanRead.getBands(pclsBandsBlock, ref pclsResponse, pintUserID, pintOffset, pintLimit));
}
