public async Task <ActionResult> NewSong(int albumId, string Name, string Duration, bool Live, bool LimitedEdition, string UrlVideo)
{
/* System.Diagnostics.Debug.WriteLine(albumId);
* System.Diagnostics.Debug.WriteLine(Name);
* System.Diagnostics.Debug.WriteLine(Live);
* System.Diagnostics.Debug.WriteLine(Duration);
* System.Diagnostics.Debug.WriteLine(LimitedEdition);
* System.Diagnostics.Debug.WriteLine(UrlVideo);*/
clsSong form = new clsSong();
form.Duration = Duration;
form.Link = UrlVideo;
form.Name = Name;
form.LimitedEdition = LimitedEdition;
form.Type = Live;
string response = await clsAlbumRequests.PostSongForm(form, Int32.Parse(Session["Id"].ToString()), albumId);
if (!ErrorParser.parse(response).Equals(""))
{
ViewBag.Message = "F**k my life...";
}
return(Json(form));
}
public clsSong DeserializeSong(string pstringData)
{
clsSong Song = new clsSong();
dynamic data = JObject.Parse(pstringData);
Song = JsonConvert.DeserializeObject <clsSong>(Convert.ToString(data));
return(Song);
}
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 static async Task <string> PostSongForm(clsSong form, int userId, int albumId)
{
Serializer serializer = new Serializer();
string RequestBody = serializer.Serialize(form);
clsRequest RequestObject = new clsRequest("-1", userId, RequestBody);
System.Diagnostics.Debug.WriteLine(RequestBody);
HttpResponseMessage request = await clsHttpClient.getClient().PostAsJsonAsync("users/bands/" + userId + "/albums/" + albumId + "/songs", RequestObject);
if (request.IsSuccessStatusCode)
{
string response = request.Content.ReadAsStringAsync().Result;
return(await Task.FromResult(response));
}
else
{
return(await Task.FromResult("Unexpected error ocurred"));
}
}
public string createSong(string pstringRequest, int pintBandId, int pintDiskId)
{
clsRequest request = JsonConvert.DeserializeObject <clsRequest>(pstringRequest);
clsSong Song = DeserializeJson.DeserializeSong(request.Data.ToString());
clsResponse response = new clsResponse();
if (request.Id == pintBandId)
{
FacadeDA.createsong(ref Song, ref response, pintDiskId);
}
else
{
//error info
response.Success = false;
response.Message = "Invalid Operation";
response.Code = 401;
}
return(serializer.Serialize(response));
}
public void createsong(ref clsSong pclsSong, ref clsResponse pclsResponse, int pintCodDisc)
{
try
{
SqlCommand cmd = new SqlCommand("myFan.SP_InsertSong", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@intCodDisc", System.Data.SqlDbType.Int).Value = pintCodDisc;
cmd.Parameters.Add("@tmDuration", System.Data.SqlDbType.Time).Value = pclsSong.Duration;
cmd.Parameters.Add("@btLive", System.Data.SqlDbType.Bit).Value = pclsSong.Type;
cmd.Parameters.Add("@btEdicionLimitada", System.Data.SqlDbType.Bit).Value = pclsSong.LimitedEdition;
cmd.Parameters.Add("@strNombre", System.Data.SqlDbType.VarChar).Value = pclsSong.Name;
cmd.Parameters.Add("@strVideoURL", System.Data.SqlDbType.VarChar).Value = pclsSong.Link;
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();
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 createsong(ref clsSong pclsSong, ref clsResponse pclsResponse, int pintCodDisc)
{
DiskWrite.createsong(ref pclsSong, ref pclsResponse, pintCodDisc);
}
