public string createDisk(string pstringRequest, int pintBandId)
{
clsRequest request = JsonConvert.DeserializeObject <clsRequest>(pstringRequest);
clsDisk Disk = DeserializeJson.DeserializeDisk(request.Data.ToString());
Disk.Id = request.Id;
clsResponse response = new clsResponse();
if (Disk.Id == pintBandId)
{
Disk.Id = FacadeDA.createdisk(ref Disk, ref response, pintBandId);
//save image here!
ArchiveManager.saveDiskImage(Disk.Id, Disk.Picture, ref response);
}
else
{
//error info
response.Success = false;
response.Message = "Invalid Operation";
response.Code = 401;
}
Disk.Picture = null;
Disk.Songs = null;
Disk.Label = null;
Disk.DateCreation = null;
Disk.Name = null;
Disk.CodGenre = -1;
response.Data = serializer.Serialize(Disk);
return(serializer.Serialize(response));
}
public static clsDisk parseDisk(string json)
{
clsResponse Response = parseResponse(json);
clsDisk disk = JsonConvert.DeserializeObject <clsDisk>(Convert.ToString(Response.Data));
return(disk);
}
public clsDisk DeserializeDisk(string pstringData)
{
clsDisk Disk = new clsDisk();
dynamic data = JObject.Parse(pstringData);
Disk.Name = Convert.ToString(data.Name);
Disk.DateCreation = Convert.ToString(data.DateCreation);
Disk.CodGenre = Convert.ToInt32(data.Genre);
Disk.Picture = Convert.ToString(data.Picture);
Disk.Label = Convert.ToString(data.Label);
return(Disk);
}
public string getDiskInfo(int pintDiskId)
{
clsDisk Disk = new clsDisk();
clsResponse response = new clsResponse();
Disk.Id = pintDiskId;
FacadeDA.getdiskinfo(ref Disk, ref response, pintDiskId);
FacadeDA.getsongs(ref Disk, ref response, pintDiskId);
response.Data = serializer.Serialize(Disk);
return(serializer.Serialize(response));
}
public void getsongs(ref clsDisk pclsDisk, ref clsResponse pclsResponse, int pintDiskCode)
{
try
{
SqlCommand cmd = new SqlCommand("myFan.SP_GetSongsByDisc", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@intCodeDisc", System.Data.SqlDbType.Int).Value = pintDiskCode;
conn.Open();
SqlDataReader result = cmd.ExecuteReader();
List <clsSong> songs = new List <clsSong>();
while (result.Read())
{
clsSong tmp = new clsSong();
tmp.Name = (result["Nombre"].ToString());
tmp.Link = (result["Video"].ToString());
DateTime dat = Convert.ToDateTime(result["Duracion"].ToString());
tmp.Duration = dat.ToString("hh:mm tt");
tmp.Type = Convert.ToBoolean(result["EnVivo"].ToString());
tmp.LimitedEdition = Convert.ToBoolean(result["EdicionLimitada"].ToString());
songs.Add(tmp);
}
pclsDisk.Songs = songs;
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 int createdisk(ref clsDisk pclsDisk, ref clsResponse pclsResponse, int pintUserCode)
{
int tmp = new int();
try
{
SqlCommand cmd = new SqlCommand("myFan.SP_InsertarDisco", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@intGenero", System.Data.SqlDbType.Int).Value = pclsDisk.CodGenre;
cmd.Parameters.Add("@strNombre", System.Data.SqlDbType.VarChar).Value = pclsDisk.Name;
cmd.Parameters.Add("@dtFechaPublicacion", System.Data.SqlDbType.VarChar).Value = pclsDisk.DateCreation;
cmd.Parameters.Add("@strSelloDiscografico", System.Data.SqlDbType.VarChar).Value = pclsDisk.Label;
cmd.Parameters.Add("@intUser", System.Data.SqlDbType.Int).Value = pintUserCode;
SqlParameter id = cmd.Parameters.Add("@intIdDisco", SqlDbType.Int);
id.Direction = ParameterDirection.Output;
SqlParameter message = cmd.Parameters.Add("@strMessageError", SqlDbType.VarChar, 256);
message.Direction = ParameterDirection.Output;
SqlParameter cod = cmd.Parameters.Add("@strCodError", SqlDbType.VarChar, 4);
cod.Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
Console.Write("entre");
tmp = Convert.ToInt32(id.Value.ToString());
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(tmp);
}
public void getdiskinfo(ref clsDisk pclsDisk, ref clsResponse pclsResponse, int pintDiskCode)
{
try
{
SqlCommand cmd = new SqlCommand("myFan.SP_GetInfoDisc", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@intDisc", System.Data.SqlDbType.Int).Value = pintDiskCode;
conn.Open();
SqlDataReader result = cmd.ExecuteReader();
while (result.Read())
{
pclsDisk.Name = (result["Nombre"].ToString());
DateTime dat = Convert.ToDateTime(result["Fecha"].ToString());
pclsDisk.DateCreation = dat.ToString("yyyy");
pclsDisk.Genre = (result["Genero"].ToString());
pclsDisk.Label = (result["SelloDiscografico"].ToString());
}
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 int createdisk(ref clsDisk pclsDisk, ref clsResponse pclsResponse, int pintUserCode)
{
return(DiskWrite.createdisk(ref pclsDisk, ref pclsResponse, pintUserCode));
}
public void getdiskinfo(ref clsDisk pclsDisk, ref clsResponse pclsResponse, int pintDiskCode)
{
DiskRead.getdiskinfo(ref pclsDisk, ref pclsResponse, pintDiskCode);
}
public void getsongs(ref clsDisk pclsDisk, ref clsResponse pclsResponse, int pintDiskCode)
{
DiskDA.getsongs(ref pclsDisk, ref pclsResponse, pintDiskCode);
}
