public string updateFan(string pstringRequest, int pintFanId)
{
clsRequest request = JsonConvert.DeserializeObject <clsRequest>(pstringRequest);
clsInfoFan InfoFan = DeserializeJson.DeserializeFanForm(request.Data);
InfoFan.Id = request.Id;
clsResponse response = new clsResponse();
if (InfoFan.Id == pintFanId)
{
InfoFan = FacadeDA.updateFan(InfoFan, ref response);
if (InfoFan.Picture.CompareTo("") != 0) // change image
{
ArchiveManager.updateUserImage(InfoFan.Id, InfoFan.Picture, ref response);
}
}
else
{
//error info
response.Success = false;
response.Message = "Invalid Operation";
response.Code = 401;
}
//Data = null
return(serializer.Serialize(response));
}
public string createFan(string pstringRequest)
{
clsRequest request = JsonConvert.DeserializeObject <clsRequest>(pstringRequest);
clsInfoFan InfoFan = DeserializeJson.DeserializeFanForm(request.Data);
clsResponse response = new clsResponse();
clsInfoUser InfoUser = new clsInfoUser();
InfoUser.Username = InfoFan.Username;
FacadeDA.validateUser(InfoUser, ref response);
if (!response.Success) //not existing username
{
response = new clsResponse(); //clear the response
InfoFan.Salt = clsHasher.genSalt();
InfoFan.SaltHashed = clsHasher.hashPassword(InfoFan.Password, InfoFan.Salt);
InfoFan = FacadeDA.createFan(InfoFan, ref response);
//save image
ArchiveManager.saveUserImage(InfoFan.Id, InfoFan.Picture, ref response);
InfoUser.Salt = null; // clear the object before sending
InfoUser.SaltHashed = null; // clear the object before sending
}
else
{
//error info
response.Success = false;
response.Message = "Existing Username";
response.Code = 3;
}
response.Data = serializer.Serialize(InfoFan);
return(serializer.Serialize(response));
}
public string getFanInfo(int pintFanId)
{
clsInfoFan InfoFan = new clsInfoFan();
clsResponse response = new clsResponse();
FacadeDA.getFanInfo(ref InfoFan, ref response, pintFanId);
FacadeDA.getGenresFan(ref InfoFan, ref response, pintFanId);
response.Data = serializer.Serialize(InfoFan);
return(serializer.Serialize(response));
}
public clsInfoFan updateFan(clsInfoFan pclsInfoFan, ref clsResponse pclsResponse)
{
try
{
return(FanWrite.updateFan(pclsInfoFan, ref pclsResponse));
}
catch
{
pclsResponse.Code = 007;
pclsResponse.Success = false;
pclsResponse.Message = "Internal Error";
return(pclsInfoFan);// cambiar x error
}
}
public clsInfoFan createFan(clsInfoFan pclsInfoFan, ref clsResponse pclsResponse)
{
try
{
SqlCommand cmd = new SqlCommand("myFan.SP_CrearFanatico", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@strLoginName", System.Data.SqlDbType.VarChar).Value = pclsInfoFan.Username;
cmd.Parameters.Add("@strNombre", System.Data.SqlDbType.VarChar).Value = pclsInfoFan.Name;
cmd.Parameters.Add("@strGeneros", System.Data.SqlDbType.VarChar).Value = String.Join(",", pclsInfoFan.Genres);
cmd.Parameters.Add("@dtFechaNacimiento", System.Data.SqlDbType.Date).Value = pclsInfoFan.Birthday;
cmd.Parameters.Add("@intPais", System.Data.SqlDbType.Int).Value = pclsInfoFan.Country;
cmd.Parameters.Add("@intSexo", System.Data.SqlDbType.Int).Value = pclsInfoFan.Gender;
cmd.Parameters.Add("@strSalt", System.Data.SqlDbType.VarChar).Value = pclsInfoFan.Salt;
cmd.Parameters.Add("@strSaltHashedPassword", System.Data.SqlDbType.VarChar).Value = pclsInfoFan.SaltHashed;
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;
SqlParameter id = cmd.Parameters.Add("@intCodeUserReturn", SqlDbType.Int);
id.Direction = ParameterDirection.Output;
conn.Open();
SqlDataReader result = cmd.ExecuteReader();
Console.WriteLine("entre");
pclsInfoFan.Id = Convert.ToInt32(id.Value);
pclsResponse.Code = Convert.ToInt32(cod.Value.ToString());
pclsResponse.Message = message.Value.ToString();
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(pclsInfoFan);
}
public clsInfoFan DeserializeFanForm(string pstringData)
{
clsInfoFan InfoFan = new clsInfoFan();
dynamic data = JObject.Parse(pstringData);
InfoFan.Active = true;
InfoFan.Birthday = Convert.ToString(data.Birthday);
InfoFan.Country = Convert.ToString(data.Country);
InfoFan.Gender = Convert.ToString(data.Gender);
InfoFan.Genres = JsonConvert.DeserializeObject <List <string> >(Convert.ToString(data.Genres));
InfoFan.Name = Convert.ToString(data.Name);
InfoFan.Password = Convert.ToString(data.Password);
InfoFan.Username = Convert.ToString(data.Username);
InfoFan.Picture = Convert.ToString(data.Picture);
return(InfoFan);
}
public void getFanInfo(ref clsInfoFan pclsInfoFan, ref clsResponse pclsResponse, int pintUserID)
{
try
{
SqlCommand cmd = new SqlCommand("myFan.SP_GetFanaticProfile", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@intCodeUser", System.Data.SqlDbType.Int).Value = pintUserID;
conn.Open();
SqlDataReader result = cmd.ExecuteReader();
while (result.Read())
{
pclsInfoFan.Username = result["LoginName"].ToString();
pclsInfoFan.Name = result["NombreFanatico"].ToString();
pclsInfoFan.Country = result["Pais"].ToString();
pclsInfoFan.Gender = result["Sexo"].ToString();
DateTime dat = Convert.ToDateTime(result["Fecha"].ToString(), CultureInfo.InvariantCulture);
pclsInfoFan.Birthday = 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 clsInfoFan updateFan(clsInfoFan pclsInfoFan, ref clsResponse pclsResponse)
{
try
{
SqlCommand cmd = new SqlCommand("myFan.SP_ActualizarFanatico", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@intCodUser", System.Data.SqlDbType.Int).Value = pclsInfoFan.Id;
cmd.Parameters.Add("@strNombre", System.Data.SqlDbType.VarChar).Value = pclsInfoFan.Name;
cmd.Parameters.Add("@strGeneros", System.Data.SqlDbType.VarChar).Value = String.Join(",", pclsInfoFan.Genres);
cmd.Parameters.Add("@dtFechaNacimiento", System.Data.SqlDbType.Date).Value = pclsInfoFan.Birthday;
cmd.Parameters.Add("@intPais", System.Data.SqlDbType.Int).Value = pclsInfoFan.Country;
cmd.Parameters.Add("@intSexo", System.Data.SqlDbType.Int).Value = pclsInfoFan.Gender;
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();
}
return(pclsInfoFan);
}
public static void Main()
{
clsFanWrite a = new clsFanWrite();
clsInfoFan b = new clsInfoFan();
Serializer c = new Serializer();
b.Id = 121;
b.Username = "******";
b.Password = "******";
b.Name = "pan121";
b.Genres = new List <string>(new string[] { "1", "3", "4" });
b.Birthday = "1-2-2016";
b.Country = "7";
b.Gender = "1";
clsFanWrite d = new clsFanWrite();
clsResponse f = new clsResponse();
d.updateFan(b, ref f);
Console.WriteLine(c.Serialize(b));
Console.WriteLine(f.Message);
Console.ReadKey();
}
public void getGenresFan(ref clsInfoFan pclsInfoFan, ref clsResponse pclsResponse, int pintUserCode)
{
try
{
SqlCommand cmd = new SqlCommand("myFan.SP_GetGenresByUser", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@intUserCode", System.Data.SqlDbType.Int).Value = pintUserCode;
conn.Open();
SqlDataReader result = cmd.ExecuteReader();
List <String> tmpGenres = new List <string>();
List <int> tmpCodGenres = new List <int>();
while (result.Read())
{
tmpGenres.Add(result["DescripcionGenero"].ToString());
tmpCodGenres.Add(Convert.ToInt32(result["CodigoGenero"].ToString()));
}
pclsInfoFan.Genres = tmpGenres;
pclsInfoFan.CodGenres = tmpCodGenres;
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 getGenresFan(ref clsInfoFan pclsInfoFan, ref clsResponse pclsResponse, int pintUserCode)
{
FanRead.getGenresFan(ref pclsInfoFan, ref pclsResponse, pintUserCode);
}
public void getFanInfo(ref clsInfoFan pclsInfoFan, ref clsResponse pclsResponse, int pintUserID)
{
FanRead.getFanInfo(ref pclsInfoFan, ref pclsResponse, pintUserID);
}
public clsInfoFan updateFan(clsInfoFan pclsInfoFan, ref clsResponse pclsResponse)
{
return(FanDA.updateFan(pclsInfoFan, ref pclsResponse));
}
