public static clsNew parseNew(string json)
{
clsResponse Response = parseResponse(json);
clsNew New = JsonConvert.DeserializeObject <clsNew>(Convert.ToString(Response.Data));
return(New);
}
public async Task <ActionResult> NewNoticia(string NewTitle, string inputContent)
{
System.Diagnostics.Debug.WriteLine(NewTitle);
System.Diagnostics.Debug.WriteLine(inputContent);
clsNew form = new clsNew();
form.Title = NewTitle;
form.Content = inputContent;
string response = await clsNewRequests.PostNewForm(form, Int32.Parse(Session["Id"].ToString()));
if (!ErrorParser.parse(response).Equals(""))
{
ViewBag.Message = "Couldn´t get the news correctly";
}
System.Diagnostics.Debug.WriteLine(response);
int Id = DataParser.parseNewForm(response);
System.Diagnostics.Debug.WriteLine("Got id: " + Id);
return(Json(new
{
redirectUrl = Url.Action("Index", "News", new { userId = Int32.Parse(Session["Id"].ToString()), id = Id }),
isRedirect = true
}));
}
public clsNew DeserializeNew(string pstringData)
{
clsNew New = new clsNew();
dynamic data = JObject.Parse(pstringData);
New = JsonConvert.DeserializeObject <clsNew>(Convert.ToString(data));
return(New);
}
public string getNewInfo(int pintNewId)
{
clsNew New = new clsNew();
clsResponse response = new clsResponse();
FacadeDA.getnew(ref New, ref response, pintNewId);
New.Id = pintNewId;
response.Data = serializer.Serialize(New);
return(serializer.Serialize(response));
}
public static async Task <string> PostNewForm(clsNew form, int userId)
{
Serializer serializer = new Serializer();
string RequestBody = serializer.Serialize(form);
clsRequest RequestObject = new clsRequest("-1", userId, RequestBody);
HttpResponseMessage request = await clsHttpClient.getClient().PostAsJsonAsync("users/bands/" + userId + "/news", RequestObject);
if (request.IsSuccessStatusCode)
{
string response = request.Content.ReadAsStringAsync().Result;
return(await Task.FromResult(response));
}
else
{
return(await Task.FromResult("Unexpected error ocurred"));
}
}
public int createnew(ref clsNew pclsNew, ref clsResponse pclsResponse, int pintUserCode)
{
int tmp = 0;
try
{
SqlCommand cmd = new SqlCommand("myFan.SP_IngresarNoticia", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@strTitulo", System.Data.SqlDbType.VarChar).Value = pclsNew.Title;
cmd.Parameters.Add("@strComentario", System.Data.SqlDbType.VarChar).Value = pclsNew.Content;
cmd.Parameters.Add("@intCodUsuario", System.Data.SqlDbType.Int).Value = pintUserCode;
SqlParameter id = cmd.Parameters.Add("@intCodNoticia", 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();
tmp = Convert.ToInt32(id.Value);
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 string createNew(string pstringRequest, int pintBandId)
{
clsRequest request = JsonConvert.DeserializeObject <clsRequest>(pstringRequest);
clsNew New = DeserializeJson.DeserializeNew(request.Data.ToString());
clsResponse response = new clsResponse();
if (request.Id == pintBandId)
{
New.Id = FacadeDA.createnew(ref New, ref response, pintBandId);
}
New.BandName = null;
New.Content = null;
New.Date = null;
New.Title = null;
response.Data = serializer.Serialize(New);
return(serializer.Serialize(response));
}
public void getnew(ref clsNew pclsNew, ref clsResponse pclsResponse, int pintCodeNew)
{
try
{
SqlCommand cmd = new SqlCommand("myFan.SP_GetNew", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@intCodNew", System.Data.SqlDbType.Int).Value = pintCodeNew;
conn.Open();
SqlDataReader result = cmd.ExecuteReader();
while (result.Read())
{
pclsNew.BandName = result["Banda"].ToString();
pclsNew.Content = result["Contenido"].ToString();
pclsNew.Title = result["Encabezado"].ToString();
DateTime dat = Convert.ToDateTime(result["Fecha"].ToString(), CultureInfo.InvariantCulture);
pclsNew.Date = dat.ToString("yyyy") + "-" + dat.ToString("MM") + '-' + dat.ToString("dd");
}
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 getnew(ref clsNew pclsNew, ref clsResponse pclsResponse, int pintCodeNew)
{
NewsRead.getnew(ref pclsNew, ref pclsResponse, pintCodeNew);
}
public int createnew(ref clsNew pclsNew, ref clsResponse pclsResponse, int pintUserCode)
{
return(NewsWrite.createnew(ref pclsNew, ref pclsResponse, pintUserCode));
}
