Example #1
0
        public int Edit(Administrator Administrator)
        {
            PersonsDAO PersonsDAO = new PersonsDAO(strConnection);

            Administrator.UpdatedOn = DateTime.Now;
            Person person = Administrator.GetBase();

            int edited = PersonsDAO.Edit(person);

            if (edited <= 0)
            {
                return(edited);
            }

            using (var sql = new NpgsqlConnection(strConnection))
            {
                var resp = sql.Execute(@"UPDATE Administrators SET Position = @Position
                                            WHERE ID=@ID",
                                       new
                {
                    ID       = Administrator.ID,
                    Position = Administrator.Position
                });
                return(Administrator.ID);
            }
        }
Example #2
0
        public int Add(Administrator Administrator)
        {
            try
            {
                PersonsDAO PersonsDAO = new PersonsDAO(strConnection);
                Administrator.CreatedOn = DateTime.Now;
                Administrator.UpdatedOn = DateTime.Now;

                Person person     = Administrator.GetBase();
                int    insertedId = PersonsDAO.Add(person);
                if (insertedId < 0)
                {
                    return(insertedId);
                }
                Administrator.ID = insertedId;
            }
            catch (Exception e)
            {
                return(0);
            }
            using (var sql = new NpgsqlConnection(strConnection))
            {
                var resp = sql.Execute(@"INSERT INTO Administrators (ID, Position)
                                        VALUES (@ID, @Position)",
                                       new
                {
                    ID       = Administrator.ID,
                    Position = Administrator.Position
                });
                return(Administrator.ID);
            }
        }
        public int Edit(Patient Patient)
        {
            PersonsDAO PersonsDAO = new PersonsDAO(strConnection);

            Patient.UpdatedOn = DateTime.Now;
            Person person = Patient.GetBase();
            int    edited = PersonsDAO.Edit(person);

            if (edited <= 0)
            {
                return(edited);
            }

            using (var sql = new NpgsqlConnection(strConnection))
            {
                var resp = sql.Execute(@"UPDATE Patients SET Profession = @Profession
                                        WHERE ID=@ID",
                                       new
                {
                    ID         = Patient.ID,
                    Profession = Patient.Profession,
                });
                return(Patient.ID);
            }
        }
        public int Add(Patient Patient)
        {
            try
            {
                PersonsDAO PersonsDAO = new PersonsDAO(strConnection);
                Patient.CreatedOn = DateTime.Now;
                Patient.UpdatedOn = DateTime.Now;

                Person person     = Patient.GetBase();
                int    insertedId = PersonsDAO.Add(person);
                if (insertedId <= 0)
                {
                    return(insertedId);
                }
                Patient.ID = insertedId;
            }
            catch (Exception e)
            {
                return(0);
            }

            using (var sql = new NpgsqlConnection(strConnection))
            {
                var resp = sql.Execute(@"INSERT INTO Patients (ID, Profession)
                                        VALUES (@ID, @Profession)",
                                       new
                {
                    ID         = Patient.ID,
                    Profession = Patient.Profession,
                });
                return(Patient.ID);
            }
        }
        public int Edit(Dentist Dentist)
        {
            PersonsDAO PersonsDAO = new PersonsDAO(strConnection);

            Dentist.UpdatedOn = DateTime.Now;
            Person person = Dentist.GetBase();

            int edited = PersonsDAO.Edit(person);

            if (edited <= 0)
            {
                return(edited);
            }

            using (var sql = new NpgsqlConnection(strConnection))
            {
                var resp = sql.Execute(@"UPDATE Dentists SET Specialty = @Specialty,CRO = @CRO,Active = @Active
                                        WHERE ID=@ID",
                                       new
                {
                    ID        = Dentist.ID,
                    Specialty = Dentist.Specialty,
                    CRO       = Dentist.CRO,
                    Active    = Dentist.Active
                });
                return(Dentist.ID);
            }
        }
        public int Add(Dentist Dentist)
        {
            try
            {
                PersonsDAO PersonsDAO = new PersonsDAO(strConnection);
                Dentist.CreatedOn = DateTime.Now;
                Dentist.UpdatedOn = DateTime.Now;

                Person person     = Dentist.GetBase();
                int    insertedId = PersonsDAO.Add(person);
                if (insertedId < 0)
                {
                    return(insertedId);
                }
                Dentist.ID = insertedId;
            }
            catch (Exception e)
            {
                return(0);
            }
            using (var sql = new NpgsqlConnection(strConnection))
            {
                var resp = sql.Execute(@"INSERT INTO Dentists (ID,Specialty,CRO,Active)
                                        VALUES (@ID,@Specialty,@CRO,@Active)",
                                       new
                {
                    ID        = Dentist.ID,
                    Specialty = Dentist.Specialty,
                    CRO       = Dentist.CRO,
                    Active    = Dentist.Active
                });
                return(Dentist.ID);
            }
        }