public JsonResult <Fanatic> getinfo(DbConnection dbConnection)
{
Fanatic result = new Fanatic();
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
if (dbConnection.detail_type == "2")
{
string action = "select * from userxinfo full outer join fanatic on userxinfo.fanatic_login = fanatic.fanatic_login where userxinfo_id =" + Int32.Parse(dbConnection.detail_xinfo);
myConnection.Open();
SqlCommand sqlCmd = new SqlCommand(action, myConnection);
sqlCmd.CommandType = CommandType.Text;
var reader = sqlCmd.ExecuteReader();
while (reader.Read())
{
DateTime datetmp = (DateTime)reader["fanatic_date_create"];
result.fanatic_name = (string)reader["fanatic_name"];
result.fanatic_last_name = (string)reader["fanatic_last_name"];
result.fanatic_birth = (string)reader["fanatic_birth"];
result.fanatic_date_create = datetmp.ToString("dd-mm-yyyy hh:mm");
result.fanatic_description = (string)reader["fanatic_description"];
result.fanatic_email = (string)reader["fanatic_email"];
result.fanatic_id = (string)reader["fanatic_login"];
}
myConnection.Close();
return(Json(result));
}
else
{
string action = "select * from adminxinfo full outer join admin on adminxinfo.admin_username = admin.admin_username where adminxinfo_id =" + Int16.Parse(dbConnection.detail_xinfo);
myConnection.Open();
SqlCommand sqlCmd = new SqlCommand(action, myConnection);
sqlCmd.CommandType = CommandType.Text;
var reader = sqlCmd.ExecuteReader();
while (reader.Read())
{
DateTime datetmp = (DateTime)reader["admin_date_create"];
result.fanatic_name = (string)reader["admin_name"];
result.fanatic_last_name = (string)reader["admin_last_name"];
result.fanatic_date_create = datetmp.ToString("dd-mm-yyyy hh:mm");
result.fanatic_email = (string)reader["admin_email"];
result.fanatic_login = (string)reader["admin_username"];
}
myConnection.Close();
return(Json(result));
}
}
public JsonResult <DbConnection> Register(Fanatic fanatic)
{
DbConnection constructor = new DbConnection();
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
myConnection.Open();
SqlCommand sqlCmd = new SqlCommand("insertfanatic", myConnection);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new SqlParameter("@f_login", fanatic.fanatic_id));
sqlCmd.Parameters.Add(new SqlParameter("@f_name", fanatic.fanatic_name));
sqlCmd.Parameters.Add(new SqlParameter("@f_last_name", fanatic.fanatic_last_name));
sqlCmd.Parameters.Add(new SqlParameter("@f_email", fanatic.fanatic_email));
sqlCmd.Parameters.Add(new SqlParameter("@f_phone", fanatic.fanatic_phone));
System.Diagnostics.Debug.WriteLine("FECHAAAA=" + fanatic.fanatic_password);
sqlCmd.Parameters.Add(new SqlParameter("@f_birth", fanatic.fanatic_birth));
sqlCmd.Parameters.Add(new SqlParameter("@f_password", fanatic.fanatic_password));
sqlCmd.Parameters.Add(new SqlParameter("@f_about", fanatic.fanatic_description));
sqlCmd.Parameters.Add(new SqlParameter("@f_country", fanatic.fanatic_country));
if (fanatic.fanatic_photo != null)
{
sqlCmd.Parameters.Add(new SqlParameter("@f_photo", fanatic.fanatic_photo));
var returnparam = new SqlParameter {
ParameterName = "@result", Direction = ParameterDirection.ReturnValue
};
sqlCmd.Parameters.Add(returnparam);
sqlCmd.ExecuteNonQuery();
int result = (int)returnparam.Value;
myConnection.Close();
if (result > 0)
{
constructor.success = "true";
constructor.detail_type = result.ToString();
return(Json(constructor));
}
else if (result == -3)
{
constructor.success = "false";
constructor.detail_type = "The username and password don't match";
return(Json(constructor));
}
else
{
constructor.success = "false";
constructor.detail_type = "The user doesn't exist";
return(Json(constructor));
}
}
else
{
var returnparam = new SqlParameter {
ParameterName = "@result", Direction = ParameterDirection.ReturnValue
};
sqlCmd.Parameters.Add(returnparam);
sqlCmd.ExecuteNonQuery();
int result = (int)returnparam.Value;
myConnection.Close();
if (result > 0)
{
constructor.success = "true";
constructor.detail_type = "";
return(Json(constructor));
}
else
{
constructor.success = "false";
constructor.detail_type = "User already exists";
return(Json(constructor));
}
}
}
