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