public Item GetById(int id) { Dictionary <string, object> inputParams = new Dictionary <string, object>(); inputParams.Add("@id", id); return(DBDataAccessor.GetItem(connectionString, "[dbo].[ItemGetDataById]", CommandType.StoredProcedure, SetItem, inputParams)); }
public bool DeleteData(int id) { Dictionary <string, object> inputParams = new Dictionary <string, object>(); inputParams.Add("@ItemId", id); return(DBDataAccessor.UpdateData(connectionString, "[dbo].[ItemDeleteData]", CommandType.StoredProcedure, inputParams)); }
public bool UpdateData(Item oneItem) { Dictionary <string, object> inputParams = new Dictionary <string, object>(); inputParams.Add("@ItemId", oneItem.ItemID); inputParams.Add("@Price", oneItem.Price); inputParams.Add("@Description", oneItem.Description); return(DBDataAccessor.UpdateData(connectionString, "[dbo].[ItemUpdateData]", CommandType.StoredProcedure, inputParams)); }
public List <Item> GetDataList(string filterParm = null, string sort = null, bool isSortDirAsc = false) { Dictionary <string, object> inputParams = new Dictionary <string, object>(); if (!string.IsNullOrEmpty(filterParm)) { inputParams.Add("@filter", filterParm); } if (!string.IsNullOrEmpty(sort)) { inputParams.Add("@sort", string.Format("{0}", sort)); } inputParams.Add("@isSortDirAsc", isSortDirAsc); return(DBDataAccessor.GetItemList(connectionString, "[dbo].[ItemGetData]", CommandType.StoredProcedure, SetItem, inputParams)); }
public int GetItemCount() { return(DBDataAccessor.GetScalar <int>(connectionString, "", CommandType.StoredProcedure, null)); }