示例#1
0
        public static object DeleteReception(int Id)
        {
            try
            {
                //using context and LINQ
                using (var ctx = new HospitalDatabaseEntities())
                {
                    //Выглядит странно, но это так и делается
                    Reception deleteThis = new Reception()
                    {
                        Id = Id
                    };
                    ctx.Reception.Attach(deleteThis);
                    ctx.Reception.Remove(deleteThis);

                    ctx.SaveChanges(); //Иначе ничего не сохраняет в БД из контекста
                }

                return(new { Result = "OK" });
            }
            catch (Exception ex)
            {
                return(new { Result = "ERROR", Message = ex.Message });
            }
        }
示例#2
0
        public static object UpdateDoctor(Doctor record)
        {
            try
            {
                //using context and LINQ
                using (var ctx = new HospitalDatabaseEntities())
                {
                    var foundDoctor = ctx.Doctor.FirstOrDefault(s => s.Id == record.Id);
                    if (foundDoctor == null)
                    {
                        throw new Exception("Запись не найдена!");
                    }

                    foundDoctor.Surname  = record.Surname;
                    foundDoctor.Name     = record.Name;
                    foundDoctor.Age      = record.Age;
                    foundDoctor.Gender   = record.Gender;
                    foundDoctor.Position = record.Position;

                    ctx.SaveChanges(); //Иначе ничего не сохраняет в БД из контекста
                }

                return(new { Result = "OK" });
            }
            catch (Exception ex)
            {
                return(new { Result = "ERROR", Message = ex.Message });
            }
        }
示例#3
0
        public static object UpdateReception(Reception record)
        {
            try
            {
                //using context and LINQ
                using (var ctx = new HospitalDatabaseEntities())
                {
                    var foundReception = ctx.Reception.FirstOrDefault(s => s.Id == record.Id);
                    if (foundReception == null)
                    {
                        throw new Exception("Запись не найдена!");
                    }

                    foundReception.Doctor_Id  = record.Doctor_Id;
                    foundReception.Patient_Id = record.Patient_Id;
                    foundReception.Date       = record.Date;

                    ctx.SaveChanges(); //Иначе ничего не сохраняет в БД из контекста
                }

                return(new { Result = "OK" });
            }
            catch (Exception ex)
            {
                return(new { Result = "ERROR", Message = ex.Message });
            }
        }
示例#4
0
        //Количество Doctor в таблице
        private static int returnCountOfDoctors()
        {
            int CountOfDoctors = 0;

            //using context and LINQ
            using (var ctx = new HospitalDatabaseEntities())
            {
                CountOfDoctors = ctx.Doctor.Count();
            }

            return(CountOfDoctors);
        }
示例#5
0
        private static int returnCountOfReceptions()
        {
            int CountOfReceptions = 0;

            //using context and LINQ
            using (var ctx = new HospitalDatabaseEntities())
            {
                CountOfReceptions = ctx.Reception.Count();
            }

            return(CountOfReceptions);
        }
示例#6
0
        public static object CreateReception(Reception record)
        {
            try
            {
                //using context and LINQ
                using (var ctx = new HospitalDatabaseEntities())
                {
                    ctx.Reception.Add(record);
                    ctx.SaveChanges(); //Иначе ничего не сохраняет в БД из контекста
                }

                return(new { Result = "OK", Record = record });
            }
            catch (Exception ex)
            {
                return(new { Result = "ERROR", Message = ex.Message });
            }
        }
