public List <t> GetHash <t>(string HashVersion = "") { Hashtable Parameters = new Hashtable { { "Operation", "GetHash" + (!string.IsNullOrEmpty(HashVersion) ? "-" + HashVersion : "") } }; return(SQLServer.Query().Retrieve <t>(CommandType.StoredProcedure, _CommandText, Parameters)); }
public List <t> GetList <t>() { Hashtable Parameters = new Hashtable { { "Operation", "GetList" } }; return(SQLServer.Query().Retrieve <t>(CommandType.StoredProcedure, _CommandText, Parameters)); }
public t GetByID <t>(int ID) { Hashtable Parameters = new Hashtable { { "Operation", "GetByID" }, { "ID", ID } }; return(SQLServer.Query().Singular <t>(CommandType.StoredProcedure, _CommandText, Parameters)); }
public List <t> GetByParentID <t>(string ParentID) { Hashtable Parameters = new Hashtable { { "Operation", "GetByParentID" }, { "ParentID", ParentID } }; return(SQLServer.Query().Retrieve <t>(CommandType.StoredProcedure, _CommandText, Parameters)); }
public bool Delete(string ID) { Hashtable Parameters = new Hashtable { { "Operation", "Delete" }, { "ID", ID } }; return(SQLServer.Query().Execute(CommandType.StoredProcedure, _CommandText, Parameters)); }
public List <t> GetAll <t>(string PartitionKey) { Hashtable Parameters = new Hashtable { { "Operation", "GetAll" }, { "PartitionKey", PartitionKey } }; return(SQLServer.Query().Retrieve <t>(CommandType.StoredProcedure, _CommandText, Parameters)); }
public List <t> GetByStatus <t>(string Status) { Hashtable Parameters = new Hashtable { { "Operation", "GetByStatus" }, { "Status", Status } }; return(SQLServer.Query().Retrieve <t>(CommandType.StoredProcedure, _CommandText, Parameters)); }
public t GetByID <t>(string PartitionKey, string RowKey) { Hashtable Parameters = new Hashtable { { "Operation", "GetByID" }, { "PartitionKey", PartitionKey }, { "RowKey", RowKey } }; return(SQLServer.Query().Singular <t>(CommandType.StoredProcedure, _CommandText, Parameters)); }
public bool Delete(string PartitionKey, string RowKey) { Hashtable Parameters = new Hashtable { { "Operation", "Delete" }, { "PartitionKey", PartitionKey }, { "RowKey", RowKey } }; return(SQLServer.Query().Execute(CommandType.StoredProcedure, _CommandText, Parameters)); }
public bool Save <t>(t Item) { return(SQLServer.Query().Execute(CommandType.StoredProcedure, _CommandText, Niffler.Data.Objects.ToHashTable <t>(Item, "Save"))); }
public List <t> GetByObject <t>(t Item) { return(SQLServer.Query().Retrieve <t>(CommandType.StoredProcedure, _CommandText, Niffler.Data.Objects.ToHashTable <t>(Item, "GetByObject"))); }