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