示例#7
0
        //Чтение страницы с сортировкой из Doctor
        private static List <Doctor> returnPartOfDoctorsWithSorting(int jtStartIndex, int jtPageSize, string jtSorting)
        {
            List <Doctor> mylist = new List <Doctor>();

            //Это работает, но громоздко, мягко говоря. Зато context и LINQ
            using (var ctx = new HospitalDatabaseEntities())
            {
                var query = from a in ctx.Doctor select a;

                // Сортировка

                //sort by name
                if (string.IsNullOrEmpty(jtSorting) || jtSorting.Equals("Name ASC"))
                {
                    query = query.OrderBy(p => p.Name);
                }
                else if (jtSorting.Equals("Name DESC"))
                {
                    query = query.OrderByDescending(p => p.Name);
                }

                //sort by gender
                else if (jtSorting.Equals("Gender ASC"))
                {
                    query = query.OrderBy(p => p.Gender);
                }
                else if (jtSorting.Equals("Gender DESC"))
                {
                    query = query.OrderByDescending(p => p.Gender);
                }

                //sort by surname
                else if (jtSorting.Equals("Surname ASC"))
                {
                    query = query.OrderBy(p => p.Surname);
                }
                else if (jtSorting.Equals("Surname DESC"))
                {
                    query = query.OrderByDescending(p => p.Surname);
                }

                //sort by id
                else if (jtSorting.Equals("Id ASC"))
                {
                    query = query.OrderBy(p => p.Id);
                }
                else if (jtSorting.Equals("Id DESC"))
                {
                    query = query.OrderByDescending(p => p.Id);
                }

                //sort by age
                else if (jtSorting.Equals("Age ASC"))
                {
                    query = query.OrderBy(p => p.Age);
                }
                else if (jtSorting.Equals("Age DESC"))
                {
                    query = query.OrderByDescending(p => p.Age);
                }

                //sort by position
                else if (jtSorting.Equals("Position ASC"))
                {
                    query = query.OrderBy(p => p.Position);
                }
                else if (jtSorting.Equals("Position DESC"))
                {
                    query = query.OrderByDescending(p => p.Position);
                }

                //Default
                else
                {
                    query = query.OrderBy(p => p.Surname);
                }

                var result = query.Skip(jtStartIndex).Take(jtPageSize).ToList(); //Paging

                //Иначе некорректная связь с Reception генерируется. Пересоздаём
                for (int i = 0; i < result.Count; i++)
                {
                    mylist.Add(new Doctor
                    {
                        Age      = result[i].Age,
                        Gender   = result[i].Gender,
                        Id       = result[i].Id,
                        Name     = result[i].Name,
                        Position = result[i].Position,
                        Surname  = result[i].Surname
                    });
                }

                return(mylist);
            }
        }
示例#8
0
        private static List <Reception> returnPartOfReceptionsWithSorting(int jtStartIndex, int jtPageSize, string jtSorting)
        {
            //int counterForTakeAPart = 0;
            List <Reception> mylist = new List <Reception>();

            //Это работает, но громоздко, мягко говоря. Зато context и LINQ
            using (var ctx = new HospitalDatabaseEntities())
            {
                var query = from a in ctx.Reception select a;

                // Сортировка

                //sort by Doctor_Id
                if (string.IsNullOrEmpty(jtSorting) || jtSorting.Equals("Doctor_Id ASC"))
                {
                    query = query.OrderBy(p => p.Doctor_Id);
                }
                else if (jtSorting.Equals("Doctor_Id DESC"))
                {
                    query = query.OrderByDescending(p => p.Doctor_Id);
                }

                //sort by Patient_Id
                else if (string.IsNullOrEmpty(jtSorting) || jtSorting.Equals("Patient_Id ASC"))
                {
                    query = query.OrderBy(p => p.Patient_Id);
                }
                else if (jtSorting.Equals("Patient_Id DESC"))
                {
                    query = query.OrderByDescending(p => p.Patient_Id);
                }

                //sort by Id
                else if (string.IsNullOrEmpty(jtSorting) || jtSorting.Equals("Id ASC"))
                {
                    query = query.OrderBy(p => p.Id);
                }
                else if (jtSorting.Equals("Id DESC"))
                {
                    query = query.OrderByDescending(p => p.Id);
                }

                //sort by Date
                else if (string.IsNullOrEmpty(jtSorting) || jtSorting.Equals("Date ASC"))
                {
                    query = query.OrderBy(p => p.Date);
                }
                else if (jtSorting.Equals("Date DESC"))
                {
                    query = query.OrderByDescending(p => p.Date);
                }

                //Default
                else
                {
                    query = query.OrderBy(p => p.Date);
                }

                var result = query.Skip(jtStartIndex).Take(jtPageSize).ToList(); //Paging

                //Иначе некорректная связь с Reception генерируется. Пересоздаём
                for (int i = 0; i < result.Count; i++)
                {
                    mylist.Add(new Reception
                    {
                        Id         = result[i].Id,
                        Patient_Id = result[i].Patient_Id,
                        Doctor_Id  = result[i].Doctor_Id,
                        Date       = result[i].Date
                    });
                }

                return(mylist);
            }
        }