private Author FillAuthor(SqlDataReader reader)
{
var author = new Author();
author.Id = reader.GetInt32(0);
author.Name = reader.GetString(1);
author.Email = reader.GetString(2);
author.Password = reader.GetString(3);
author.IsActive = reader.GetBoolean(4);
author.DateCreated = reader.GetDateTime(5);
return author;
}
public void Update(Author obj)
{
var procedure = new ProcedureSql("Update_Author");
procedure.AddParameter("@Id", obj.Id);
procedure.AddParameter("@Name", obj.Name);
procedure.AddParameter("@Email", obj.Email);
procedure.AddParameter("@Password", obj.Password);
procedure.AddParameter("@IsActive", obj.IsActive);
procedure.Execute();
}
public void Add(Author obj)
{
var procedure = new ProcedureSql("Add_Author");
procedure.AddParameter("@Id", SqlDbType.Int, ParameterDirection.Output);
procedure.AddParameter("@Name", obj.Name);
procedure.AddParameter("@Email", obj.Email);
procedure.AddParameter("@Password", obj.Password);
procedure.AddParameter("@IsActive", obj.IsActive);
procedure.AddParameter("@DateCreated", obj.DateCreated);
obj.Id = procedure.Insert();
}
public IValidationResult Add(Author obj)
{
if (obj == null)
throw new NullReferenceException("obj");
obj.DateCreated = DateTime.UtcNow;
var validationResult = this.authorValidation.Validate(obj);
if (validationResult.IsValid)
this.authorRepository.Add(obj);
return validationResult;
}
public IValidationResult Update(Author obj)
{
if (obj == null)
throw new NullReferenceException("obj");
var author = this.GetById(obj.Id);
if (author == null)
throw new Exception(string.Format("Author {0} not found.", obj.Id));
author.IsActive = obj.IsActive;
author.Name = obj.Name;
author.Email = obj.Email;
var validationResult = this.authorValidation.Validate(author);
if (validationResult.IsValid)
this.authorRepository.Update(author);
return validationResult;
}
public IValidationResult Update(Author obj)
{
return authorService.Update(obj);
}
public IValidationResult Add(Author obj)
{
return authorService.Add(obj);
}