public void CreateUserData(USER_DATA data)
{
using (var context = new DietDbContext())
{
context.CREATEUSERDATA(data.HEIGHT, data.WEIGHT, data.USER_ID);
context.SaveChanges();
}
}
public void CreateUserEntry(string name, UserDataViewModel vm)
{
var id = ((UserRepostiory)_repostiory).GetUserIdByName(name);
var data = new USER_DATA()
{
HEIGHT = vm.Height,
WEIGHT = vm.Weight,
ENTRY_DATE = DateTime.Now,
USER_ID = id
};
_repostiory.CreateUserData(data);
}
public static void AddUserData(string comment, string servName, string servPassword, int userId)
{
USER_DATA data = new USER_DATA()
{
APP_USER_ID = userId,
COMMENT = comment,
SERV_NAME = servName,
SERV_PASSWORD = MyAes.EncryptStringToString(servPassword)
};
using (var db = new DbModel())
{
db.USER_DATA.Add(data);
db.SaveChanges();
}
}
public async Task <ActionResult> Create(DataEntryUser data_entry)
{
Session["perdoruesi"] = null;
var user = await GetUser();
MessageJS returnmodel = new MessageJS();
if (ModelState.IsValid)
{
try
{
USER_DATA addmodel = new USER_DATA();
addmodel.ID = data_entry.ID;
addmodel.BloodGlucose = data_entry.Glukoza;
addmodel.UserID = user.ID;
var bmi = Convert.ToDouble(data_entry.Pesha) / Math.Pow(Convert.ToDouble(data_entry.Gjatesia / 100), 2);
addmodel.BMI = Convert.ToDecimal(bmi.ToString("0.00"));
var lista = db.USER_DATA.Where(q => q.UserID != user.ID).ToList();
List <ListaKnn> lista_knn = new List <ListaKnn>();
double neighbors_distance = 0;
foreach (var item in lista)
{
var distanca = Math.Pow(Convert.ToDouble(item.BMI.Value - Convert.ToDecimal(bmi)), 2) + Math.Pow(Convert.ToDouble(item.BloodGlucose.Value - data_entry.Glukoza), 2);
neighbors_distance = Math.Sqrt(distanca);
lista_knn.Add(new ListaKnn()
{
distanca = neighbors_distance,
userID = item.UserID.Value,
classification = item.HasDiabet.Value
});
}
//knn
int k = 5;
var selekto_perdoruesit = (from t in lista_knn orderby t.distanca descending select t).ToList().Take(k);
var count_false = (from bashkesia in selekto_perdoruesit where bashkesia.classification = false select bashkesia).ToList();
var count_true = (from bashkesia in selekto_perdoruesit where bashkesia.classification = true select bashkesia).ToList();
bool klasifikimi = false;
var perdoruesit_me_afert = count_false.OrderByDescending(q => q.distanca).FirstOrDefault();
if (count_false.Count() < count_true.Count())
{
klasifikimi = true;
perdoruesit_me_afert = count_true.OrderByDescending(q => q.distanca).FirstOrDefault();
}
Session["perdoruesi"] = db.USER_DATA.Where(q => q.UserID == perdoruesit_me_afert.userID).FirstOrDefault();
addmodel.HasDiabet = klasifikimi;
db.USER_DATA.Add(addmodel);
await db.SaveChangesAsync();
returnmodel.Status = true;
returnmodel.ID = addmodel.ID;
return(Json(returnmodel, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
returnmodel.Status = false;
returnmodel.Message = "Ka ndodhur një gabim";
return(Json(returnmodel, JsonRequestBehavior.DenyGet));
}
}
else
{
var errors = ModelState.Select(x => x.Value.Errors)
.Where(y => y.Count > 0)
.ToList();
}
returnmodel.Status = false;
return(Json(returnmodel, JsonRequestBehavior.DenyGet));
}
