public List<DrugHistory> GetDrugHistories(int benhnhanid, DateTime datetime)
 {
     var db = new DrugDBDB();
     List<DrugHistory> list = db.DrugHistories.Where(p => p.BenhNhanID == benhnhanid
                                             && p.Date.Value.Year == datetime.Year
                                             && p.Date.Value.Month == datetime.Month
                                             && p.Date.Value.Day == datetime.Day
     ).ToList();
     return list;
 }
 public List<BenhNhan> GetBenhNhanByDate(int day, int month, int year)
 {
     var db = new DrugDBDB();
     List<int> ids = db.DrugHistories.Where(p => (p.Date.Value.Day == day || day == 0)
                                                && p.Date.Value.Month == month
                                                && p.Date.Value.Year == year)
                                     .OrderBy(p=>p.Date)
                                     .Select(p=>p.BenhNhanID).ToList();
     List<BenhNhan> list = db.BenhNhans.Where(p => ids.Contains(p.ID)).ToList();
     return list;
 }
 public int create(string name, string phone , DateTime birth)
 {
     var db = new DrugDBDB();
     int res = (int)db.BenhNhans.InsertWithIdentity(() => new BenhNhan()
     {
         Name = name,
         Phone = phone,
         BirthDay = birth
     });
     return res;
 }
 public List<BenhNhan> GetBenhNhanByName(string[] names)
 {
     List<BenhNhan> list = new List<BenhNhan>();
     var db = new DrugDBDB();
     foreach (string name in names)
     {
         var bns = db.BenhNhans.Where(p => p.Name.ToLower().Contains(name.ToLower())).ToList();
         list.AddRange(bns);
     }
     list = list.Distinct(new GenericCompare<BenhNhan>(p=>p.ID)).ToList();
     return list;
 }
        public dynamic GetDrugHistoryDatetimeByBenhNhan(int benhnhanid)
        {
            var db = new DrugDBDB();
            var list = db.DrugHistories.Where(p => p.BenhNhanID == benhnhanid)
                                        //.Distinct(new GenericCompare<DrugHistory>(p=>p.DrugName.ToLower()))
                                        .OrderByDescending(p => p.Date).ToList();
            var group = list.GroupBy(p => new { p.Date.Value.Year, p.Date.Value.Month, p.Date.Value.Day})
                            .Select(g => new
                            {
                                BenhNhanID = benhnhanid,
                                DateTime = new DateTime(g.Key.Year, g.Key.Month, g.Key.Day),
                                Count = g.Count()
                            });
            dynamic dyn = new ExpandoObject();
            dyn.Group = group.ToList();

            return dyn;
        }
 public List<BenhNhan> GetBenhNhanByPhone(string phone)
 {
     var db = new DrugDBDB();
     List<BenhNhan> list = db.BenhNhans.Where(p => p.Phone.Contains(phone)).ToList();
     return list;
 }
 public List<BenhNhan> GetBenhNhanById(string id)
 {
     var db = new DrugDBDB();
     List<BenhNhan> list = db.BenhNhans.Where(p => p.ID.ToString().Contains(id)).ToList();
     return list;
 }
 public BenhNhan GetBenhNhanByID(int id)
 {
     var db = new DrugDBDB();
     BenhNhan bn = db.BenhNhans.FirstOrDefault(p => p.ID == id);
     return bn;
 }
 public void DeleteDrugHistory(int id)
 {
     var db = new DrugDBDB();
     db.DrugHistories.Where(p => p.ID == id).Delete();
 }
Esempio n. 10
0
        public int Update(DrugHistory dh)
        {
            int res = 0;
            var db = new DrugDBDB();
            if (dh.ID != 0)
            {
                res = (int)db.DrugHistories.Where(p=>p.ID == dh.ID).Update(t => new DrugHistory()
                {
                    DrugName = dh.DrugName,
                    BenhNhanID = dh.BenhNhanID,
                    Count = dh.Count,
                    Unit = dh.Unit,
                    Price = dh.Price,
                    Date = dh.Date
                });
                if (res == 1)
                {
                    res = dh.ID;
                }
            }
            else
            {
                 res = (int)db.DrugHistories.InsertWithIdentity(() => new DrugHistory()
                            {
                                DrugName = dh.DrugName,
                                BenhNhanID = dh.BenhNhanID,
                                Count = dh.Count,
                                Unit = dh.Unit,
                                Price = dh.Price,
                                Date = dh.Date
                            });

            }

            return res;
        }