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); } }