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