public int Save(BookNameEntity data)
{
try
{
return(Connection.Db.Query <int>("spBookNameSet",
new
{
ID = data.Id,
BookName = data.BookName,
Writer = data.Writer,
Translator = data.Translator,
Publisher = data.Publisher,
Active = data.Active,
Language = data.Language,
Pages = data.Pages,
Viewed = data.Viewed,
InsertUserId = data.InsertUserId,
InsertDate = data.InsertDate,
Keyword = data.Keyword,
Description = data.Description,
}, commandType: CommandType.StoredProcedure).SingleOrDefault());
}
catch (Exception ex)
{
Tools.SaveLog.Save(ex);
return(-1);
}
}
public List <BookNameEntity> Search(BookNameEntity data)
{
try
{
return(Connection.Db.Query <BookNameEntity>("spBookNameSearch",
new
{
ID = data.Id,
BookName = "%" + data.BookName + "%",
Writer = "%" + data.Writer + "%",
Translator = "%" + data.Translator + "%",
Publisher = "%" + data.Publisher + "%",
Active = data.Active,
Language = "%" + data.Language + "%",
Pages = data.Pages,
Viewed = data.Viewed,
InsertUserId = data.InsertUserId,
InsertDate = "%" + data.InsertDate + "%",
Keyword = "%" + data.Keyword + "%",
Description = "%" + data.Description + "%",
}, commandType: CommandType.StoredProcedure).ToList());
}
catch (Exception ex)
{
Tools.SaveLog.Save(ex);
return(new List <BookNameEntity>());
}
}
