public ActionResult Index()
{
NutriAppsEntities db = new NutriAppsEntities();
List <Appointment> lstAppointments = db.Appointments.ToList();
return(View(lstAppointments));
}
public ActionResult Index()
{
NutriAppsEntities db = new NutriAppsEntities();
List <Diet> lstDiets = db.Diets.ToList();
return(View(lstDiets));
}
public ActionResult Buscar(int GroupId)
{
NutriAppsEntities db = new NutriAppsEntities();
List <Group> lstGroups = db.Groups.SqlQuery("SELECT Topic,UserID,GroupID,Description,Group_Type FROM dbo.Groups WHERE GroupID = '" + GroupId + "'").ToList();
ViewBag.Measures = db.Measures.SqlQuery("SELECT UserID,GroupID,Date,Weight,IMC,Fat_Percentage,Muscle_Percentage,Methabolic_Age,Viceral_Fat,Water_Percentage FROM dbo.Measures WHERE GroupID = '" + GroupId + "'").ToList();
return(View("Index", lstGroups));
}
public ActionResult Index()
{
NutriAppsEntities db = new NutriAppsEntities();
List <Group> lstGroups = db.Groups.ToList();
ViewBag.Measures = db.Measures.ToList();
return(View(lstGroups));
}
public ActionResult Index()
{
NutriAppsEntities db = new NutriAppsEntities();
List <User> lstUsers = db.Users.ToList();
ViewBag.Measures = db.Measures.ToList();
return(View(lstUsers));
}
public ActionResult Eliminar(int GroupId)
{
NutriAppsEntities db = new NutriAppsEntities();
string sql = "DELETE FROM dbo.Groups WHERE(GroupID = '" + GroupId + "')";
int result = db.Database.ExecuteSqlCommand(sql);
List <Group> lstGroups = db.Groups.ToList();
ViewBag.Measures = db.Measures.ToList();
return(View("Index", lstGroups));
}
public ActionResult Agregar(int GroupId, string Topic, string UserId, string Description, int GroupType)
{
NutriAppsEntities db = new NutriAppsEntities();
string sql = "INSERT INTO dbo.Groups(Topic,UserID,GroupID,Description,Group_Type) VALUES(@Topic,@UserId,@GroupId,@Description,@GroupType)";
List <SqlParameter> parameterList = new List <SqlParameter>();
parameterList.Add(new SqlParameter("@Topic", Topic));
parameterList.Add(new SqlParameter("@UserId", UserId));
parameterList.Add(new SqlParameter("@GroupId", GroupId));
parameterList.Add(new SqlParameter("@Description", Description));
parameterList.Add(new SqlParameter("@GroupType", GroupType));
SqlParameter[] parameters = parameterList.ToArray();
int result = db.Database.ExecuteSqlCommand(sql, parameters);
//db.Groups.SqlQuery("INSERT INTO dbo.Groups(Topic,UserID,GroupID,Description,Group_Type) VALUES('" + Topic + "','" + UserId + "','" + GroupId + "','" + Description + "','" + GroupType + "')");
List <Group> lstGroups = db.Groups.ToList();
ViewBag.Measures = db.Measures.ToList();
return(View("Index", lstGroups));
}
public ActionResult Chart(string Peso, string IMC, string Grasa, string Musculo, string Edad, string GrasaV, string Agua)
{
NutriAppsEntities db = new NutriAppsEntities();
ViewBag.Measures = db.Measures.ToList();
if (Peso != null)
{
ViewBag.Measures = db.Measures.SqlQuery("SELECT Date, Weight FROM dbo.Measures").ToList();
}
if (IMC != null)
{
ViewBag.Measures = db.Measures.SqlQuery("SELECT Date, IMC FROM dbo.Measures").ToList();
}
if (Grasa != null)
{
ViewBag.Measures = db.Measures.SqlQuery("SELECT Date, Fat_Percentage FROM dbo.Measures").ToList();
}
if (Musculo != null)
{
ViewBag.Measures = db.Measures.SqlQuery("SELECT Date, Muscle_Percentage FROM dbo.Measures").ToList();
}
if (Edad != null)
{
ViewBag.Measures = db.Measures.SqlQuery("SELECT Date, Methabolic_Age FROM dbo.Measures").ToList();
}
if (GrasaV != null)
{
ViewBag.Measures = db.Measures.SqlQuery("SELECT Date, Viceral_Fat FROM dbo.Measures").ToList();
}
if (Agua != null)
{
ViewBag.Measures = db.Measures.SqlQuery("SELECT Date, Water_Percentage FROM dbo.Measures").ToList();
}
return(View("Index"));
}
public ActionResult File(HttpPostedFileBase file)
{
DataSet ds = new DataSet();
if (Request.Files["file"].ContentLength > 0)
{
string fileExtension =
System.IO.Path.GetExtension(Request.Files["file"].FileName);
if (fileExtension == ".xls" || fileExtension == ".xlsx")
{
string fileLocation = Server.MapPath("~/Content/") + Request.Files["file"].FileName;
if (System.IO.File.Exists(fileLocation))
{
System.IO.File.Delete(fileLocation);
}
Request.Files["file"].SaveAs(fileLocation);
string excelConnectionString = string.Empty;
excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
//connection String for xls file format.
if (fileExtension == ".xls")
{
excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
}
//connection String for xlsx file format.
else if (fileExtension == ".xlsx")
{
excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
}
//Create Connection to Excel work book and add oledb namespace
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
excelConnection.Open();
DataTable dt = new DataTable();
dt = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dt == null)
{
return(null);
}
String[] excelSheets = new String[dt.Rows.Count];
int t = 0;
//excel data saves in temp file here.
foreach (DataRow row in dt.Rows)
{
excelSheets[t] = row["TABLE_NAME"].ToString();
t++;
}
OleDbConnection excelConnection1 = new OleDbConnection(excelConnectionString);
string query = string.Format("Select * from [{0}]", excelSheets[0]);
using (OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, excelConnection1))
{
dataAdapter.Fill(ds);
}
}
if (fileExtension.ToString().ToLower().Equals(".xml"))
{
string fileLocation = Server.MapPath("~/Content/") + Request.Files["FileUpload"].FileName;
if (System.IO.File.Exists(fileLocation))
{
System.IO.File.Delete(fileLocation);
}
Request.Files["FileUpload"].SaveAs(fileLocation);
XmlTextReader xmlreader = new XmlTextReader(fileLocation);
// DataSet ds = new DataSet();
ds.ReadXml(xmlreader);
xmlreader.Close();
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
NutriAppsEntities db = new NutriAppsEntities();
string query = "Insert into dbo.Recipes(IdRecipe,Name,Recipe) Values('" + ds.Tables[0].Rows[i][0].ToString() + "','" + ds.Tables[0].Rows[i][1].ToString() + "','" + ds.Tables[0].Rows[i][2].ToString() + "')";
int result = db.Database.ExecuteSqlCommand(query);
List <Recipe> lstRecipes = db.Recipes.ToList();
ViewBag.Recipes = lstRecipes;
//return View("Index");
}
}
return(View("Index"));
}
