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