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