public async Task <int> UpdateAuthor(string authorId, Author author)
{
int DbResult = 0;
if (!String.IsNullOrEmpty(authorId) && dataReqiered.IsDataNoEmpty(author))
{
int oldDataAuthorId = Convert.ToInt32(authorId);
int newDataAuthorId = Convert.ToInt32(author.Id);
AuthorMsSql updatingAuthor = null;
updatingAuthor = await db.Authors.FindAsync(oldDataAuthorId);
if (oldDataAuthorId == newDataAuthorId)
{
updatingAuthor.Name = author.Name;
updatingAuthor.Surname = author.Surname;
db.Entry(updatingAuthor).State = EntityState.Modified;
try
{
DbResult = await db.SaveChangesAsync();
}
catch
{
return(DbResult);
}
}
}
return(DbResult);
}
public async Task <int> DeleteAuthor(string authorId)
{
int DbResult = 0;
if (!String.IsNullOrEmpty(authorId))
{
int delAuthorId = Convert.ToInt32(authorId);
AuthorMsSql author = await db.Authors.FindAsync(delAuthorId);
if (author != null)
{
db.Authors.Remove(author);
DbResult = await db.SaveChangesAsync();
}
}
return(DbResult);
}
public async Task <int> CreateAuthor(Author author)
{
int DbResult = 0;
if (dataReqiered.IsDataNoEmpty(author))
{
AuthorMsSql newAuthor = new AuthorMsSql {
Name = author.Name, Surname = author.Surname
};
db.Authors.Add(newAuthor);
try
{
DbResult = await db.SaveChangesAsync();
}
catch
{
return(DbResult);
}
}
return(DbResult);
}