public void GetGamesListByPlatform_Test()
{
GenreBusiness.Fill();
var games = APIFunctions.GetGamesListByPlatform("6", "", "");
Assert.IsNotNull(games);
}
public object GetUserDiet(int userid, string day)
{
Dia dia = (Dia)Enum.Parse(typeof(Dia), day);
var diet = MyGymContext.DB.Dieta.FirstOrDefault(item => item.UsuarioID == userid & item.Dia == dia);
if (diet == null)
{
return(APIFunctions.ErrorResult(string.Format(JsonMessage.NotFound, "Dieta")));
}
var recomendations = MyGymContext.DB.Tiene.Where(item => item.DietaID == diet.DietaID);
if (recomendations.Count() > 0)
{
return(APIFunctions.SuccessResult(
recomendations.Select(item => new UserDiet()
{
DietID = diet.DietaID,
ImageURL = string.Format("http://localhost:8000/images/{0}.jpg", item.RecomendacionID),
MealTime = new List <TiempoComida>(item.Recomendacion.SeRecomiendaEn.Select(tc => tc.TiempoDeComida.Nombre)),
Name = item.Recomendacion.Nombre,
RecomendationID = item.RecomendacionID
}), JsonMessage.Success));
}
return(APIFunctions.ErrorResult(JsonMessage.Error));
}
public object GenerateDiet(int userid, UserInformation userdata)
{
DateTime lastupdate = GetLastUpdate(userid);
if (DateTime.Now.Month > lastupdate.Month)
{
var user = MyGymContext.DB.Usuario.Find(userid);
DateTime olddateofbirth = user.FechaNacimiento;
double oldweigth = user.Peso;
double oldheight = user.Estatura;
if (userdata.DateOfBirth != null)
{
user.FechaNacimiento = userdata.DateOfBirth;
}
if (userdata.Weight != default(double))
{
user.Peso = userdata.Weight;
}
if (userdata.Height != default(double))
{
user.Estatura = userdata.Height;
}
MyGymContext.DB.SaveChanges();
if (user.FechaNacimiento != olddateofbirth | user.Peso != oldweigth | user.Estatura != oldheight)
{
new DietRepository().CreateDiet(user.UsuarioID);
}
return(APIFunctions.SuccessResult(new object(), JsonMessage.Success));
}
return(APIFunctions.ErrorResult(JsonMessage.CannotChangeProperty));
}
public ActionResult SqlScriptXml(string id, string p1 = null)
{
var f = new APIFunctions(DbUtil.Db);
var e = $"<SqlScriptXml id={id}><Error>{{0}}</Error></SqlScriptXml>";
return(Content(SqlScript(id, p1, f.SqlScriptXml, e), "application/xml"));
}
public ActionResult SqlScriptJson(string id, string p1 = null)
{
var f = new APIFunctions(DbUtil.Db);
var e = $@"{{ ""id"": ""{id}"", ""Error"": ""{{0}}"" }}";
return(Content(SqlScript(id, p1, f.SqlScriptJson, e), "application/json"));
}
public ActionResult Index(int userid)
{
var result = (new UserRepository()).Get(userid);
var usuario = APIFunctions.GetData <UserInformation>(JsonConvert.SerializeObject(result));
return(View(APIFunctions.UserToUsuario(usuario)));
}
/// #####################################################################
/// <summary>
/// 设置软件和左侧导航栏皮肤
/// coder:likai(2010-06-08)
/// </summary>
public static string SetSkinStyle()
{
StringBuilder sSkin = new StringBuilder(100);
string sFilePath = Application.StartupPath + "\\Config\\DefaultLoadConfig.ini";
const string sSetion = "Skin";
const string sKey = "Skin";
const string missValue = "Whiteprint";
APIFunctions.GetPrivateProfileString(sSetion, sKey, missValue, sSkin, 100,
sFilePath);
if (sSkin.ToString() == string.Empty)
{
sSkin.Append(missValue);
}
switch (sSkin.ToString())
{
case "DevExpress Style":
return("DevExpress Style");
case "DevExpress Dark Style":
return("DevExpress Dark Style");
case "Seven Classic":
return("Seven Classic");
case "Office 2010 Black":
return("Office 2010 Black");
case "Office 2010 Blue":
return("Office 2010 Blue");
case "Office 2010 Silver":
return("Office 2010 Silver");
case "Office 2013":
return("Office 2013");
case "VS2010":
return("VS2010");
case "Seven":
return("Seven");
case "Darkroom":
return("Darkroom");
case "Metropolis Dark":
return("Metropolis Dark");
case "Foggy":
return("Foggy");
case "Sharp":
return("Sharp");
case "Whiteprint":
return("Whiteprint");
}
return(string.Empty);
}
public ActionResult Edit(int userid)
{
var result = new UserRepository().Get(userid);
var user = APIFunctions.GetData <UserInformation>(JsonConvert.SerializeObject(result));
return(View(user));
}
public void GetGameByName_Test()
{
GenreBusiness.Fill();
var access = "";
var games = APIFunctions.GetGameByName("136", "Super Mario World", out access);
Assert.IsNotNull(games);
}
public void GetGameDetails_Test()
{
GenreBusiness.Fill();
var access = "";
var games = APIFunctions.GetGameDetails("136", new Platform(), out access);
Assert.IsNotNull(games);
}
public object Get(int userid)
{
Usuario user = MyGymContext.DB.Usuario.Find(userid);
if (user == null)
{
return(APIFunctions.ErrorResult(string.Format(JsonMessage.NotFound, "Usuario")));
}
return(APIFunctions.SuccessResult(APIFunctions.UsuarioToUser(user), JsonMessage.Success));
}
public object LogIn(string user, string password)
{
var result = MyGymContext.DB.Usuario.FirstOrDefault(item => (item.Email == user | item.Nick == user) & item.Password == password);
if (result == null)
{
return(APIFunctions.ErrorResult(JsonMessage.ErrorLogin));
}
return(APIFunctions.SuccessResult(APIFunctions.UsuarioToUser(result), JsonMessage.Success));
}
public ActionResult LogIn(string user, string password)
{
var result = (new UserRepository()).LogIn(user, password);
var usuario = APIFunctions.GetData <UserInformation>(JsonConvert.SerializeObject(result));
if (usuario == null)
{
return(RedirectToAction("Index", "Home"));
}
return(RedirectToAction("Index", new { userid = usuario.UserID }));
}
public object Get()
{
try
{
return(APIFunctions.SuccessResult(CuerosContext.DB.Materials.ToList(), JsonMessage.Success));
}
catch (Exception e)
{
return(APIFunctions.ErrorResult(e.Message));
}
}
public object GetByCategoryID(int categoryID)
{
try
{
return(APIFunctions.SuccessResult(CuerosContext.DB.Categories.Find(categoryID), JsonMessage.Success));
}
catch (Exception e)
{
return(APIFunctions.ErrorResult(e.Message));
}
}
public JsonResult LogIn(string logindata)
{
JObject login = (JObject)JsonConvert.DeserializeObject(logindata);
if (login["user"] != null & login["password"] != null)
{
var result = (new UserRepository()).LogIn(login["user"].ToString(), login["password"].ToString());
return(Json(result, JsonRequestBehavior.AllowGet));
}
return(Json(APIFunctions.ErrorResult(JsonMessage.BadRequest), JsonRequestBehavior.AllowGet));
}
public object Get()
{
try
{
return(APIFunctions.SuccessResult(CuerosContext.DB.Products.ToList(), "JDKLASJDKLJDKLSKLS!"));
}
catch (Exception e)
{
return(APIFunctions.ErrorResult(e.Message));
}
}
public ActionResult Test(string script, Dictionary <string, string> args)
{
if (args == null)
{
args = new Dictionary <string, string>();
}
args.Add("uname", (string)Session["APIuname"]);
args.Add("pword", (string)Session["APIpword"]);
var init = (string)Session["APIinit"];
return(Content(APIFunctions.TestAPI(init, script, args)));
}
public void GetGameArtUrls_Test()
{
GenreBusiness.Fill();
string box, title, gameplay = "";
var access = "";
var result = APIFunctions.GetGameArtUrls("136", out box, out title, out gameplay, out access);
Assert.IsTrue(result);
Assert.IsNotNull(box);
Assert.IsNotNull(title);
Assert.IsNotNull(gameplay);
}
public object GetByProductID(int productID)
{
try
{
var result = from x in CuerosContext.DB.Orders.ToList() where x.ProductID == productID select x;
return(APIFunctions.SuccessResult(result.ToList(), JsonMessage.Success));
}
catch (Exception e)
{
return(APIFunctions.ErrorResult(e.Message));
}
}
public object Get()
{
try
{
var result = CuerosContext.DB.Orders.ToList();
return(APIFunctions.SuccessResult(result, JsonMessage.Success));
}
catch (Exception e)
{
return(APIFunctions.ErrorResult(e.Message));
}
}
public ActionResult Register(string userdata)
{
var user = JsonConvert.DeserializeObject <UserInformation>(userdata);
var result = (new UserRepository()).Add(user);
var usuarioID = APIFunctions.GetData <int>(JsonConvert.SerializeObject(result));
string redirecturl = new UrlHelper(Request.RequestContext).Action("Index", new { userid = usuarioID });
if (usuarioID == default(int))
{
redirecturl = new UrlHelper(Request.RequestContext).Action("Register");
}
return(Json(new { Url = redirecturl }));
}
public object GetByProductID(int productID)
{
try
{
return(APIFunctions.SuccessResult(
from x in CuerosContext.DB.Compose.ToList()
where x.ProductID == productID
select x.Material, JsonMessage.Success));
}
catch (Exception e)
{
return(APIFunctions.ErrorResult(e.Message));
}
}
private void buttonOpenDB_Click(object sender, EventArgs e)
{
if (textBoxId.Text == string.Empty)
{
FormCustomMessage.ShowError("TheGameDB Id is empty.");
return;
}
var access = "";
var game = APIFunctions.GetGameDetails(textBoxId.Text, SelectedRom.Platform, out access);
game.Id = textBoxId.Text;
StringBuilder text = new StringBuilder("");
text.Append("ID" + Environment.NewLine);
text.Append(game.Id + Environment.NewLine + Environment.NewLine);
text.Append("NAME" + Environment.NewLine);
text.Append(game.DBName + Environment.NewLine + Environment.NewLine);
text.Append("PLATFORM" + Environment.NewLine);
text.Append(game.Platform.Id + " - " + game.Platform.Name + Environment.NewLine + Environment.NewLine);
text.Append("PUBLISHER" + Environment.NewLine);
text.Append(game.Publisher + Environment.NewLine + Environment.NewLine);
text.Append("DEVELOPER" + Environment.NewLine);
text.Append(game.Developer + Environment.NewLine + Environment.NewLine);
text.Append("DESCRIPTION" + Environment.NewLine);
text.Append(game.Description + Environment.NewLine + Environment.NewLine);
text.Append("YEAR RELEASED" + Environment.NewLine);
text.Append(game.YearReleased + Environment.NewLine + Environment.NewLine);
text.Append("GENRE" + Environment.NewLine);
text.Append(game.Genre != null ? game.Genre.Name + Environment.NewLine + Environment.NewLine : "" + Environment.NewLine + Environment.NewLine);
text.Append("RATING" + Environment.NewLine);
text.Append(game.Rating != 0 ? game.Rating.ToString("#.#") : "" + Environment.NewLine + Environment.NewLine);
text.Append("remaining access to api" + Environment.NewLine);
text.Append(access);
FormInfo info = new FormInfo(text.ToString());
info.Show();
}
public object GetUserRecord(int userid, string filter, int weekscount)
{
IEnumerable <UserRecord> datas = default(IEnumerable <UserRecord>);
if (filter.Equals("month"))
{
datas = MyGymContext.DB.Historial.Where(
item => item.UsuarioID == userid).Select(e =>
new UserRecord()
{
Weight = e.Peso,
Heigth = e.Estatura,
Date = e.Fecha,
NutritionalStatus = e.EstadoNutricional
});
}
else if (filter.Equals("week"))
{
var query = MyGymContext.DB.Historial.Where(
item => item.UsuarioID == userid).
OrderBy(item => item.Fecha);
if (query.Count() > weekscount)
{
datas = query.Take(weekscount).
Select(e => new UserRecord()
{
Weight = e.Peso,
Heigth = e.Estatura,
Date = e.Fecha,
NutritionalStatus = e.EstadoNutricional
});
}
else
{
datas = query.Select(e => new UserRecord()
{
Weight = e.Peso,
Heigth = e.Estatura,
Date = e.Fecha,
NutritionalStatus = e.EstadoNutricional
});
}
}
if (datas.Count() > 0)
{
return(APIFunctions.SuccessResult(datas, JsonMessage.Success));
}
return(APIFunctions.ErrorResult(string.Format(JsonMessage.NotFound, "Reportes")));
}
public ActionResult Update(int userid, string userdata)
{
var user = JsonConvert.DeserializeObject <UserInformation>(userdata);
user.UserID = userid;
var result = new UserRepository().Update(user);
var data = APIFunctions.GetData <int>(JsonConvert.SerializeObject(result));
string redirecturl = new UrlHelper(Request.RequestContext).Action("Index", new { userid = data });
if (data == default(int))
{
redirecturl = new UrlHelper(Request.RequestContext).Action("Edit", new { userid = userid });
}
return(Json(new { Url = redirecturl }));
}
public object Get(int supplierID)
{
try
{
var supplier = CuerosContext.DB.Suppliers.Find(supplierID);
if (supplier == null)
{
return(APIFunctions.ErrorResult(string.Format(JsonMessage.NotFound, "proveedor")));
}
return(APIFunctions.SuccessResult(supplier, JsonMessage.Success));
}
catch (Exception e)
{
return(APIFunctions.ErrorResult(e.Message));
}
}
public object Get(int productID)
{
try
{
var product = CuerosContext.DB.Products.Find(productID);
if (product == null)
{
return(APIFunctions.ErrorResult(string.Format(JsonMessage.NotFound, "producto")));
}
return(APIFunctions.SuccessResult(product, JsonMessage.Success));
}
catch (Exception e)
{
return(APIFunctions.ErrorResult(e.Message));
}
}
public ActionResult LoginInfo(int?id)
{
var ret = AuthenticateDeveloper();
if (ret.StartsWith("!"))
{
return(Content("<LoginInfo error=\"{0}\" />".Fmt(ret.Substring(1))));
}
if (!id.HasValue)
{
return(Content("<LoginInfo error=\"Missing id\" />"));
}
var p = DbUtil.Db.People.Single(pp => pp.PeopleId == id);
var api = new APIFunctions(DbUtil.Db);
return(Content(api.Login(p), "text/xml"));
}
public object Add(Order order)
{
try
{
if (!ValidateOrder(order))
{
//error x el numero de prendas
return(APIFunctions.ErrorResult("Cantidad disponible excedida o error en datos de envio"));
}
var newOrder = CuerosContext.DB.Orders.Add(order);
return(APIFunctions.SuccessResult(newOrder.OrderID, JsonMessage.Success));
}
catch (Exception e)
{
return(APIFunctions.ErrorResult(e.Message));
}
}
