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