public static SqlDataReader SelectBankByID(int id)
{
DbParameter[] objParam = new DbParameter[1];
objParam[0] = new DbParameter("@BankId", DbParameter.DbType.NVarChar, 0, id);
return(DbConnection.GetDataReader(CommandType.StoredProcedure, "GetBankByID", objParam));
}
public static DataTable SelectBankByIDdt(int Id)
{
DbParameter[] objParam = new DbParameter[1];
objParam[0] = new DbParameter("@BankId", DbParameter.DbType.NVarChar, 0, Id);
return(DbConnection.GetDataTable(CommandType.StoredProcedure, "GetBankByID", objParam));
}
public static SqlDataReader SelectAllPackage(Guid ParlourId)
{
DbParameter[] ObjParam = new DbParameter[1];
ObjParam[0] = new DbParameter("@ParlourId", DbParameter.DbType.UniqueIdentifier, 0, ParlourId);
return(DbConnection.GetDataReader(CommandType.Text, "SELECT [pkiPackageID],[PackageName],[parlourid],[LastModified],[ModifiedUser] FROM [dbo].[TombstonePackages] Where parlourid=@parlourid and ISNULL(IsActive,1)=1 Order By PackageName ", ObjParam));
}