public static Users GetUserInfo(string userName, string pwd)
{
using (var ctx = new ExaminationEntities())
{
return(ctx.Users.FirstOrDefault(u => u.UserName.ToLower() == (userName ?? "").ToLower() && u.Password == pwd && u.PIsDel != 1));
}
}
public static void SaveBody(string weightsum, string BMI, string fatRate, string muscle,
string moisture, string boneMass, string subcutaneousFat, string BMR, string proteinRate, string physicalAge, string weightScore,
string clientId, ExamResultModel examRet)
{
using (var ctx = new ExaminationEntities())
{
var model = new Body();
model.ID = Guid.NewGuid();
model.ExamDate = DateTime.Now;
model.WeightSum = weightsum;
model.ClientID = clientId.ToGuid();
model.BMI = BMI;
model.FatRate = fatRate;
model.Muscle = muscle;
model.Moisture = moisture;
model.BoneMass = boneMass;
model.SubcutaneousFat = subcutaneousFat;
model.BMR = BMR;
model.ProteinRate = proteinRate;
model.PhysicalAge = physicalAge;
model.WeightScore = weightScore;
model.ExamRet = JsonConvert.SerializeObject(examRet);
ctx.Body.Add(model);
ctx.SaveChanges();
}
}
public static List <object> GetAllExamResult(string clientId, int pageNum, int pageSize)
{
Guid clientIdGuid = clientId.ToGuid();
List <object> allList = new List <object>();
using (var ctx = new ExaminationEntities())
{
var bloodFat = ctx.BloodFat.Where(b => b.ClientID == clientIdGuid).ToList();
var bloodOxy = ctx.BloodOxy.Where(b => b.ClientID == clientIdGuid).ToList();
var bloodPressure = ctx.BloodPressure.Where(b => b.ClientID == clientIdGuid).ToList();
var bloodSugar = ctx.BloodSugar.Where(b => b.ClientID == clientIdGuid).ToList();
var body = ctx.Body.Where(b => b.ClientID == clientIdGuid).ToList();
var cardiogram = ctx.Cardiogram.Where(b => b.ClientID == clientIdGuid).ToList();
var temperature = ctx.Temperature.Where(b => b.ClientID == clientIdGuid).ToList();
var uricAcid = ctx.UricAcid.Where(b => b.ClientID == clientIdGuid).ToList();
allList.AddRange(bloodFat);
allList.AddRange(bloodOxy);
allList.AddRange(bloodPressure);
allList.AddRange(bloodSugar);
allList.AddRange(body);
allList.AddRange(cardiogram);
allList.AddRange(temperature);
allList.AddRange(uricAcid);
}
return(allList.OrderByDescending(a => a.GetType().GetProperty("ExamDate").GetValue(a)).Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList());
}
public static bool CheckIsDuplicate(Guid id, string identity)
{
using (var ctx = new ExaminationEntities())
{
var exist = ctx.Client.FirstOrDefault(c => id != c.ID && identity.Trim() == c.ClientIdentity.Trim());
return(exist != null);
}
}
public static void DeleteClient(Guid id, Guid userId)
{
using (var ctx = new ExaminationEntities())
{
var exist = ctx.Client.FirstOrDefault(c => id == c.ID && c.UserID == userId);
ctx.Client.Remove(exist);
ctx.SaveChanges();
}
}
public static Tuple <List <Client>, int> GetClient(Guid userId, int pageSize, int pageNum)
{
using (var ctx = new ExaminationEntities())
{
var list = ctx.Client.Where(c => c.UserID == userId).OrderByDescending(c => c.CreatedDate);
int amt = list.Count();
var retList = list.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
return(new Tuple <List <Client>, int>(retList, amt));
}
}
public static void CreateClient(Client client)
{
client.ID = Guid.NewGuid();
client.UserID = OnlineUser.User.ID;
client.CreatedDate = DateTime.Now;
using (var ctx = new ExaminationEntities())
{
ctx.Client.Add(client);
ctx.SaveChanges();
}
}
public static void AddUserAdvice(Guid userId, string userAdvice)
{
using (var ctx = new ExaminationEntities())
{
var advice = new Advice();
advice.ID = Guid.NewGuid();
advice.UserID = userId;
advice.Advice1 = userAdvice;
ctx.Advice.Add(advice);
ctx.SaveChanges();
}
}
public static void UpdatePassword(Guid userId, string newPwd)
{
using (var ctx = new ExaminationEntities())
{
var user = ctx.Users.FirstOrDefault(u => u.ID == userId);
if (user != null)
{
user.Password = newPwd;
ctx.SaveChanges();
}
}
}
public static void UpdateClient(Client client)
{
using (var ctx = new ExaminationEntities())
{
var dbClient = ctx.Client.FirstOrDefault(c => c.UserID == OnlineUser.User.ID && c.ID == client.ID);
Utility.SetObjectValueWithSamePropName(client, dbClient, new List <string>()
{
"ID", "UserID", "CreatedDate"
});
ctx.SaveChanges();
}
}
public static Tuple <List <Client>, int> SearchClient(Guid userId, int pageSize, int pageNum, string key)
{
using (var ctx = new ExaminationEntities())
{
var list = ctx.Client.Where(c => c.UserID == userId &&
(
(c.Name ?? "").ToLower().Contains(key.ToLower()) ||
(c.ClientIdentity ?? "").ToLower().Contains(key.ToLower())
)).OrderBy(c => c.Name);
int amt = list.Count();
var retList = list.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
return(new Tuple <List <Client>, int>(retList, amt));
}
}
public static void SaveBloodFat(float val, string clientId, ExamResultModel examRet)
{
using (var ctx = new ExaminationEntities())
{
var model = new BloodFat();
model.ID = Guid.NewGuid();
model.ExamDate = DateTime.Now;
model.BloodFat1 = val;
model.ClientID = clientId.ToGuid();
model.ExamRet = JsonConvert.SerializeObject(examRet);
ctx.BloodFat.Add(model);
ctx.SaveChanges();
}
}
//public static ExamResultModel ExamUricAcid(float val, int sex)
//{
// string settings = ExamHelper.GetExamSettings("uricacid");
// var allSts = JsonConvert.DeserializeObject<List<List<ExamResultModel>>>(settings);
// List<ExamResultModel> standards = sex == 0 ? allSts[0] : allSts[1];
// ExamResultModel st = ExamHelper.GetCurrentStandard(val, standards);
// return st;
//}
public static void SaveUricAcid(float val, int sex, string clientId, ExamResultModel examRet)
{
using (var ctx = new ExaminationEntities())
{
var model = new UricAcid();
model.ID = Guid.NewGuid();
model.ExamDate = DateTime.Now;
model.Sex = sex;
model.UricAcid1 = val;
model.ClientID = clientId.ToGuid();
model.ExamRet = JsonConvert.SerializeObject(examRet);
ctx.UricAcid.Add(model);
ctx.SaveChanges();
}
}
//public static ExamResultModel SimpleExam(string settingName, float value)
//{
// string settings = ExamHelper.GetExamSettings(settingName);
// var standards = JsonConvert.DeserializeObject<List<ExamResultModel>>(settings);
// ExamResultModel st = ExamHelper.GetCurrentStandard(value, standards);
// return st;
//}
//public static ExamResultModel ExamBloodPressure(float highVal, float lowVal)
//{
// string settings = ExamHelper.GetExamSettings("bloodpressure");
// var standards = JsonConvert.DeserializeObject<List<List<ExamResultModel>>>(settings);
// List<ExamResultModel> highStandards = standards[0];
// List<ExamResultModel> lowStandards = standards[1];
// ExamResultModel highSt = ExamHelper.GetCurrentStandard(highVal, highStandards);
// ExamResultModel lowSt = ExamHelper.GetCurrentStandard(lowVal, lowStandards);
// if (highSt.Code > lowSt.Code)
// {
// return highSt;
// }
// else
// {
// return lowSt;
// }
//}
public static void SaveBloodPressure(float highVal, float lowVal, float heartRate, string clientId, ExamResultModel examRet)
{
using (var ctx = new ExaminationEntities())
{
var model = new BloodPressure();
model.ID = Guid.NewGuid();
model.ExamDate = DateTime.Now;
model.HighPressure = highVal;
model.LowPressure = lowVal;
model.HeartRate = heartRate;
model.ClientID = Guid.Parse(clientId);
model.ExamRet = JsonConvert.SerializeObject(examRet);
ctx.BloodPressure.Add(model);
ctx.SaveChanges();
}
}
public static void SaveBloodOxy(float val, float bpm, float pi, string clientId, object examRet)
{
using (var ctx = new ExaminationEntities())
{
var model = new BloodOxy();
model.ID = Guid.NewGuid();
model.ExamDate = DateTime.Now;
model.BloodOxy1 = val;
model.BPM = bpm;
model.PI = pi;
model.ClientID = clientId.ToGuid();
model.ExamRet = JsonConvert.SerializeObject(examRet);
ctx.BloodOxy.Add(model);
ctx.SaveChanges();
}
}
public static List <object> ViewHistory(string tableName, string clientId, DateTime fromDate, DateTime endDate)
{
using (var ctx = new ExaminationEntities())
{
Type ctxType = ctx.GetType();
var tblProp = ctxType.GetProperty(tableName);
object tblObj = tblProp.GetValue(ctx, null);
var dbRecords = GetExistRecord(tblObj, "ClientID", clientId);
IEnumerable records = dbRecords as IEnumerable;
List <object> ret = new List <object>();
foreach (object item in records)
{
DateTime examDate = GetExamDate(item);
if (examDate <= endDate && examDate >= fromDate)
{
ret.Add(item);
}
}
ret = ret.OrderByDescending(a => a.GetType().GetProperty("ExamDate").GetValue(a)).ToList();
return(ret);
}
}
private void login(object sender, RoutedEventArgs e)
{
ExaminationEntities context = new ExaminationEntities();
//if (isStudent.IsChecked == true)
//{
// string namestudent = txtUserId.Text.ToString();
// string passwordstudent = txtPassword.Password.ToString();
// var query
// = from student in context.students
// join users in context.users
// on student.StuEmail equals users.Email
// select new { users.Email, users.Password };
// foreach (var item in query)
// {
// if (item.Email == namestudent && item.Password == passwordstudent)
// {
// MessageBox.Show("welcome");
// }
// else
// {
// MessageBox.Show("te user name or password is invalid");
// }
// }
//}
//else if (isinstructor.IsChecked == true)
//{
// string namestructor = txtUserId.Text.ToString();
// string passwordstructor = txtPassword.Password.ToString();
// var query
// = from managers in context.instructors
// join instructors in context.users
// on managers.InsEmail equals instructors.Email
// where instructors.Type == "instructor"
// select new { instructors.Email, instructors.Password, instructors.Type };
// foreach (var item in query)
// {
// if (item.Email == namestructor && item.Password == passwordstructor)
// {
// InstructorDashboard formInstructor = new InstructorDashboard(txtUserId.Text);
// formInstructor.Show();
// }
// else
// {
// MessageBox.Show("te user name or password is invalid");
// }
// }
//}
//else if (ismanager.IsChecked == true)
//{
// string namemanager = txtUserId.Text.ToString();
// string passwordmanager = txtPassword.Password.ToString();
// var query
// = from managers in context.instructors
// join instructors in context.users
// on managers.InsEmail equals instructors.Email
// where instructors.Type == "manager"
// select new { instructors.Email, instructors.Password, instructors.Type };
// foreach (var item in query)
// {
// if (item.Email == namemanager && item.Password == passwordmanager)
// {
// MessageBox.Show("welcome manager");
// }
// else
// {
// MessageBox.Show("te user name or password is invalid");
// }
// }
//}
//else
//{
// MessageBox.Show("please select type");
//}
string namestudent = txtUserId.Text.ToString();
string passwordstudent = txtPassword.Password.ToString();
if (isinstructor.IsChecked == true)
{
user query = (from user in context.users
where user.Email == namestudent && user.Password == passwordstudent && user.Type == "instructor"
select user).FirstOrDefault();
if (query != null)
{
InstructorDashboard formInstructor = new InstructorDashboard(txtUserId.Text);
formInstructor.Show();
this.Close();
//ManagerDashboard i = new ManagerDashboard();
//i.Show();
//StudentDashboard u = new StudentDashboard();
//u.Show();
}
else
{
MessageBox.Show("error");
}
}
else if (ismanager.IsChecked == true)
{
user query = (from user in context.users
where user.Email == namestudent && user.Password == passwordstudent && user.Type == "manager"
select user).FirstOrDefault();
if (query != null)
{
ManagerDashboard formInstructor = new ManagerDashboard();
formInstructor.Show();
this.Close();
}
else
{
MessageBox.Show("error");
}
}
else if (isStudent.IsChecked == true)
{
user query = (from user in context.users
where user.Email == namestudent && user.Password == passwordstudent && user.Type == "student"
select user).FirstOrDefault();
if (query != null)
{
StudentDashboard s = new StudentDashboard(txtUserId.Text);
s.Show();
this.Close();
}
else
{
MessageBox.Show("error");
}
}
}
