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